Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,560,525
Community Members
 
Community Events
185
Community Groups

How can i add filter with two items to filter

issueFunction in linkedIssuesOf("\"Vehicle Type\" = \"ABC AND XYZ\"" , "relates to") AND project = AAA AND type = "Vehicle Issue" AND labels in (US) ORDER BY Rank ASC.

 

 

This query seems to be green but the query doesn't do what we want it to do

1 answer

0 votes
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Apr 25, 2023

Hello @Sushma M P 

Welcome to the Atlassian community!

What do you want it to do?

How do the results not match your expectations?

Thanks for the response!

I am unable to have list of vehicles with ABC and XYZ . there are some missing vehicles i see without filter

Once i apply filter it wont come under this board which suppose to appear 

Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Apr 25, 2023

What type of field is the "Vehicle Type" field?

Is it a selection list field? If so, does it allow only one value to be selected or multiple values? Is the value you want literally "ABC AND XYZ" or are you looking for issues where the field is "ABC" or it contains "XYZ" or it must contain both "ABC" and "XYZ"?

This part of the filter

issueFunction in linkedIssuesOf("\"Vehicle Type\" = \"ABC AND XYZ\"" , "relates to")

...is going to get you issues that have a "relates to" link to other issues where the Vehicle Type in those other issues is set to the value you specified ("ABC AND XYZ" literally).

That list will be reduced by the other elements of your filter

project = AAA AND type = "Vehicle Issue" AND labels in (US)

... so that the results set contains only the issues that match those three criteria.

If that is not what you want, please describe in detail what you want. Providing examples of issues that do and do not match what you would want in the results set would also be helpful.

it must contain both "ABC" and "XYZ"

 

..is going to get you issues that have a "relates to" link to other issues where the Vehicle Type in those other issues is set to the value you specified ("ABC AND XYZ" literally).

That is right, this is what i wanted to filter out.

 

But unfortunately results are  not as expected

Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Apr 25, 2023

What type of field is the "Vehicle Type" field?

Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Apr 27, 2023

Are "ABC" and "XYZ" separate substrings within a larger string?

Can you provide a screen image showing an example of this field and the content it would hold, plus identify the substrings for which you would want to search?

If Vehicle Type is a text field and you want issues where that text field contains the substrings "ABC" and "XYZ", then the JQL syntax would be

"Vehicle Type" ~ "ABC" and "Vehicle Type" ~ "XYZ"

issueFunction in linkedIssuesOf("\"Vehicle Type\" = \"ATG-B (Linux)(IDC6-7181) OR ATG-B (QNX)(IDC6-7182)\"", "relates to") AND project = ADASVEHX AND type = "Vehicle Issue" AND labels in (US) ORDER BY Rank ASC

 

This is how i am giving the query but i still see some of the ATG-B vehicle wont list when i apply this filter

Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Apr 27, 2023

Can you confirm that "Vehicle Type" field is a String type field by showing us the Custom Field configuration for it? Jira documentation indicates that the "=" operator doesn't work for Test and Paragraph fields. That makes me suspect that your Vehicle Type field is not a text field.

Without quotes of backslashes, please show us the values that exist in the field for issues you would want in your results. Then also show us the substrings you want to use in your search.

You can search a text field for two different substrings with the syntax you used. I am assuming that ATG-B (Linux)(IDC6-7181) is one substring and ATG-B (QNX)(IDC6-7182) is a separate substring vs. looking for one substring that includes both of those and also literally includes OR

ATG-B (Linux)(IDC6-7181)

or

ATG-B (QNX)(IDC6-7182)

versus

ATG-B (Linux)(IDC6-7181) OR ATG-B (QNX)(IDC6-7182)

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events