How can I modify my jql to run faster?

[Rasmus Vinther]

Hi I have the following query which takes quite long to run. 

I believe it is the part issueFunction in issueFieldMatch() which is causing the long run times. What does this part do and can I do it in another way?

"Program Increment" ~ MA-PI-20 AND (issueFunction in issueFieldMatch("category = 'M&A' ", "WBS Element", TC-) OR issueFunction in issueFieldMatch("category = 'M&A' ", "WBS Element", TE-) OR "WBS Element" is EMPTY) AND project not in ("M&A Maintenance", "Service Cost Model") AND Sprint is not EMPTY AND Sprint in (17016, 17017, 17018, 17019, 17020)

[Mohamed Benziane]

Hi,

Welcome to the community

I think this link would help you

https://docs.adaptavist.com/sr4js/latest/features/jql-functions/included-jql-functions/calculations

and this one too

https://docs.adaptavist.com/sr4js/latest/features/jql-functions/performance