Wrong results while executing JQL query against Jira Server

Hello.

I have a zap which triggers the following JQL query:

`project = PROJECT AND status = “In Progress” AND issuetype in standardIssueTypes() AND (component = "First component" AND component = "Second component") AND status changed before -7d AND NOT status changed after -7d`

It pulls all issues which are in “In Progress” status for more than 7 days.

The problem: when some issue was in another status for more than 7 days, and was just transitioned to “In Progress”, zap catches this issue and sends a notification. But obviously it shouldn’t. Everything works fine when I run the query manually in Jira, I don’t see such issues.

Any ideas what could be the reason of such behaviour? I was thinking about time zone differences, something like that, but I’m not sure. Thanks in advance.

Page 1 / 1

Hi @Egor Vlasov

For us to have true context, post screenshots showing how your Zap steps are outlined and configured in EDIT mode so we can see the field mappings/settings.

Sure.

@Egor Vlasov

Feedback from ChatGPT that may provide guidance...

Corrected Query (Hypothetical)

project = <value> AND status = "In Progress" AND issuetype IN standardIssueTypes() AND (component = '<value1>' OR component = '<value2>') AND status changed before -14d