How to query a ticket that is updated by someone other than assignee in the last 30 mins

[Derek Pence]

We are specifically talking about when an outside user updates a current request, we'd like to have a query that shows us anytime something is updated in the last 15 mins with that criteria. We have an updated and a last viewed field we are trying to use. They require time inputs. Here is what we have but it doesn't seem to quite work.

(project = "Client Response" OR project = "PIQ - KS" OR project = "Keeping Score" OR project = "CIQ - KS") AND updated >= -30m AND assignee = currentUser()  and updatedDate > -1m  ORDER BY updated DESC

I guess we'd like to know where last viewed would be inserted and what statement it would need.

Thank you in advance for your help.

[sudhakar]

Hi 

By using the plugin like" JQL Search Extensions" can get the list of tasks that are updated by the particular user over period of time

JQL :issue in updatedByUser("daniel") AND updated >= -30m gives us list of issues that are update the user last 30 mins

https://jqlsearchextensions.atlassian.net/wiki/spaces/SEARCH/pages/30497099/JQL+Reference+Server#JQLReference(Server)-UpdatedByUser

[Alexey Matveev]

{EDITED}

[Derek Pence]

didn't know that was a field. I will check that out. thank you!

[Derek Pence]

I don't have an edited field to choose from in our version.

[Alexey Matveev]

The problem is that you can get all issues, which were updated within last 30 mins but you can not filter out which were not updated by the assignee. You would need to write a custom JQL function for it. You could use the Power Scripts or ScriptRunner add-ons for it.

[Alexey Matveev]

{EDITED} I meant that I edited my comment

[Derek Pence]

perfect. thank you!