Heads up! On March 5, starting at 4:30 PM Central Time, our community will be undergoing scheduled maintenance for a few hours. During this time, you will find the site temporarily inaccessible. Thanks for your patience. Read more.
×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?
Is it the query that is wrong of the Google Sheets part that aggregate everyday result ?
Regards
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.)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes but if you run this query in the Issue Nqvigator in JIRA, does it return the expected result ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It does, but it keeps adding to the query and updating the sheet. If that makes sense.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
So that means the issue is not with the JQL but about what you have implemented to send the result to Google Sheet.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.