JQL using time.livestamp

[Beatrice Cudd]

I want to write a query that will show me all issues where my name is mentioned in a comment during a time period.  I thought I could use time.livestamp in JQL but it errors saying the field does not exist. 

I am currently using the below:

comment ~ <myname> AND status not in (Done, Closed, COMPLETED, CANCEL) ORDER BY updatedDate DESC 

I was hoping to do something like:

comment ~ <myname> and time.timestamp >=-5d AND status not in (Done, Closed, COMPLETED, CANCEL) ORDER BY updatedDate DESC

[Vamsi Kandala]

Hi @Beatrice Cudd

You can try replacing 'time.timestamp' with 'updated'.

Hope this helps.

Thanks,
Vamsi

[Trudy Claspill]

Hello @Beatrice Cudd 

From where did you get the idea that time.livestamp or time.timestamp were fields that could be used in JQL?

If you don't have third party apps that extend the JQL capabilities, then refer to this page and its related pages for information on fields and functions available in the native Advanced Search.

https://support.atlassian.com/jira-software-cloud/docs/use-advanced-search-with-jira-query-language-jql/

What you want to do is not possible with native Jira functionality. It is possible if you are willing to add a third party app to your environment. There is more than one that could help you with this issue. I have used Adaptavist Scriptrunner for extending JQL, but that is not the only such app that might help you.

https://marketplace.atlassian.com/apps/6820/scriptrunner-for-jira?hosting=cloud&tab=overview