How to search multiple database picker field values without using the values IDs using JQL

[Daniel Hurrell]

Is there a way to search database picker field values using JQL? I know for other fields you can use for example: Field in ("test1" ,"test2", "test3"). However I see for database picker fields the previous example can only be used for searching for the ID of the values and not the values themselves.

In the scriptrunner documentation it says when searching JQL you can only use = or ~ but from what I have tested you can only search for single values.

Does anyone know of similar functionality to "in" but for database picker field values?

Thanks