Multiple values in Advance Compare Condition

[Mihir Ruparelia]

Hello, 

I would like some help on the following, we have a department field list with a child field. I want to add an automation that says 

If person 1 or 2 are selected in the Child field, then update the approver field and send an email. 

The bit I am struggling with is the OR function, Any thoughts or help on scripting would be great. 

This is what I have so far: 

First Value: {{issue.Department.child.value}}
Condition: Contains
Second Value: User1,User2

[Nic Brough -Adaptavist-]

Sounds like a busted index.  Is it possible to do a background re-index and try this again?

(By the way, it is possible for someone to name someone else as a reporter, even if that person has never logged in - that's probably how you got there.  To rid yourself of the user, use the same ability to change it to someone else!)

[Kathleen Buckley]

I'll try that, but I think I've had this problem for a long time and I've re-indexed many times. I also run the integrity checker a lot and it hasn't found any problems. But I will try it again just in case this really is a new problem. Thanks.

[Nic Brough -Adaptavist-]

Hmm, yes, it's a bit of a pain if you can't find the issue that Jira is blocked by. Hopefully a reindex will fix it. But if you're still stuck, then "select * from jiraissue where reporter = 'username'" should find the issue in the database.

[Kathleen Buckley]

Thanks. I'll try that. It's still re-indexing so waiting to see if that works.