Expand my Community achievements bar.

Asset Share Portal third filter is crashing facets, due to QueryBuilder assigns group.p.or = true

Avatar

Level 2
Level 2
9/12/24 3:43:04 PM

When select three or more filters in the Asset Share portal, the search results section displays un-accurate results of assets that does not comply with filters.

 

How to remove the group.p.or = true statement from being added by default?

 

Example URL from DAM Portal: 

https://dam.site.com/content/asset-share-commons/en/marketing.html?1_group.propertyvalues.property=.%2Fjcr%3Acontent%2Fmetadata%2Fdc%3Aformat&1_group.propertyvalues.operation=equals&1_group.propertyvalues.3_values=image%2Fpng&3_group.propertyvalues.property=.%2Fjcr%3Acontent%2Fmetadata%2Fdam%3Amarketingprojectasset&3_group.propertyvalues.operation=equals&3_group.propertyvalues.3_values=04_digital&10_group.propertyvalues.property=.%2Fjcr%3Acontent%2Fmetadata%2Fdam%3AregionalCreator&10_group.propertyvalues.operation=equals&10_group.propertyvalues.2_values=GLOBAL&orderby=%40jcr%3Acontent%2Fjcr%3AlastModified&orderby.sort=desc&layout=list&p.offset=0&p.limit=24

From logs:

 

Query Builder Parameters:

_12_group.1_propertyvalues.3_values = 04_digital_12_group.1_propertyvalues.property = ./jcr:content/metadata/dam:marketingprojectasset_2_group.0_path = /content/dam/projects/marketing/seasonal_2_group.1_path = /content/dam/marketing/site-assets_2_group.2_path = /content/dam/projects/emea_2_group.3_path = /content/dam/marketing/global-resources_2_group.p.or = true_4_group.mainasset = true_5_group.group.property = jcr:content/metadata/dam:exclusive_5_group.group.property.operation = not_6_group.group.p.or = true_6_group.group.property = jcr:content/metadata/prism:expirationDate_6_group.group.property.operation = not_6_group.group.relativedaterange.lowerBound = 0d_6_group.group.relativedaterange.property = jcr:content/metadata/prism:expirationDate_7_group.group.1_daterange.lowerBound = 2024-09-04T11:17:26.334773_7_group.group.1_daterange.property = jcr:content/metadata/ua:archivedDate_7_group.group.2_property = jcr:content/metadata/ua:archivedDate_7_group.group.2_property.operation = not_7_group.group.p.or = true_group.11_group.1_propertyvalues.3_values = image/png_group.11_group.1_propertyvalues.operation = equals_group.11_group.1_propertyvalues.property = ./jcr:content/metadata/dc:format_group.12_group.1_propertyvalues.operation = equals_group.13_group.1_propertyvalues.2_values = GLOBAL_group.13_group.1_propertyvalues.operation = equals_group.13_group.1_propertyvalues.property = ./jcr:content/metadata/dam:regionalCreator_group.p.or = true_orderby = @jcr:content/jcr:lastModified_orderby.sort = desc_p.guessTotal = 100_p.limit = 24_p.offset = 0_type = dam:Asset

Query Builder Parameters (formatted to be human readable): 

12_group.1_propertyvalues.3_values = 04_digital
12_group.1_propertyvalues.property = ./jcr:content/metadata/dam:marketingprojectasset
2_group.0_path = /content/dam/projects/marketing/seasonal
2_group.1_path = /content/dam/marketing/site-assets
2_group.2_path = /content/dam/projects/emea
2_group.3_path = /content/dam/marketing/global-resources
2_group.p.or = true
4_group.mainasset = true
5_group.group.property = jcr:content/metadata/dam:exclusive
5_group.group.property.operation = not
6_group.group.p.or = true
6_group.group.property = jcr:content/metadata/prism:expirationDate
6_group.group.property.operation = not
6_group.group.relativedaterange.lowerBound = 0d
6_group.group.relativedaterange.property = jcr:content/metadata/prism:expirationDate
7_group.group.1_daterange.lowerBound = 2024-09-04T11:17:26.334773
7_group.group.1_daterange.property = jcr:content/metadata/ua:archivedDate
7_group.group.2_property = jcr:content/metadata/ua:archivedDate
7_group.group.2_property.operation = not
7_group.group.p.or = true
group.11_group.1_propertyvalues.3_values = image/png
group.11_group.1_propertyvalues.operation = equals
group.11_group.1_propertyvalues.property = ./jcr:content/metadata/dc:format
group.12_group.1_propertyvalues.operation = equals
group.13_group.1_propertyvalues.2_values = GLOBAL
group.13_group.1_propertyvalues.operation = equals
group.13_group.1_propertyvalues.property = ./jcr:content/metadata/dam:regionalCreator
group.p.or = true
orderby = @jcr:content/jcr:lastModified
orderby.sort = desc
p.guessTotal = 100
p.limit = 24
p.offset = 0
type = dam:Asset

