JQL inconsistency

[UdayKiran]

The JQL

project in (AB) AND "SFDC Cases[Labels]" IS NOT null AND "SFDC Customer[Short text]" in ("CSl") and "Opportunity[Select List (multiple choices)]" in (RU) ORDER BY assignee

returns error

The operator 'in' is not supported by the 'SFDC Customer[Short text]' field.

But returns the desired output via Confluence + Jira Macro (Jira Legacy)

Any pointers on why?

[Sanam Malleswari · Accepted solution]

Hi @UdayKiran

The error occurs because "SFDC Customer[Short text]" is a text field, and JQL doesn't support the in operator for text fields—only =, !=, or ~ (contains) are allowed.
It works in Confluence Jira macro (legacy) because it’s less strict with JQL validation, but Jira itself enforces the correct syntax.

[UdayKiran]

Thank you @Sanam Malleswari !!