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 · Accepted solution]

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. 

[Yash Pradhan]

Hi Rizwan,
I ran your provided query for the requirement but the results are still coming the same.
When i am using this text ~ Distance_ServiceCredentials  the results are showing 2 within the product name salesforce itself.

[Yash Pradhan]

@Rilwan Ahmed  Any Update on this!!

[Rilwan Ahmed]

Hi @Yash Pradhan ,

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]

is not same as JQL  "text ~ Distance_ServiceCredentials"

So please check the result from second JQL and manually check if it is satisfying all conditions given in first JQL. i.e. issuetype, status, Deployment dates, product name, impacted components