jira string like query missing in links

[Livio Patavini]

I have the following filter:

project = "Production Environment" and (status = "Approved" or status = "IN PROGRESS" or status = "Under Review") and "Pre-prod Date[Date]" < startOfDay() and description ~ ".sql" ORDER BY cf[11497] ASC

it works good, but the related dashboard using it, seems not return the jira issues including the ".sql" word when it is included inside a jira generated url like:

Execute SQL script: PROD-9999.sql

[Rilwan Ahmed]

Hi @Livio Patavini ,

"the related dashboard using it, seems not return the jira issues including the ".sql"" 
-- Can you tell us what gadget is being used in the dashboard. Some screenshots will help us identify it properly. 
Also please check if the filter saved in shared with correct users. 

I created a sample jira work item with .sql text in description field and the gadgets in the dashboard are showing the results. 

Please note: If you have attached the .sql file in the description field and trying to search, then this will not work. 

Just a suggestion:
Instead of using  (status="Approved"orstatus="IN PROGRESS"orstatus="Under Review")  you can use IN operator
Example: Status in ("Approved", IN PROGRESS", Under Review")

[Livio Patavini]

we use, Filter Results as kind of gadget.

[Kai Becker]

Hi @Livio Patavini 

could you try to use

~ "*.sql"

More information on wildcards can be found here: https://confluence.atlassian.com/jirasoftwareserver/search-syntax-for-text-fields-939938747.html

[Livio Patavini]

already tried, same result