[NXP-13718] Allow customizing the select statement on NXQL query builder used by page providers - Nuxeo Issue Tracker

XML

Word

Printable

Impact type:

Configuration Change
Upgrade notes:

Hide

fixedPart element on whereClause in page provider definition now accepts the select statement.

sample usage:
<whereClause docType="AdvancedSearch">
<fixedPart statement="SELECT * FROM Note">
ecm:parentId = ? AND ecm:isCheckedInVersion = 0 AND
ecm:mixinType !=
'HiddenInNavigation' AND ecm:currentLifeCycleState !=
'deleted'
</fixedPart>
[...]
</whereClause>

Show
fixedPart element on whereClause in page provider definition now accepts the select statement. sample usage: <whereClause docType="AdvancedSearch"> <fixedPart statement="SELECT * FROM Note"> ecm:parentId = ? AND ecm:isCheckedInVersion = 0 AND ecm:mixinType != 'HiddenInNavigation' AND ecm:currentLifeCycleState != 'deleted' </fixedPart> [...] </whereClause>

Default NXQL page providers use the hardcoded "select * from Document" when building the select statement.

It should be easy to override it, has it can be more efficient to "select * from Note" or "select * from Note,File" for instance.

is required by

NXS-1972 Allow configuring the default statement in Content Views