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