Using not equal To

[varung44569684]

Hi Team , 

Can someone help me on how to use "Not Equal to " in QueryBuilder. 

My query is of like this type.

http://localhost:4502//bin/querybuilder.json?p.hits=full&
primarytype=nt:unstructured&path=/content/data/masterdata/program&property=programName&property.value!=marketing&p.limit=-1

[GK-AEM]

Please explain the use case completely to help on this.

-Kishore

[varung44569684]

Hi Kishore ,

First of all thanks for the reply.

Actually using QueryBuilder.json,  I want to get the list of all nodes at a particular path , where every node has a property "programName", and I want to have only those nodes where the programName does not equal to "Marketing".

If I use the query http://localhost:4502/bin/querybuilder.json?p.hits=full&
primarytype=nt:unstructured&path=/content/data/masterdata/program&property=programName&property.value=marketing&p.limit=-1, it gives me those nodes with programName as Marketing but not vice versa.

That is this query http://localhost:4502/bin/querybuilder.json?p.hits=full&
primarytype=nt:unstructured&path=/content/data/masterdata/program&property=programName&property.value!=marketing&p.limit=-1 does not works.

[Jitendra_S_Toma]

Not quite sure but explore this document if that could help you. http://aemcq5.blogspot.in/2014/11/cq5-querybuilder-simplified.html?m=1

[Kunal_Gaba_]

Try the following query - 

http://localhost:4502//bin/querybuilder.json?p.hits=full&primarytype=nt:unstructured&path=/content/d...

[kautuk_sahni · Accepted solution]

Hi 

Please have a look at QueryBuilder Interface,

Link:- https://docs.jboss.org/exojcr/1.12.13-GA/developer/en-US/html/ch-jcr-query-usecases.html

Reference Link:- https://gist.github.com/yangzhe1991/10349122

Thanks and Regards

Kautuk Sahni