Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Querying jcr:score

diegow5307109
Level 1
Level 1

Good morning team.

I'm trying to retrieve the value of jcr:score for a full text search, but I'm not able to see the value using the following query

is there a way to see this value in a query?


Regards.

4 Replies
hamidk92094312
Employee
Employee

You can use JCR Query Cheat Sheet [1] to build your query. It might be easier to build a SQL/SQL2 query then you can generate the xpath query from the SQL query in CRX/DE

[1] https://wiki.magnolia-cms.com/display/WIKI/JCR+Query+Cheat+Sheet

diegow5307109
Level 1
Level 1

Thanks for your reply Hamid.

I'm using the query debugger (http://localhost:4502/libs/cq/search/content/querydebug.html​ ) to run the query and I'm able to see some properties clicking on the link JSON QueryBuilder Link​​​, but the jcr:score property is never shown in any of the values in the JSON.

Also the generated Xpath is

/jcr:root/content/stantec//element(*, cq:PageContent)

[

(jcr:contains(., 'David Dixon')

and @jcr:title)

]

hamidk92094312
Employee
Employee

This could potentially be due to JSON Max results i.e. json.maximumresults, [1] assuming the query is fine. When this limit is exceeded the rendering will be collapsed.

[1] Security Checklist

diegow5307109
Level 1
Level 1

the JSON is not that deep

{

  • success: true,
  • results: 8,
  • total: 8,
  • more: false,
  • offset: 0,
  • hits:

    [

    • {
      • path: "/content/stantec/en/markets/urban-places/resilience/about-resilience/jcr:content",
      • excerpt: "a changing world Envision the future BACK →",
      • name: "jcr:content",
      • title: "About Resilience",
      • lastModified: "2018-03-01 12:13:54",
      • created: "2019-06-17 14:32:24"
      },
      .
      .
      .

     ]
}