Skip to main content
Level 2
December 31, 2019
Solved

Help to perform not like operion in AEM query builder

  • December 31, 2019
  • 1 reply
  • 4281 views

I need to perform not like operation to get "PDK_" non matched values from DAM.But i don't get any idea.
Some site provide reference to use "not" opertion.but not will give only empty value only.i need not matching number values also.
Kindly help to for this.and also tried with unequals.

My Query:
type=dam:Asset
path=/content/dam/
p.limit=-1
property=jcr:content/metadata/UniqueProductID
property.operation=not
property.value=%PDK_%

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by arunpatidar

try with below Query

 

type=dam:Asset
path=/content/dam/
p.limit=-1
group.property=jcr:content/metadata/UniqueProductID
group.property.value=PDK_
group.property.operation=like
group.p.not=true

1 reply

arunpatidar
Community Advisor
arunpatidarCommunity AdvisorAccepted solution
Community Advisor
December 31, 2019

try with below Query

 

type=dam:Asset
path=/content/dam/
p.limit=-1
group.property=jcr:content/metadata/UniqueProductID
group.property.value=PDK_
group.property.operation=like
group.p.not=true

Arun Patidar
Level 2
January 8, 2020
Thanks for the query.working fine.