What is the JQL to show the issues which has multiple values in the field Organizations(Custom Field

[Jakeer]

Hello Team,

Can you help us with the JQL which shows all the issues with the multiple values in the Organization field which is a custom field. 

Also we need not to hard code the query. 

Example: Organization IN( A, B) we can achieve this.But suppose we have n-number of organization vales means every time we need to hard code it. Instead of that we need a JQL which shows all the issues without hard code which has multiple values in the Organization field.

Any quick suggestions will be more helpful.

Thanks,

[Marc - Devoteam]

Hi @Jakeer 

There is no JQL function for your request.

JQL is just like SQL searching for values in an issue, not hte number of values in a filed

[Jakeer]

Hello @Marc - Devoteam ,

Thanks for your response.

I need a JQL which shows all the issues, which have multiple values in the Organization field(Custom Field).

[Marc - Devoteam]

Hi @Jakeer 

As I mentioned, this can't be done be JQL on fields with values only if number fields are used.

So you could create a number field and and an automation that if a value is added to the number field can be raised by 1.

Then you can have a JQL based on the value of the number field and that should give all the issues where the Org field has more than one value.

[Jakeer]

Hello @Marc - Devoteam ,

Can you plz help me with the Automation rule.

Thanks,

[Marc - Devoteam]

Hi @Jakeer 

See this simple example

[Jakeer]

Hello @Marc - Devoteam

Thanks for the automation rule.

Number field and Organization fields are different right, How can we run a JQL with it.

If you don't mind can you help me with the JQL also. It will be more helpful.

[Jakeer]

Hello @Marc - Devoteam

Did you get any chance to look into my previous message.

Thanks,

[Marc - Devoteam]

HI @Jakeer 

These are different fields, Yes.

What is you exact question on the JQL.