How to list only 1 results with multiple queries

[Casey Maynard]

Example:
I have a JIRA query for all of my projects.  The results are 5912.

I want to see just the names of the projects, so only 1 example needs to be listed.

[Nic Brough -Adaptavist-]

A Jira query finds issues, not projects, so it's probably already giving you the right answer.

I'd summarise probably.  Save your filter, create a dashboard, and add a "filter statistics" gadget to it.  Select your filter and the "field" called Project.  You'll get a bar chart listing the number of issues in each project.

[Casey Maynard]

The only solution I have found is to limit the table results to 1.

[Alexey Matveev]

Hello,

How to make the query? Rest Api?

[Casey Maynard]

Just using the Issue JQL Search page.

I know it is giving me the results it should be but I want to filter it down to only show 1 results if there is more than 1 results.  Similar to the Excel 'unique records only' option.

[Nic Brough -Adaptavist-]

The way to get a unique record with JQL is to filter it down to just the one single unique issue you want to see.

The result in JQL is a list of issues that already gives you "unique records only" - each issue returned is unique.

I suspect I am missing something here, as it sounds like you are looking for a single result from a search that could be returning many, but I don't understand why you only want a single result, or which one to pick when there are many.

[Casey Maynard]

I think the terminology that I should have been using is 'returning many', but I only want one 'example' of 'the many' listed.  As all of the results have the 'same' answers, but I only need to see one.  Is there a way to see this single result?

[Alexey Matveev]

There is no way to see only one example of the many listed in JQL.