Unable to find the results after running this Query.

Yash Pradhan

Dear Team,

As we need to find the particular change in our project, this is the query we are using

(project in ("Release Deployment Project", "Third Party Release Management ") AND issuetype = "Change Request " AND status not in ("Technical Approved", "Conditional Approved") AND "Deployment Date[Date]" >= 2023-06-01 AND "Deployment Date[Date]" < 2024-1-09 and "Product Name[Dropdown]" = "Sales Force" and "Impacted Components[Paragraph]" ~ Distance_ServiceCredentials ORDER BY cf[10140])

But After running it through it shows no result, Meanwhile when i enter the Distance_ServiceCredentials  name manually in the search bar it is showing the result.

Attach SS for the reference, Can we we know the reason behind it.

Rilwan Ahmed

Hi @Yash Pradhan ,

As you are using AND, the tickets should match each condition. I have simplified your query line by line. Check if the tickets fall under these conditions.

(
project in ("Release Deployment Project", "Third Party Release Management ")
AND issuetype = "Change Request "
AND status not in ("Technical Approved", "Conditional Approved")
AND "Deployment Date[Date]" >= 2023-06-01
AND "Deployment Date[Date]" < 2024-1-09
and "Product Name[Dropdown]" = "Sales Force"
and "Impacted Components[Paragraph]" ~ Distance_ServiceCredentials
ORDER BY cf[10140]
)

 

Please note:
"text ~ Distance_ServiceCredentials" JQL will list any ticket in any project if the value is present in any field.