Skip to main content
1-Visitor
April 24, 2013
Question

--queryDefinition not

  • April 24, 2013
  • 2 replies
  • 1641 views

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,

    2 replies

    1-Visitor
    April 24, 2013

    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

    jdcc1-VisitorAuthor
    1-Visitor
    April 25, 2013

    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,


    1-Visitor
    April 25, 2013

    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