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

Jakeer February 23, 2024

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,

1 answer

1 vote
Marc Koppelaar
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 23, 2024

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 February 25, 2024

Hello @Marc Koppelaar ,

Thanks for your response.

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

Marc Koppelaar
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 25, 2024

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 February 29, 2024

Hello @Marc Koppelaar ,

Can you plz help me with the Automation rule.

Thanks,

Marc Koppelaar
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 29, 2024

Hi @Jakeer 

See this simple example

Screenshot 2024-02-28 at 11.22.24.png

Jakeer February 29, 2024

Hello @Marc Koppelaar

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 March 14, 2024

Hello @Marc Koppelaar

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

Thanks,

Marc Koppelaar
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 14, 2024

HI @Jakeer 

These are different fields, Yes.

What is you exact question on the JQL.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events