Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-13718

Allow customizing the select statement on NXQL query builder used by page providers

    Details

    • 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>

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

                  Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.