How to create custom search

[Mohammed Alharbi]

Hi, I am new to Jira and was wondering if I could perform some sort of custom view or a custom search where I want to display all issues that are under some specific statuses(new, in progress), and at the same time display some tasks under other statuses with a condition (late or on-hold tasks that has been updated during a time interval ).

appreciate all the help I can get as I am new to Jira and tried searching for something similar and couldn't find anything  

[Trudy Claspill · Accepted solution]

You would need to use the "Switch to JQL" option and write the Jira Query Language syntax for this. The Basic Search option does not allow you to create an OR query, which is what you need.

To get all issues with a specific Status values currently you would do

Status in (<comma separated list of Status values>)
i.e.
Status in ("New", "In Progress")

To all include another set of issues that meet different conditions you need to add an OR...

Status in ("New", "In Progress") OR

...and add a clause for that different set of conditions.

Status in ("New", "In Progress") OR (<other conditions>)

For the additional conditions you specified:

status is late or on-hold and issue has been updated during an interval

you would do something like this:

status in ("late","on-hold") and Updated > <start of interval> and updated < <end of interval>

"Updated" is the date/timestamp field that is records the last time an issue was changed in any way. There are syntax rules to how you specify dates and times in JQL, and there are also some built in functions you can use like "startOfDay()" and "endOfDay()". If you tell us more about the details of the interval we can provide more specific help.

You search filter would end up looking something like this:

Status in ("New", "In Progress") OR (Status in ("late","on-hold") and Updated > <start of interval> and updated < <end of interval>)

[Mohammed Alharbi]

Hi Trudy, thank you so much for the help and the efforts you put into the JQL, I am new to Jira and the fact that there is something akin to search language has struck me surprised, for the time intervals I want to be able to get the issues that were updated in last 7 days, I will need to research more to find the syntax rules that you mentioned that could fulfill that, but I genuinely appreciate your help, Thanks a lot

[Ravi Sagar _Sparxsys_ · Accepted solution]

Hi @Mohammed Alharbi 

You can find lot of information on this page: https://support.atlassian.com/jira-software-cloud/docs/what-is-advanced-searching-in-jira-cloud/

You can do something like this.

status = New

or

status in (late, "on-hold") 

You can check the link to find out about various operators that you can use in your query. You can also start by using the basic search in Jira.

To perform search (or write these queries), click on the search box | issues.

I hope it helps.

Ravi 

[Mohammed Alharbi]

thanks Ravi for directing me, I will try to read more and get deeper knowledge regarding the search capabilities of Jira