I am trying to create a JQL query which will give me the specific tickets a user has worked on during the day. Can anyone help with this query as everything I try gives me incorrect results.
Hi. @Tony and welcome to the Community!
If a user logged his work this one should work:
project = <project name> AND worklogAuthor = <username> AND worklogDate = endOfDay() ORDER BY createdDate ASC
It would also perform some sorting so that the freshest tasks are on top.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Grigory Salnikov thanks for the reply and sorry for the delay in responding, does this only work if the end user logs time against the ticket? I wanted to filter if they have commented on the ticket.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Tony, it's ok :)
Yes, the JQL provided above only works with work logs. What you're trying to achieve is, unfortunately, impossible with classical JQL.
If you have Adaptivist ScriptRunner, it's pretty simple:
How can I search issues to which a user has commented?
Hope this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.