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.
