How can I see ONLY startOfDay() items searched today?

[William Wallace]

I have a JIRA Search query ( project = 'DT' AND created > startOfDay() AND type = "DT Lite" ) that shows all DT tickets for today, and have the results ported to Google Sheets to update automatically as each ticket is updated.

Problem is, I started this yesterday and today, the query also includes "Yesterdays" results.

Is there any way to limit to "ONLY" Today's results?

[Florian Bonniec]

Hi @William Wallace 

Is it the query that is wrong of the Google Sheets part that aggregate everyday result ?

Regards

[William Wallace]

No, The results are updated dynamically in the Google Sheet by JIRA. i.e. if you run that query today and leave it, That query will update the Google Sheet indefinitely (or at least, that's what I'd like for it to do.)

[Florian Bonniec]

Yes but if you run this query in the Issue Nqvigator in JIRA, does it return the expected result ?

[William Wallace]

It does, but it keeps adding to the query and updating the sheet. If that makes sense.

[Florian Bonniec]

So that means the issue is not with the JQL but about what you have implemented to send the result to Google Sheet.