Executed query statement:

_(/jcr:root/content/dam/projects/marketing/seasonal//element(*, dam:Asset)[((_x002e_/jcr:content/metadata/@dc:format = 'image/png')) and (not(jcr:content/metadata/@dam:exclusive)) and (not(jcr:content/metadata/@prism:expirationDate) or (jcr:content/metadata/@prism:expirationDate > xs:dateTime('2024-09-04T11:17:26.343Z'))) and ((jcr:content/metadata/@ua:archivedDate > xs:dateTime('2024-09-04T11:17:26.334Z')) or not(jcr:content/metadata/@ua:archivedDate)) and ((_x002e_/jcr:content/metadata/@dam:marketingprojectasset = '04_digital'))] | /jcr:root/content/dam/projects/marketing/seasonal//element(*, dam:Asset)[((_x002e_/jcr:content/metadata/@dam:regionalCreator = 'GLOBAL')) and (not(jcr:content/metadata/@dam:exclusive)) and (not(jcr:content/metadata/@prism:expirationDate) or (jcr:content/metadata/@prism:expirationDate > xs:dateTime('2024-09-04T11:17:26.343Z'))) and ((jcr:content/metadata/@ua:archivedDate > xs:dateTime('2024-09-04T11:17:26.334Z')) or not(jcr:content/metadata/@ua:archivedDate)) and ((_x002e_/jcr:content/metadata/@dam:marketingprojectasset = '04_digital'))] | /jcr:root/content/dam/marketing/site-assets//element(*, dam:Asset)[((_x002e_/jcr:content/metadata/@dc:format = 'image/png')) and (not(jcr:content/metadata/@dam:exclusive)) and (not(jcr:content/metadata/@prism:expirationDate) or (jcr:content/metadata/@prism:expirationDate > xs:dateTime('2024-09-04T11:17:26.343Z'))) and ((jcr:content/metadata/@ua:archivedDate > xs:dateTime('2024-09-04T11:17:26.334Z')) or not(jcr:content/metadata/@ua:archivedDate)) and ((_x002e_/jcr:content/metadata/@dam:marketingprojectasset = '04_digital'))] | /jcr:root/content/dam/marketing/site-assets//element(*, dam:Asset)[((_x002e_/jcr:content/metadata/@dam:regionalCreator = 'GLOBAL')) and (not(jcr:content/metadata/@dam:exclusive)) and (not(jcr:content/metadata/@prism:expirationDate) or (jcr:content/metadata/@prism:expirationDate > xs:dateTime('2024-09-04T11:17:26.343Z'))) and ((jcr:content/metadata/@ua:archivedDate > xs:dateTime('2024-09-04T11:17:26.334Z')) or not(jcr:content/metadata/@ua:archivedDate)) and ((_x002e_/jcr:content/metadata/@dam:marketingprojectasset = '04_digital'))] | /jcr:root/content/dam/projects/emea//element(*, dam:Asset)[((_x002e_/jcr:content/metadata/@dc:format = 'image/png')) and (not(jcr:content/metadata/@dam:exclusive)) and (not(jcr:content/metadata/@prism:expirationDate) or (jcr:content/metadata/@prism:expirationDate > xs:dateTime('2024-09-04T11:17:26.343Z'))) and ((jcr:content/metadata/@ua:archivedDate > xs:dateTime('2024-09-04T11:17:26.334Z')) or not(jcr:content/metadata/@ua:archivedDate)) and ((_x002e_/jcr:content/metadata/@dam:marketingprojectasset = '04_digital'))] | /jcr:root/content/dam/projects/emea//element(*, dam:Asset)[((_x002e_/jcr:content/metadata/@dam:regionalCreator = 'GLOBAL')) and (not(jcr:content/metadata/@dam:exclusive)) and (not(jcr:content/metadata/@prism:expirationDate) or (jcr:content/metadata/@prism:expirationDate > xs:dateTime('2024-09-04T11:17:26.343Z'))) and ((jcr:content/metadata/@ua:archivedDate > xs:dateTime('2024-09-04T11:17:26.334Z')) or not(jcr:content/metadata/@ua:archivedDate)) and ((_x002e_/jcr:content/metadata/@dam:marketingprojectasset = '04_digital'))] | /jcr:root/content/dam/marketing/global-resources//element(*, dam:Asset)[((_x002e_/jcr:content/metadata/@dc:format = 'image/png')) and (not(jcr:content/metadata/@dam:exclusive)) and (not(jcr:content/metadata/@prism:expirationDate) or (jcr:content/metadata/@prism:expirationDate > xs:dateTime('2024-09-04T11:17:26.343Z'))) and ((jcr:content/metadata/@ua:archivedDate > xs:dateTime('2024-09-04T11:17:26.334Z')) or not(jcr:content/metadata/@ua:archivedDate)) and ((_x002e_/jcr:content/metadata/@dam:marketingprojectasset = '04_digital'))] | /jcr:root/content/dam/marketing/global-resources//element(*, dam:Asset)[((_x002e_/jcr:content/metadata/@dam:regionalCreator = 'GLOBAL')) and (not(jcr:content/metadata/@dam:exclusive)) and (not(jcr:content/metadata/@prism:expirationDate) or (jcr:content/metadata/@prism:expirationDate > xs:dateTime('2024-09-04T11:17:26.343Z'))) and ((jcr:content/metadata/@ua:archivedDate > xs:dateTime('2024-09-04T11:17:26.334Z')) or not(jcr:content/metadata/@ua:archivedDate)) and ((_x002e_/jcr:content/metadata/@dam:marketingprojectasset = '04_digital'))]) order by jcr:content/@jcr:lastModified descending

 Note that at the end of the query params Asset Share Commons adds those extra params:

group.p.or = true
orderby = @jcr:content/jcr:lastModified
orderby.sort = desc
p.guessTotal = 100
p.limit = 24
p.offset = 0
type = dam:Asset

I believe that the com.adobe.aem.commons.assetshare.search.providers.impl.QuerySearchProviderImpl is internally applying extra parameters to the Query Builder that disrupts the query creation causing un-accurate results.

 

The group.p.or = true statement is disrupting the facets:

 

Extracting facets using the Query Builder Debugger:

    (
      /jcr:root/content/dam/projects/marketing/seasonal//element(*, dam:Asset)
      [
      ((_x002e_/jcr:content/metadata/@dc:format = 'image/png'))
      and (not(jcr:content/metadata/@dam:exclusive))
      and (not(jcr:content/metadata/@prism:expirationDate)
      or (jcr:content/metadata/@prism:expirationDate > xs:dateTime('2024-09-04T11:34:49.462Z')))
      and ((jcr:content/metadata/@ua:archivedDate > xs:dateTime('2024-09-04T11:17:26.334Z'))
      or not(jcr:content/metadata/@ua:archivedDate))
      and ((_x002e_/jcr:content/metadata/@dam:marketingprojectasset = '04_digital'))
      ]
    |
      /jcr:root/content/dam/projects/marketing/seasonal//element(*, dam:Asset)
      [
      ((_x002e_/jcr:content/metadata/@dam:regionalCreator = 'GLOBAL'))
      and (not(jcr:content/metadata/@dam:exclusive))
      and (not(jcr:content/metadata/@prism:expirationDate)
      or (jcr:content/metadata/@prism:expirationDate > xs:dateTime('2024-09-04T11:34:49.462Z')))
      and ((jcr:content/metadata/@ua:archivedDate > xs:dateTime('2024-09-04T11:17:26.334Z'))
      or not(jcr:content/metadata/@ua:archivedDate))
      and ((_x002e_/jcr:content/metadata/@dam:marketingprojectasset = '04_digital'))
      ]
    |
      /jcr:root/content/dam/marketing/site-assets//element(*, dam:Asset)
      [
      ((_x002e_/jcr:content/metadata/@dc:format = 'image/png'))
      and (not(jcr:content/metadata/@dam:exclusive))
      and (not(jcr:content/metadata/@prism:expirationDate)
      or (jcr:content/metadata/@prism:expirationDate > xs:dateTime('2024-09-04T11:34:49.462Z')))
      and ((jcr:content/metadata/@ua:archivedDate > xs:dateTime('2024-09-04T11:17:26.334Z'))
      or not(jcr:content/metadata/@ua:archivedDate))
      and ((_x002e_/jcr:content/metadata/@dam:marketingprojectasset = '04_digital'))
      ]
    |
      /jcr:root/content/dam/marketing/site-assets//element(*, dam:Asset)
      [
      ((_x002e_/jcr:content/metadata/@dam:regionalCreator = 'GLOBAL'))
      and (not(jcr:content/metadata/@dam:exclusive))
      and (not(jcr:content/metadata/@prism:expirationDate)
      or (jcr:content/metadata/@prism:expirationDate > xs:dateTime('2024-09-04T11:34:49.462Z')))
      and ((jcr:content/metadata/@ua:archivedDate > xs:dateTime('2024-09-04T11:17:26.334Z'))
      or not(jcr:content/metadata/@ua:archivedDate))
      and ((_x002e_/jcr:content/metadata/@dam:marketingprojectasset = '04_digital'))
      ]
    |
      /jcr:root/content/dam/projects/emea//element(*, dam:Asset)
      [
      ((_x002e_/jcr:content/metadata/@dc:format = 'image/png'))
      and (not(jcr:content/metadata/@dam:exclusive))
      and (not(jcr:content/metadata/@prism:expirationDate)
      or (jcr:content/metadata/@prism:expirationDate > xs:dateTime('2024-09-04T11:34:49.462Z')))
      and ((jcr:content/metadata/@ua:archivedDate > xs:dateTime('2024-09-04T11:17:26.334Z'))
      or not(jcr:content/metadata/@ua:archivedDate))
      and ((_x002e_/jcr:content/metadata/@dam:marketingprojectasset = '04_digital'))
      ]
    |
      /jcr:root/content/dam/projects/emea//element(*, dam:Asset)
      [
      ((_x002e_/jcr:content/metadata/@dam:regionalCreator = 'GLOBAL'))
      and (not(jcr:content/metadata/@dam:exclusive))
      and (not(jcr:content/metadata/@prism:expirationDate)
      or (jcr:content/metadata/@prism:expirationDate > xs:dateTime('2024-09-04T11:34:49.462Z')))
      and ((jcr:content/metadata/@ua:archivedDate > xs:dateTime('2024-09-04T11:17:26.334Z'))
      or not(jcr:content/metadata/@ua:archivedDate))
      and ((_x002e_/jcr:content/metadata/@dam:marketingprojectasset = '04_digital'))
      ]
    |
      /jcr:root/content/dam/marketing/global-resources//element(*, dam:Asset)
      [
      ((_x002e_/jcr:content/metadata/@dc:format = 'image/png'))
      and (not(jcr:content/metadata/@dam:exclusive))
      and (not(jcr:content/metadata/@prism:expirationDate)
      or (jcr:content/metadata/@prism:expirationDate > xs:dateTime('2024-09-04T11:34:49.462Z')))
      and ((jcr:content/metadata/@ua:archivedDate > xs:dateTime('2024-09-04T11:17:26.334Z'))
      or not(jcr:content/metadata/@ua:archivedDate))
      and ((_x002e_/jcr:content/metadata/@dam:marketingprojectasset = '04_digital'))
      ]
    |
      /jcr:root/content/dam/marketing/global-resources//element(*, dam:Asset)
      [
      ((_x002e_/jcr:content/metadata/@dam:regionalCreator = 'GLOBAL'))
      and (not(jcr:content/metadata/@dam:exclusive))
      and (not(jcr:content/metadata/@prism:expirationDate)
      or (jcr:content/metadata/@prism:expirationDate > xs:dateTime('2024-09-04T11:34:49.462Z')))
      and ((jcr:content/metadata/@ua:archivedDate > xs:dateTime('2024-09-04T11:17:26.334Z'))
      or not(jcr:content/metadata/@ua:archivedDate))
      and ((_x002e_/jcr:content/metadata/@dam:marketingprojectasset = '04_digital'))
      ])
      order by jcr:content/@jcr:lastModified descendin
    )

 

