Help required in JQL

[Syed Farhan]

Hi everyone. We have a custom text field that contains random values.

These values can be numbers, or values like INCxxxxxx or SCTASKxxxxxx (where x refers to random numbers).

I want to write a JQL that returns all those items that contain "SCTASKxxxxx" in that specific field.

Please help.

TIA,

Farhan

[Deepanshu Natani · Accepted solution]

Hi @Syed Farhan 

Try using something like : "Custom_Field" ~ "SCTASK*".

Replace "Custom_Field" with the name of your custom field in JQL

[Syed Farhan]

It worked. Really appreciate that. Thanks a bunch

[Deepanshu Natani]

Can you please accept the answer? This helps users in future who may have similar questions.