JQL Queries for Project, request type, status and organizations

[Maeneth]

Hi,

Kindly assist me in making a JQL filter queries that will display request type, status, organization of a specific JSM project that I can use in making a dashboard?

Thanks!

[Iryna Komarnitska_SaaSJet_ · Accepted solution]

Hi @Maeneth 

Try using a free gadget that my team has developed - Text to JQL.
You enter your query in everyday language, how you communicate, and it transforms your question into JQL.

I hope it will be helpful for you!

[Walter Buggenhout]

Hi @Maeneth,

A JQL filter simply fetches a list of issues, based on criteria. So will the following JQL list all issues in Project A:

Project = "Project A"

All the attributes (request type, status, organization, ...) will be returned with every issue.

If you want to display these attributes in gadgets on a dashboard, you will see that some gadgets will let you configure the attributes you want to use as columns (e.g. the Filter Results gadget), slice (of a Pie Chart gadget), dimension (of a Two Dimensional Filter Statistics gadget), ...

So as a step by step approach:

1. Navigate to Filters > advanced search 
2. Retrieve the list of issues you want to return using basic search or JQL (e.g. all issues in a project, only open issues in a project, only new issues, ...
3. Save the search as a filter
4. On a dashboard, add gadgets to your liking and configure each gadget with the right information, using the filter(s) you created beforehand.

Hope this helps!

[Maeneth]

Im not able to create filter by Organization