Query Node

Query Node is used to specify sql queries to be used.

Example of valid json:

{"q":"ahmad","like":["name","description"]}

The above would generate the following where query:

where name like '%ahmad%' or description like '%ahmad%'

To compare equal to field:

{"q":"ahmad","equal":["name"]}

The above would generate the following:

where name='ahmad'

To compare like for more than 1 field:

{"like":{"name":"ahmad","description":"balik"}}

The above would generate:

where name like '%ahmad%' or description like '%balik%'

Of course to compare directly to value:

{"equal":{"name":"ahmad","description":"siap"}}

The above would generate the following:

where name='ahmad' or description='siap'

When combining queries, ‘or’ is the default operator used. To use ‘and’, place the node in an ‘and’ node:

{"and":{"equal":{"name":"ahmad","description":"siap"}}}

That would generate the following query:

where name='ahmad' and description='siap'