nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Jakeer_kkntml

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, 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,

Accepted answers

All comments

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_kkntml

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_kkntml

Hello @Marc -Devoteam- ,

Can you plz help me with the Automation rule.

Thanks,

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-service-management-cloud

jira-service-management