How to use formulas calculating with logged and estimated time?

Question

I want to create some JQL statements that filter the following data.

Each bullet can be a separate filter. I can imagine I can join them as desired:

* all issues where time remaining + time logged < estimated time.
* all issues where the time remaining was changed. The report should show by how much this was changed. Up or down does not matter.
* all issues were the current estimate (time remaining?) > original estimate (that is the very first estimate given to the ticket).
* Issues that changed in the 'current' week. The trick here would be to be able to re-run the query without having to adjust the week number or dates from/to every time.

I am running into problems of not knowing:

* how to 'calculate' within JQL
* how to get some external piece of info to 'pin' the query for re-use. Much like =TODAY() does in Excel, or 'the current' week hopefully can.

Mark Herbold · Answer

Thanks, @Bill Sheboy for the update.

I will check the links!

Bill Sheboy · Answer

Hi @Mark Herbold  -- Welcome to the Atlassian Community!

You cannot do most of the things you ask with out-of-the-box JQL.  Specifically, JQL cannot compare fields or create calculated fields for an issue, as you could with a SQL.

Some of those queries are possible with a marketplace addon to enhance JQL features.  Please look here for options: https://marketplace.atlassian.com/

You can check for issues updated during this week, such as with:

project = myProjectName AND updated >= startOfWeek() ORDER BY updated ASC

To learn what is available for some of the advance JQL searches, please look here: https://support.atlassian.com/jira-software-cloud/docs/use-advanced-search-with-jira-query-language-jql/

Kind regards,
Bill