Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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

William Wallace July 29, 2022

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?

1 answer

1 vote
Florian Bonniec
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 29, 2022

Hi @William Wallace 

 

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

 

Regards

William Wallace July 29, 2022

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
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 29, 2022

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

William Wallace July 29, 2022

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

Florian Bonniec
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 29, 2022

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

Like • Alexander Bondarev likes this

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, team '25, conference, certifications, bootcamps, training experience, anaheim ca,

Want to make the most of Team ‘25?

Spend the day sharpening your skills in Atlassian Cloud Organization Admin or Jira Administration, then take the exam onsite. Already ready? Take one - or more - of 12 different certification exams while you’re in Anaheim at Team' 25.

Learn more
AUG Leaders

Upcoming Jira Events