Querying jcr:score

[diegow5307109]

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.

[hamidk92094312]

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]

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]

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]

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"
    },
    .
    .
    .

     ]
}