Help to perform not like operion in AEM query builder

[mohanasundaramp]

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_%

[arunpatidar · Accepted solution]

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

[mohanasundaramp]

Thanks for the query.working fine.

[Keerthana_H_N]

Hi @arunpatidar ,

Tried this query but it was giving the list of assets which doesn't have a property itself. Is it possible to add not operation just for property value?

This is giving all the results:
type=dam:Asset
path=/content/dam/
path.flat=true
1_group.property=jcr:content/dam:s7damType
1_group.property.value=ImageSet
group.p.and=true
2_group.property=jcr:content/dam:lastS7Synced
2_group.property.value=2023-05%
2_group.property.operation=like
2_group.p.not=true
p.limit=-1

This is giving the results which doesn't have that property:
type=dam:Asset
path=/content/dam/Product_Image_Sets2
path.flat=true
1_group.property=jcr:content/dam:s7damType
1_group.property.value=ImageSet
group.p.and=true
2_group.property=jcr:content/dam:lastS7Synced
2_group.property.value=2023-05%
2_group.property.operation=not
p.limit=-1

I just want to exclude the results which has the property value starting with that year and month.

[arunpatidar]

Try with

type=dam:Asset
path=/content/dam/Product_Image_Sets2
path.flat=true
property=jcr:content/dam:s7damType
property.value=ImageSet
p.and=true
group.1_group.property=jcr:content/dam:lastS7Synced
group.1_group.property.value=2023-05%
group.1_group.property.operation=like
group.p.not=true
p.limit=-1