But if removing the group.p.or = true statement, or setting it to false group.p.or = false

The facets are structured correctly and the results matches the filters:

(
  /jcr:root/content/dam/projects/marketing/seasonal//element(*, dam:Asset)
  [
  ((_x002e_/jcr:content/metadata/@dc:format = 'image/png'))
  and ((_x002e_/jcr:content/metadata/@dam:regionalCreator = 'GLOBAL'))
  and (not(jcr:content/metadata/@dam:exclusive))
  and (not(jcr:content/metadata/@prism:expirationDate)
  or (jcr:content/metadata/@prism:expirationDate > xs:dateTime('2024-09-04T11:41:10.744Z')))
  and ((jcr:content/metadata/@ua:archivedDate > xs:dateTime('2024-09-04T11:17:26.334Z'))
  or not(jcr:content/metadata/@ua:archivedDate))
  and ((_x002e_/jcr:content/metadata/@dam:marketingprojectasset = '04_digital'))
  ]
|
  /jcr:root/content/dam/marketing/site-assets//element(*, dam:Asset)
  [
  ((_x002e_/jcr:content/metadata/@dc:format = 'image/png'))
  and ((_x002e_/jcr:content/metadata/@dam:regionalCreator = 'GLOBAL'))
  and (not(jcr:content/metadata/@dam:exclusive))
  and (not(jcr:content/metadata/@prism:expirationDate)
  or (jcr:content/metadata/@prism:expirationDate > xs:dateTime('2024-09-04T11:41:10.744Z')))
  and ((jcr:content/metadata/@ua:archivedDate > xs:dateTime('2024-09-04T11:17:26.334Z'))
  or not(jcr:content/metadata/@ua:archivedDate))
  and ((_x002e_/jcr:content/metadata/@dam:marketingprojectasset = '04_digital'))
  ]
|
  /jcr:root/content/dam/projects/emea//element(*, dam:Asset)
  [
  ((_x002e_/jcr:content/metadata/@dc:format = 'image/png'))
  and ((_x002e_/jcr:content/metadata/@dam:regionalCreator = 'GLOBAL'))
  and (not(jcr:content/metadata/@dam:exclusive))
  and (not(jcr:content/metadata/@prism:expirationDate)
  or (jcr:content/metadata/@prism:expirationDate > xs:dateTime('2024-09-04T11:41:10.744Z')))
  and ((jcr:content/metadata/@ua:archivedDate > xs:dateTime('2024-09-04T11:17:26.334Z'))
  or not(jcr:content/metadata/@ua:archivedDate))
  and ((_x002e_/jcr:content/metadata/@dam:marketingprojectasset = '04_digital'))
  ]
|
  /jcr:root/content/dam/marketing/global-resources//element(*, dam:Asset)
  [
  ((_x002e_/jcr:content/metadata/@dc:format = 'image/png'))
  and ((_x002e_/jcr:content/metadata/@dam:regionalCreator = 'GLOBAL'))
  and (not(jcr:content/metadata/@dam:exclusive))
  and (not(jcr:content/metadata/@prism:expirationDate)
  or (jcr:content/metadata/@prism:expirationDate > xs:dateTime('2024-09-04T11:41:10.744Z')))
  and ((jcr:content/metadata/@ua:archivedDate > xs:dateTime('2024-09-04T11:17:26.334Z'))
  or not(jcr:content/metadata/@ua:archivedDate))
  and ((_x002e_/jcr:content/metadata/@dam:marketingprojectasset = '04_digital'))
  ])
  order by jcr:content/@jcr:lastModified descendin
)

 

