Hi Team,
I am fetching some DAM assets based on the below property (xyz:public).
1) Below is the condition it should use to fetch the result.
1. xyz:pubic --> property value can be 'yes'
or
xyz:pubic --> property value is not defined means null.
2. xyz:pubic --> property not available/exist for DAM assets
above 2 conditions should match.
In simple terms, if xyz:public property not available for assets need to fetch and if property available then value should be 'yes/null' and value should not be 'no'
Thanks
Chandra
Solved! Go to Solution.
Views
Replies
Total Likes
If I understand correctly, you want to fetch the assets that :
+
If yes, please try this query:
path=/content/dam/we-retail
nodename=metadata
group.p.or=true
group.1_property=xyz:pubic
group.1_property.operation=unequals
group.1_property.1_value=no
group.2_property=xyz:pubic
group.2_property.operation=exists
group.2_property.value=false
p.limit=-1
Hope this helps.
Thanks,
Fani
Hi @chandrareddy ,
Please try with this.
path=/content/dam property=xyz:pubic property.1_value=yes property.2_value=<<if you have any other property. Works based on OR condition>> p.limit=-1
I think my question is not correct. Now I have updated.
Actually the given solution only works for point 1.
1. xyz:pubic --> property value can be 'yes'
or
xyz:pubic --> property value is not defined means null.
2. xyz:pubic --> property not available/exist for DAM assets
above 2 conditions should match.
if xyz:public property not available for assets need to fetch those assets and,
if property available then value should be 'yes/null'.
Hi @chandrareddy ,
Please check on this.
path=/content/dam group.p.or=true group.1_property=xyz:pubic group.1_property.1_value=yes group.2_property=xyz:pubic group.2_property.operation=not p.limit=-1
Hi @chandrareddy ,
I have a question here if you don't define any value for the property is the property getting saved in JCR ?
Please check below documentation for grouping:
https://experienceleague.adobe.com/docs/experience-manager-64/developing/platform/query-builder/quer...
Thank you
If I understand correctly, you want to fetch the assets that :
+
If yes, please try this query:
path=/content/dam/we-retail
nodename=metadata
group.p.or=true
group.1_property=xyz:pubic
group.1_property.operation=unequals
group.1_property.1_value=no
group.2_property=xyz:pubic
group.2_property.operation=exists
group.2_property.value=false
p.limit=-1
Hope this helps.
Thanks,
Fani
Exactly, this is my requirement.
Let me check and confirm back. thanks a lot.