Help with a filter

[JayJuan Jones]

how can I set up a filter to check if the reporter field has the same value/text as one of my customfields? I need this to filter out certain issues

[Jack Brickey]

hi @JayJuan Jones , you cannot compare Fields with OOTB JQL. One possible solution would be to leverage automation. Automation does provide the ability to compare fields. To that end, you could construct a rule that you could run manually. This rule could check for conditions where the reporter matches your custom field and if found then an action could add a label. Following this manual action you could use JQL to find issues that did not include that label. This is just one possible idea that you could look into.

[JayJuan Jones]

that's a good idea, do you have any examples? When I go to automation and look for my customfield, it is not giving me an option to select my customfield. Am I looking in the correct area?

[Jack Brickey]

Hi @JayJuan Jones , 

used the advanced field compare. example below...

[JayJuan Jones]

that almost worked, but the reporter is being returned like this:

qm:f64841d3-9dd9-4d47-b4c9-4aa723459311:63ad5fd8-7597-4181-89c6-ead7c07dbd10

instead of the actual name, any more ideas?