how could I get a dashboard that would list the Active projects?

[Jira n Confluence explorer]

A list should include all those projects that have had an update in last 6 moths.

List should not include closed /completed projects.

There is a Gadget 'Project list'  but it does not allow me to set further filters.

[Jack Brickey · Accepted solution]

Hi @Jira n Confluence explorer , welcome to the Community.

Dashboard gadgets are generally driven by JQL filters and JQL searches are associated with work items (issues) not projects. There isn't a query to find "projects" that have been updated. However, you could use the following JQL to find issues that have been updated within roughly the last 6 months.

updated >= startofmonth(-6)

You could then use the filter in a Pie Chart gadget and select Project as the statistic.

you can adjust the JQL to achieve your exact timeframe. let me know if that helps.

[Jira n Confluence explorer]

it worked, thanks @Jack Brickey 

[Jack Brickey]

@Jira n Confluence explorer great Great! please consider accepting the answer.