I tried the above query in acs-commons it works fine but instead of giving directly like %dsc:device% we need to get that value from dropdown(search parameter). I tried like '{{tags}}' to get the value(dsc:device) from the dropdown but it didn't work.if possible, can this be achieved in query builde...

Need a jcr sql2 query for acs commons report or query builder predicate to get the list of pages which don't have specific cq:tagsOur tags hierarchy :and the node structure is jcr:content/metadata/cq:tags Here i want all the pages which do not have dsc:device or dsc:keywords tags