Hi,
How to use and show a Computed Pseudofield property value
from another application
inside the database list ?
with the use of Hibernate Query / HQL
The way to do this is explained here, but for a ShortText property (shortText1).
Database List documentation page :
It explains :
“property value from another application (represented for example by the class application.Code.applicationClass) inside the database list you should use the “Hibernate Query” field.”
And to use this query :
select d.fullName, prop.id.value from XWikiDocument as d, BaseObject as o,
StringProperty as prop where o.name = d.fullName and o.className = 'application.Code.applicationClass'
and d.fullName <> 'application.Code.applicationTemplate' and o.id=prop.id.id and prop.id.name='shortText1'
In the documentation : Computed Pseudofield
There neither more explanation about that.
It works with prop.id.name=‘shortText1’
But not with : prop.id.name=‘title1’
title1 is the title of the AWM instance, so it is a Computed Field.
I guess it need to use something else than a “StringProperty as prop” in the HQL request.
Please :
What to use ?
Is there anoter way to get this Computed Field value retrieved in the HQL request and then shown in the select of the Database List ?
Meaning : how to get the underlying value, that is used then as a Title, in the ComputedField ?
This title value is stored somewhere, no ?
I don’t need to make a join on it, or write it : only read it.
May be, later, sort it … sort the request, on this underlying field…
Note : this post ask also this, but no answers (may 2023) :