Expand my Community achievements bar.

SOLVED

Help to perform not like operion in AEM query builder

Avatar

Level 3

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

View solution in original post

4 Replies

Avatar

Correct answer by
Community Advisor

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

Avatar

Employee

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.

Avatar

Community Advisor

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

 

arunpatidar_0-1690906541351.png

 



Arun Patidar