It's all about the answers!

Ask a question

Don't Understand CCM Query Wizard

Joe Lynch (1479) | asked Feb 26 '14, 12:40 p.m.

Although i'm quite familiar with querying a database, for the life of me, i can't figure out the query wizard in CCM.  I am trying to build a simple query (A or B or C) AND (D).  I can't seem to figure out how to do this using the Add and Or Groups in the CCM query builder.

Any help would be appreciated

Accepted answer

permanent link
Kot T. (1.5k11219) | answered Feb 26 '14, 1:32 p.m.
Hi Joe,

Not sure if this gives the output you are looking for...

1. In Eclipse, create a new query (from scratch). Note: The default condition in the main window == AND.
2. Click on the 'Condition' dropdown on the top right of the window and select "OR group". This will create a sub OR group within the main group
3. In the main Group, add condition D in your example
4. In the sub OR group, add conditions A, B and C
Joe Lynch selected this answer as the correct answer

Joe Lynch commented Feb 26 '14, 2:42 p.m.

Thanks Kot!

Turned out the order in which i was creating the groups was messing me up.  Thanks so much for clarifying!

Your answer

Register or to post your answer.