Hi All, I need some help with the below ScriptRunner query. I tried using it, but it is returning an

[Suraj]

Hi All, I need some help with the below ScriptRunner query. I tried using it, but it is returning an error. Could someone please check and share the correct query?

project = "Store Associate Technology ART" AND
"Team[Team]" = 45e61e11-ae1c-4bbf-8993-8778f6f9eca4 AND
issuetype = Story AND
issueFunction in linkedIssuesOf("issuetype = Bug AND created > statusChangedDate('Done')", "relates to")

[Aaron Pavez _ServiceRocket_]

Hi @Suraj 

Where are you trying to run this? This is a JQL query you need to run under Search work items.

Can you tell us where exactly you are running this?

Regards

[Suraj]

Hi @Aaron Pavez _ServiceRocket_ 

I am running in script runner app, 

[Aaron Pavez _ServiceRocket_]

As mentioned, that's a JQL query, not Scriptrunner. Unless you run this in the ScriptRunner Enhanced Search.

Regards

[Suraj]

where you can see this i am running this ScriptRunner @Aaron Pavez _ServiceRocket_ 

[Aaron Pavez _ServiceRocket_]

Got it. Can you tell us what you are trying to achieve with this part?

AND issueFunction in linkedIssuesOf("issuetype = Bug AND created > statusChangedDate('Done')", "relates to")

regards

[Aaron Pavez _ServiceRocket_]

The problem is between these two values

created > statusChangedDate('Done')

Created is a datetime field.

statuschangeddate is a function.

Cannot compare those two.

This one works:

and issueFunction in linkedIssuesOf("issuetype = Bug", "relates to")

But comparing a datetime to a function, it won't. You need to compare something else.

regards

[Suraj]

Thanks @Aaron Pavez _ServiceRocket_