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

Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X

--queryDefinition not

jdcc
1-Newbie

--queryDefinition not

Hi all,

I am stuck with this issue using CLI exportissues command, I am not sure if my queryDefinition is too long or just an improper used of (not(field["Project Title']) below

--queryDefinition='(((field["Project title"]= "Project 05.02.00","Project 06.01.00","Project 06.02.00","Project 06.00.00","Project") or (field["Product"] = "Program")) and (not (field["Project title"] = "Product 4.1"," Product 5.0", "Project 05.02.00","Product 1.1","Product 2.0","Product 2.5", "Product 1.0,"Product - 3411","Product 3369","Product 3369","Product 9482", "Product 9482","Product 0116","Product 9497","Product 9497")))'

Please help!

Thanks,

3 REPLIES 3

Hi jdcc,

What is the exact error message you are getting?

We may be able to use that message to narrow down the exact issue, because your use of "not (field...)" looks correct to me.

Regards,

Matt

Hi Matt,

Thanks for the reply.

It's saying "Cannot show view information: Error parsing filter "field["Project title"] = "Product 4.1"," Product 5.0", "Project 05.02.00","Product 1.1","Product 2.0","Product 2.5", "Product 1.0,"Product - 3411","Product 3369","Product 3369","Product 9482", "Product 9482","Product 0116","Product 9497","Product 9497"" is not valid.

Is it possible since I used field["Project title"] twice? One is for the = and the next is using not?

Thanks,


Hi jdcc,

Using the same field twice should be fine.

Try not wrapping the field name in quotes, so use field[Project title] instead.

Hope that helps,

Matt

Top Tags