Custom Filter on users work that day

[Tony]

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.

[Grigory Salnikov]

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

[Grigory Salnikov]

It would also perform some sorting so that the freshest tasks are on top.

[Tony]

@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.

[Grigory Salnikov]

@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.