Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Filter JQL? Multiple Applications

O.A. September 18, 2020

I cant get it solved and it drives me crazy. 

I have service id of applications which i have to change! These are 200! 

I created a list of them and searched like 

service id – (1,103,......) 

 

but its not working! Can you guys please help me? I think i have Jira 8.2

1 answer

0 votes
Niranjan
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.
September 18, 2020

Hi @O.A. ,

Can you please elaborate your question? If you want to search for all the applications with those service ids, then you can try

"Service id" in (1,103,......)

But again, I am unclear with the request. Let me know if the actual requirement is a different thing.

O.A. September 18, 2020

This is working, but if i put it 200 times in, it isnt working. Now im trying your solution that means: 
Project = ..... AND "XY" in (1,103,...) ? 

O.A. September 18, 2020

No, that is NOT working! 

Niranjan
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.
September 18, 2020

What is the field type of "buchpos" ?

O.A. September 18, 2020

i have no clue! sorry. It seems to be a textfield but im not an administrator or else. Im just a user who got the order to change 200 applications. and i would love to do them all to gether not separatedly. and if i dont get it for this time, for the next time. :) Thatswhy many thanks for your help. 

Niranjan
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.
September 18, 2020

From the screenshot I assume it is a number field, then you can try using 

Project = ..... AND ("buchpos" in (1,103,...))

If that doesn't work try

Project = ..... AND (("buchpos" ~ 1 OR buchpos" ~ 103,...))

 

If there are any errors when you execute the query attach the screenshot for reference.

Niranjan
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.
September 18, 2020

You can also actually prepare a CSV file with application name, service id, existing Issue number, Summary. Ask the JIRA admin to bulk update the issues. That should help

O.A. September 18, 2020

Project = ..... AND ("buchpos" in (1,103,...))

 

The error message is "in isnt supported by field "buchpos"

 

The second i tried and he is not executing the search if its more than 20! 

O.A. September 18, 2020

for safety, can you please change in all your comments to "buchpos" :) 

Niranjan
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.
September 18, 2020

I would recommend this option

You can also actually prepare a CSV file with application name, service id, existing Issue number, Summary. Ask the JIRA admin to bulk update the issues. That should help

O.A. September 18, 2020

I dont get it why this is the solution! If i cant address them i cannot export or like i want to change. 

Niranjan
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.
September 18, 2020

The reason being, if that is a text field, you cannot search like select list type that would have definite options. Bulk updates in UI will not allow you to update different values for the filtered issues. 

O.A. September 18, 2020

Bulk updates is working but only for 20-30 at the same time. 

Suggest an answer

Log in or Sign up to answer