Useful reference: https://github.com/adobe/asset-share-commons/issues/239 

Views

198

Replies

2
Sign in to like this content

Total Likes

Translate
Translate
2 Replies

Avatar

Community Advisor
Community Advisor
9/13/24 8:52:34 AM

@pabloram23 Is this the similar issue been discussed in below post ? replacing the or condition with and, if yes please check the solution provided. 

https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager-assets/issue-on-fetching-r...

 

 

Views

152

Replies

1
Sign in to like this content

Total Likes

Translate
Translate

Avatar

Level 2
Level 2
9/13/24 9:36:48 AM
In response to Saravanan_Dharmaraj

Hi @Saravanan_Dharmaraj thanks for replying. It is not the same case because the one you provided is regarding multiple options (values) in one single filter. My case is three or more different filters with one value assigned.

Views

147

Replies

0
Sign in to like this content

Total Likes

Translate
Translate
Related Conversations
Unable to find users , user roles , company information through Mangento Rest API in postman

Views

125

Likes

0

Replies

1
Adobe Developers Live, November 2024, Session | Assets Migration Blueprint

Views

172

Likes

0

Replies

0
Adobe Developers Live, November 2024, Session | Bringing AI and Personalization to AEM Edge Delivery Services

Views

216

Likes

0

Replies

0
Adobe Developers Live, November 2024, On-Demand Session | Content Supply Chain Workflows with power of Asset Selector

Views

106

Likes

0

Replies

0
Adobe Developers Live, November 2024, On-Demand Session | Energizing Adobe Commerce with AEM Assets and Gen AI

Views

116

Likes

0

Replies

0