Any query suggestions for multiple check boxes checked

[Harihara Prasath V]

The DoR and DoD have been defined in JIRA.  I would like to check the adherence of DoR and DoD.

For example, I can retrieve the epics / stories which are defined with DoR / DoD using the below query however I would like to know how I can check if the DoR /DoD has been adhered by the team.

For example :  For one Epic, there can be 5 DoR Check boxes,

Scenario 1  : If all the check boxes of the epic are checked, then DoR is adhered

Scenario 2 : If few of the check boxes are checked or if none of the check boxes are checked, then DoR is not adhered.

Any recommendation on how we can retrieve the result.

project = x AND issuetype = epic AND PI = xxx AND status in (xxx) AND DoR(Custom field) is not EMPTY 

Thanks in advance for your responses.

[Brant Schroeder]

@Harihara Prasath V In order to have JQL to make sure that all checkboxes are checked you would need to have an app from the app store like scriptrunner.