How can i compare 2 fields developers and participants in worklog with jira

[Jose Fernandez Gabriel Juan Pablo Diego Sergio Javier Garcier ViktorRodriguez]

How can i compare 2 fields (developers and participants in worklog) with jira

[Earl McCutcheon]

Hello Jose,

Natively In Jira this is limited to options that can be directly compare by opposing values in two different fields, as issue JQL results only return the data for the desired options specified for the issue in a JQL statement,  an example of a method that could be used to look for issues where the creator and reporter are different could be:

creator = currentuser() AND reporter != currentuser()

Alternatively you can parse the results manually.  One method is to export the data as a CSV and use an external application like Excel or OpenOffice to query the results.

The following Post details a few add-ons that extend this function via scripted functions that can accomplish this:

• https://community.atlassian.com/t5/Jira-questions/Assignee-not-same-as-reporter/qaq-p/201834

If you want to look at the backend you could parse the data in SQL looking at the "customfield" table in the DB scheme.

Regards,
Earl