During the import the status of some issues was not mapped correctly, therefore I need to select a set of issues based on a value in a short text (old system identifier) but I cannot use the operator IN as it is not supported.
So I would like to search in "OLD VALUE KEY" IN (KEY1,KEY2,KEY3)" but IN is not supported for text fields. How can I solve this? Suggestions and ideas welcome.
THX
Hi @clr2021 ,
you can query text fields with the ~ operator only.
So you code might be:
textfield ~ "KEY1" OR textfield ~ KEY2
You need to use OR because the ~ operator will always search for the complete string passed along, and not parts of it.
But it is important to note that the order of the words does not matter.
E.G:
textfield ~ "I am KEY1"
Wil match:
but not:
Hope this helps!
-Tessa
Thanks, I was hoping that I could avoid repeating all the times the field name, as they are quite a few entries. But it seems that I will have to go that way.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.