Project automation wildcard search for organization

Question

Hello Team

I have a "Project Automation" rule setup to assign a SLA based on Organizations. I would like to use JQL wildcard characters (*,?) to search the Orgs instead of adding a long string of Organization = "Customer 1(P)" OR Organizations = "Customer 2 (P)" OR Organizations = "Customer 3". I would like to do something like Organization = Customer* . But I get syntex errors in Project automation when I try this in various combos...what am I doing wrong ..or is this possible?

Liam Green · Answer

Hi Rob

It doesn't unfortunately.

I've just noticed that I didn't include the article in my initial answer:

https://confluence.atlassian.com/jiracoreserver073/search-syntax-for-text-fields-861257223.html

Hopefully that will shed some light on why the wildcard doesn't work.

Regards, Liam

Rob_fdqvsu · Answer

Thank you Liam..this certainly cuts down on the string and I will use this but doesn't answer my question about wild card characters in "Project Automation"

Liam Green · Answer

Hi Rob

I'm not sure about using wildcards, but for the above query I would use 'in' not '=', so instead of:

Organization = "Customer 1(P)" OR Organizations = "Customer 2 (P)" OR Organizations = "Customer 3"

you would have:

Organization in ("Customer 1(P)", "Customer 2 (P)", "Customer 3")

The following article on JQL might also be of assistance.

Hope that helps,

Regards, Liam