Can I query when a custom tick box is checked and who updated that tick box?

[Sherwin Soriano]

Good morning!

How do I query all tickets that were approved (using a custom tick box) in any boards we have?

Thanks in advance!

[Sarah Wright]

There's not a way to display who approved or checked the box on the board. A couple of ideas you could explore.

1. Create a custom field called 'approver name' that is popluated with an automation. Trigger, when issue field is changed, action, update issue with the user who triggered the event. 

2. Rather than an approved checkbox, have an "Approved by" user field that the person who approves it selects themselves. 

[Alex Ortiz]

@Sherwin Soriano 

You should be able to use JQL to search for issues that have your checkbox checked.

Simply do:

yourfield IS NOT EMPTY and that should return any issue that has a checkbox value filled out.

Now, to figure out who selected the value, you need to go into the issue and go to the activity section of that issue and you'll see in the history who provided the value.