Platform Explorer / Nuxeo Platform LTS 2015 7.10

Extension point providers

Contribution Descriptor

Existing Contributions

  • nuxeo-platform-spreadsheet-7.10-HF06.jar /OSGI-INF/page-providers-contrib.xml
    <extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">
        <coreQueryPageProvider name="spreadsheet_query">
          <property name="maxResults">1000</property>
          <pattern escapeParameters="false" quoteParameters="false">?</pattern>
          <pageSize>1000</pageSize>
        </coreQueryPageProvider>
      </extension>
  • nuxeo-routing-dm-7.10.jar /OSGI-INF/dm-pageproviders-contrib.xml
    <extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">
       
        <coreQueryPageProvider name="default_section_suggestion">
          <pattern escapeParameters="true" quoteParameters="false">
            SELECT * FROM Section WHERE dc:title LIKE '?%' AND ecm:mixinType !=
            'HiddenInNavigation' AND ecm:isCheckedInVersion = 0 AND
            ecm:currentLifeCycleState != 'deleted'
          </pattern>
          <!-- sort column="dc:title" ascending="true" / sort by fulltext relevance -->
          <pageSize>5</pageSize>
        </coreQueryPageProvider>
    
      </extension>
  • nuxeo-automation-features-7.10-HF05.jar /OSGI-INF/pageprovider-contrib.xml
    <extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">
    
        <genericPageProvider class="org.nuxeo.ecm.platform.audit.api.AuditPageProvider" name="AUDIT_BROWSER">
          <whereClause docType="BasicAuditSearch">
            <predicate operator=">" parameter="log.id">
              <field name="logId" schema="basicauditsearch"/>
            </predicate>
            <predicate operator="BETWEEN" parameter="log.eventDate">
              <field name="startDate" schema="basicauditsearch"/>
              <field name="endDate" schema="basicauditsearch"/>
            </predicate>
            <predicate operator="IN" parameter="log.category">
              <field name="eventCategories" schema="basicauditsearch"/>
            </predicate>
            <predicate operator="IN" parameter="log.eventId">
              <field name="eventIds" schema="basicauditsearch"/>
            </predicate>
            <predicate operator="IN" parameter="log.principalName">
              <field name="principalNames" schema="basicauditsearch"/>
            </predicate>
          </whereClause>
          <sort ascending="true" column="log.eventDate"/>
          <sort ascending="true" column="log.id"/>
          <pageSize>10</pageSize>
        </genericPageProvider>
    
      </extension>
  • nuxeo-drive-core-7.10-HF07.jar /OSGI-INF/nuxeodrive-pageproviders-contrib.xml
    <extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">
    
        <coreQueryPageProvider name="FOLDER_ITEM_CHILDREN">
          <pattern>
            SELECT * FROM Document WHERE ecm:parentId = ?
            AND ecm:isCheckedInVersion = 0
            AND ecm:currentLifeCycleState != 'deleted'
            AND ecm:mixinType != 'HiddenInNavigation'
          </pattern>
          <sort ascending="true" column="dc:created"/>
          <pageSize>1000</pageSize>
          <maxPageSize>1000</maxPageSize>
          <property name="maxResults">PAGE_SIZE</property>
        </coreQueryPageProvider>
    
      </extension>
  • nuxeo-platform-webapp-base-7.10-HF07.jar /OSGI-INF/pageproviders-contrib.xml
    <extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">
    
        <documentation>
          This contribution declares page providers used by UI components.
    
          The page provider 'tree_children' is used to list children in the tree
          navigation.
    
          Note the "ecm:isProxy = 0" predicate optimization that is required to
          simplify greatly the request performed by the tree manager when browsing
          on folders with a lot of files when using the Visible SQL Storage.
    
          The page provider 'default_document_suggestion' is used by default by the
          component performing document suggestions.
        </documentation>
    
        <coreQueryPageProvider name="tree_children">
          <property name="maxResults">PAGE_SIZE</property>
          <pattern>
            SELECT * FROM Document WHERE ecm:parentId = ? AND ecm:isProxy = 0 AND
            ecm:mixinType = 'Folderish' AND ecm:mixinType != 'HiddenInNavigation'
            AND ecm:isCheckedInVersion = 0 AND ecm:currentLifeCycleState !=
            'deleted'
          </pattern>
          <sort ascending="true" column="dc:title"/>
          <pageSize>50</pageSize>
        </coreQueryPageProvider>
    
        <coreQueryPageProvider name="default_document_suggestion">
          <property name="maxResults">PAGE_SIZE</property>
          <pattern escapeParameters="true" quoteParameters="false">
            SELECT * FROM Document WHERE ecm:fulltext LIKE '?*' AND ecm:mixinType !=
            'HiddenInNavigation' AND ecm:isCheckedInVersion = 0 AND
            ecm:currentLifeCycleState != 'deleted'
          </pattern>
          <!-- sort column="dc:title" ascending="true" / sort by fulltext relevance -->
          <pageSize>5</pageSize>
        </coreQueryPageProvider>
    
      </extension>
  • nuxeo-platform-webapp-core-7.10-HF07.jar /OSGI-INF/pageproviders-webapp-contrib.xml
    <extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">
    
        <coreQueryPageProvider name="search_media_all">
          <property name="maxResults">PAGE_SIZE</property>
          <pattern>
            SELECT * FROM Document WHERE ecm:primaryType = ?
          </pattern>
          <sort ascending="true" column="dc:title"/>
          <pageSize>100</pageSize>
        </coreQueryPageProvider>
    
        <coreQueryPageProvider name="search_media_by_title">
          <property name="maxResults">PAGE_SIZE</property>
          <pattern>
            SELECT * FROM Document WHERE ecm:primaryType = ?
            AND ecm:fulltext LIKE ?
          </pattern>
          <sort ascending="true" column="dc:title"/>
          <pageSize>100</pageSize>
        </coreQueryPageProvider>
    
        <genericPageProvider class="org.nuxeo.ecm.webapp.provider.ImportFolderPageProvider" name="importFolders">
          <pattern escapeParameters="true" quoteParameters="false">
            SELECT * FROM Document WHERE ecm:fulltext.dc:title LIKE '?%' AND ecm:mixinType !=
            'HiddenInNavigation' AND ecm:mixinType = 'Folderish'
            AND ecm:currentLifeCycleState != 'deleted'
            AND SORTED_COLUMN IS NOT NULL
          </pattern>
          <sort ascending="true" column="dc:title"/>
          <pageSize>10</pageSize>
        </genericPageProvider>
    
        <coreQueryPageProvider name="breadcrumb_user_domains">
          <property name="maxResults">DEFAULT_NAVIGATION_RESULTS</property>
          <pattern>
            SELECT * FROM Domain WHERE ecm:mixinType != 'HiddenInNavigation'
            AND ecm:currentLifeCycleState != 'deleted'
          </pattern>
          <sort ascending="true" column="dc:title"/>
          <pageSize>0</pageSize>
        </coreQueryPageProvider>
    
      </extension>
  • nuxeo-admin-center-7.10-HF07.jar /OSGI-INF/pageproviders-contrib.xml
    <extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">
    
        <genericPageProvider class="org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchPageProvider" name="permissions_purge">
          <whereClause docType="PermissionsSearch">
            <fixedPart statement="SELECT ecm:uuid, dc:title, ecm:acl/*1/principal, ecm:acl/*1/creator, ecm:acl/*1/permission, ecm:acl/*1/begin, ecm:acl/*1/end FROM Document">
              ecm:mixinType != 'HiddenInNavigation'
              AND ecm:isCheckedInVersion = 0
              AND SORTED_COLUMN IS NOT NULL
            </fixedPart>
            <predicate operator="IN" parameter="ecm:acl/*1/principal">
              <field name="ace_username" schema="permissions_search"/>
            </predicate>
            <predicate operator="IN" parameter="ecm:ancestorId">
              <field name="ecm_ancestorIds" schema="permissions_search"/>
            </predicate>
          </whereClause>
          <pageSize>20</pageSize>
          <sort ascending="true" column="dc:title"/>
        </genericPageProvider>
    
        <coreQueryPageProvider name="permissions_search_folders">
          <pattern escapeParameters="true" quoteParameters="false">
            SELECT * FROM Document WHERE dc:title LIKE '?%' AND ecm:mixinType = 'Folderish'
            AND ecm:mixinType != 'HiddenInNavigation' AND ecm:isCheckedInVersion = 0 AND
            ecm:currentLifeCycleState != 'deleted'
          </pattern>
          <pageSize>10</pageSize>
        </coreQueryPageProvider>
    
      </extension>
  • nuxeo-automation-server-7.10-HF07.jar /OSGI-INF/pageprovider-contrib.xml
    <extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">
        <coreQueryPageProvider name="CURRENT_DOC_CHILDREN">
          <property name="maxResults">PAGE_SIZE</property>
          <pattern>
            SELECT * FROM Document WHERE ecm:parentId = ? AND
            ecm:mixinType != 'HiddenInNavigation'
            AND ecm:isCheckedInVersion = 0 AND ecm:currentLifeCycleState !=
            'deleted'
          </pattern>
          <sort ascending="true" column="dc:title"/>
          <pageSize>50</pageSize>
        </coreQueryPageProvider>
      </extension>
  • nuxeo-web-mobile-cap-7.10.jar /OSGI-INF/web-mobile-pageproviders-contrib.xml
    <extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">
    
          <coreQueryPageProvider name="search_core_default">
            <property name="coreSession">#{documentManager}</property>
            <whereClause docType="DefaultSearch">
              <fixedPart>
                ecm:mixinType != 'HiddenInNavigation' AND ecm:isProxy = 0
                AND ecm:isCheckedInVersion = 0 AND ecm:currentLifeCycleState != 'deleted'
                AND SORTED_COLUMN IS NOT NULL
              </fixedPart>
              <predicate operator="FULLTEXT" parameter="ecm:fulltext">
                <field name="ecm_fulltext" schema="default_search"/>
              </predicate>
              <predicate operator="IN" parameter="dc:creator">
                <field name="dc_creator" schema="default_search"/>
              </predicate>
              <predicate operator="BETWEEN" parameter="dc:created">
                <field name="dc_created_min" schema="default_search"/>
                <field name="dc_created_max" schema="default_search"/>
              </predicate>
              <predicate operator="STARTSWITH" parameter="dc:subjects">
                <field name="dc_subjects" schema="default_search"/>
              </predicate>
              <predicate operator="STARTSWITH" parameter="dc:coverage">
                <field name="dc_coverage" schema="default_search"/>
              </predicate>
              <predicate operator="STARTSWITH" parameter="ecm:path">
                <field name="ecm_path" schema="default_search"/>
              </predicate>
              <predicate operator="IN" parameter="collectionMember:collectionIds">
                <field name="ecm_collections" schema="default_search"/>
              </predicate>
            </whereClause>
            <sort ascending="true" column="dc:title"/>
            <pageSize>20</pageSize>
          </coreQueryPageProvider>
    
      </extension>
  • nuxeo-admin-center-7.10-HF07.jar /OSGI-INF/content-view-contrib.xml
    <extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">
    
        <genericPageProvider class="org.nuxeo.ecm.platform.audit.api.AuditPageProvider" name="EVENTS_VIEW">
            <whereClause docType="BasicAuditSearch">
              <predicate operator="BETWEEN" parameter="log.eventDate">
                <field name="startDate" schema="basicauditsearch"/>
                <field name="endDate" schema="basicauditsearch"/>
              </predicate>
              <predicate operator="=" parameter="log.category">
                <field name="eventCategory" schema="basicauditsearch"/>
              </predicate>
              <predicate operator="IN" parameter="log.eventId">
                <field name="eventIds" schema="basicauditsearch"/>
              </predicate>
              <predicate operator="=" parameter="log.principalName">
                <field name="principalName" schema="basicauditsearch"/>
              </predicate>
            </whereClause>
            <sort ascending="false" column="log.eventDate"/>
            <pageSize>10</pageSize>
            <maxPageSize>1000</maxPageSize>
          </genericPageProvider>
    
      </extension>
  • nuxeo-easyshare-7.10-HF02.jar /OSGI-INF/easyshare-contrib.xml
    <extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">
        <coreQueryPageProvider name="EASYSHARE_FOLDER_CONTENT_PP">
          <pattern>
          <!-- Note: we want proxies.
           Parameter is the EasyFolder id -->
            SELECT * FROM Document WHERE ecm:parentId = ? AND ecm:isVersion = 0 AND
            ecm:isCheckedInVersion = 0 AND ecm:mixinType != 'HiddenInNavigation'
            AND ecm:currentLifeCycleState != 'deleted'
          </pattern>
          <sort ascending="true" column="dc:title"/>
          <pageSize>0</pageSize>
          <maxPageSize>0</maxPageSize>
        </coreQueryPageProvider>
    
      </extension>
  • nuxeo-rest-api-server-7.10-HF07.jar /OSGI-INF/searchadapter-pp-contrib.xml
    <extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">
            <coreQueryPageProvider name="REST_API_SEARCH_ADAPTER">
                <pageSize>0</pageSize>
                <maxPageSize>0</maxPageSize>
            </coreQueryPageProvider>
        </extension>
  • nuxeo-elasticsearch-audit-7.10.jar /OSGI-INF/es-audit-pageprovider-contrib.xml
    <extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">
    
        <genericPageProvider class="org.nuxeo.elasticsearch.audit.pageprovider.ESAuditPageProvider" name="DOCUMENT_HISTORY_PROVIDER_OLD">
          <whereClause docType="BasicAuditSearch">
            <fixedPart>
                {
    		        "bool" : {
    		          "must" : {
    		            "match" : {
    		              "docUUID" : {
    		                "query" : "?",
    		                "type" : "boolean"
    		              }
    		            }
    		          }
    		        }
    			  }          
            </fixedPart>
            <predicate operator="BETWEEN" parameter="eventDate">
              <field name="startDate" schema="basicauditsearch"/>
              <field name="endDate" schema="basicauditsearch"/>
            </predicate>
            <predicate operator="IN" parameter="category">
              <field name="eventCategories" schema="basicauditsearch"/>
            </predicate>
            <predicate operator="IN" parameter="eventId">
              <field name="eventIds" schema="basicauditsearch"/>
            </predicate>
            <predicate operator="IN" parameter="principalName">
              <field name="principalNames" schema="basicauditsearch"/>
            </predicate>
          </whereClause>
          <sort ascending="true" column="id"/>
          <pageSize>5</pageSize>
        </genericPageProvider>
    
    
        <genericPageProvider class="org.nuxeo.elasticsearch.audit.pageprovider.ESDocumentHistoryPageProvider" name="DOCUMENT_HISTORY_PROVIDER">
          <whereClause docType="BasicAuditSearch">
            <predicate operator="BETWEEN" parameter="eventDate">
              <field name="startDate" schema="basicauditsearch"/>
              <field name="endDate" schema="basicauditsearch"/>
            </predicate>
            <predicate operator="IN" parameter="category">
              <field name="eventCategories" schema="basicauditsearch"/>
            </predicate>
            <predicate operator="IN" parameter="eventId">
              <field name="eventIds" schema="basicauditsearch"/>
            </predicate>
            <predicate operator="IN" parameter="principalName">
              <field name="principalNames" schema="basicauditsearch"/>
            </predicate>                
          </whereClause>
          <sort ascending="false" column="eventDate"/>
            <pageSize>10</pageSize>
            <maxPageSize>1000</maxPageSize>
        </genericPageProvider>
    
          <genericPageProvider class="org.nuxeo.elasticsearch.audit.pageprovider.ESAuditPageProvider" name="ADMIN_HISTORY">
            <property name="coreSession"/>
            <property name="generateUIComments">false</property>
            <whereClause docType="BasicAuditSearch">
              <predicate operator="BETWEEN" parameter="eventDate">
                <field name="startDate" schema="basicauditsearch"/>
                <field name="endDate" schema="basicauditsearch"/>
              </predicate>
              <predicate operator="=" parameter="category">
                <field name="eventCategory" schema="basicauditsearch"/>
              </predicate>
              <predicate operator="IN" parameter="eventId">
                <field name="eventIds" schema="basicauditsearch"/>
              </predicate>
              <predicate operator="=" parameter="principalName">
                <field name="principalName" schema="basicauditsearch"/>
              </predicate>
            </whereClause>
            <sort ascending="false" column="eventDate"/>
            <pageSize>10</pageSize>
            <maxPageSize>1000</maxPageSize>
          </genericPageProvider>
    
      </extension>
  • nuxeo-platform-filemanager-core-7.10.jar /OSGI-INF/nxfilemanager-pageprovider-contrib.xml
    <extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">
    
        <coreQueryPageProvider name="DEFAULT_CREATION_CONTAINER_LIST_PROVIDER">
          <pattern>
            SELECT * FROM Document WHERE ecm:primaryType IN ('Workspace',
            'Folder') AND ecm:currentLifeCycleState != 'deleted'
          </pattern>
          <sort ascending="true" column="ecm:path"/>
        </coreQueryPageProvider>
    
      </extension>
  • nuxeo-platform-task-automation-7.10-HF04.jar /OSGI-INF/pageproviders-contrib.xml
    <extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">
    
        <genericPageProvider class="org.nuxeo.ecm.platform.task.providers.UserTaskPageProvider" name="user_tasks">
          <property name="locale">#{localeSelector.localeString}</property>
          <pageSize>20</pageSize>
          <sort ascending="true" column="nt:dueDate"/>
        </genericPageProvider>
    
      </extension>
  • nuxeo-platform-forum-7.10.jar /OSGI-INF/forum-pageprovider-contrib.xml
    <extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">
    
        <coreQueryPageProvider name="GET_FORUM_MODERATION_TASKS">
          <pattern>
            SELECT * FROM Document WHERE ecm:mixinType = 'Task' AND
            ecm:currentLifeCycleState
            NOT IN ('ended', 'cancelled') AND ecm:isProxy =
            0 AND nt:targetDocumentId = ? AND nt:task_variables/*/key = 'commentId' AND
            nt:task_variables/*/value = ?
          </pattern>
          <pageSize>0</pageSize>
          <maxPageSize>0</maxPageSize>
        </coreQueryPageProvider>
    
      </extension>
  • nuxeo-platform-tag-core-7.10.jar /OSGI-INF/tag-pageprovider-contrib.xml
    <extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">
    
        <genericPageProvider class="org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchPageProvider" name="GET_DOCUMENT_IDS_FOR_TAG">
          <property name="useUnrestrictedSession">true</property>
          <pattern>
            SELECT ecm:uuid FROM Tag WHERE tag:label = ? AND ecm:isProxy = 0
          </pattern>
          <pageSize>1</pageSize>
        </genericPageProvider>
    
        <genericPageProvider class="org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchPageProvider" name="GET_FIRST_TAGGING_FOR_DOC_AND_TAG">
          <property name="useUnrestrictedSession">true</property>
          <pattern>
            SELECT ecm:uuid FROM Tagging WHERE relation:source = ? AND
            relation:target = ?
          </pattern>
          <pageSize>1</pageSize>
        </genericPageProvider>
    
        <genericPageProvider class="org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchPageProvider" name="GET_FIRST_TAGGING_FOR_DOC_AND_TAG_AND_USER">
          <property name="useUnrestrictedSession">true</property>
          <pattern>
            SELECT ecm:uuid FROM Tagging WHERE relation:source = ? AND
            relation:target = ? AND dc:creator = ?
          </pattern>
          <pageSize>1</pageSize>
        </genericPageProvider>
    
        <!-- page provider that can be optimized using ES for instance -->
        <genericPageProvider class="org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchPageProvider" name="GET_TAGS_FOR_DOCUMENT">
          <property name="useUnrestrictedSession">true</property>
          <property name="language">NXTAG</property>
          <pattern>
            TAGISTARGET: SELECT DISTINCT tag:label FROM Tagging WHERE
            relation:source = ?
          </pattern>
          <pageSize>0</pageSize>
          <maxPageSize>0</maxPageSize>
        </genericPageProvider>
    
        <!-- page provider that should keep on using the VCS storage -->
        <genericPageProvider class="org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchPageProvider" name="GET_TAGS_FOR_DOCUMENT_CORE">
          <property name="useUnrestrictedSession">true</property>
          <property name="language">NXTAG</property>
          <pattern>
            TAGISTARGET: SELECT DISTINCT tag:label FROM Tagging WHERE
            relation:source = ?
          </pattern>
          <pageSize>0</pageSize>
          <maxPageSize>0</maxPageSize>
        </genericPageProvider>
    
        <genericPageProvider class="org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchPageProvider" name="GET_DOCUMENTS_FOR_TAG">
          <property name="useUnrestrictedSession">true</property>
          <property name="language">NXTAG</property>
          <pattern>
            TAGISTARGET: SELECT DISTINCT relation:source FROM Tagging WHERE
            tag:label = ?
          </pattern>
          <pageSize>0</pageSize>
          <maxPageSize>0</maxPageSize>
        </genericPageProvider>
    
        <!-- page provider that can be optimized using ES for instance -->
        <genericPageProvider class="org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchPageProvider" name="GET_TAGS_FOR_DOCUMENT_AND_USER">
          <property name="useUnrestrictedSession">true</property>
          <property name="language">NXTAG</property>
          <pattern>
            TAGISTARGET: SELECT DISTINCT tag:label FROM Tagging WHERE
            relation:source = ? AND dc:creator = ?
          </pattern>
          <pageSize>0</pageSize>
          <maxPageSize>0</maxPageSize>
        </genericPageProvider>
    
        <!-- page provider that should keep on using the VCS storage -->
        <genericPageProvider class="org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchPageProvider" name="GET_TAGS_FOR_DOCUMENT_AND_USER_CORE">
          <property name="useUnrestrictedSession">true</property>
          <property name="language">NXTAG</property>
          <pattern>
            TAGISTARGET: SELECT DISTINCT tag:label FROM Tagging WHERE
            relation:source = ? AND dc:creator = ?
          </pattern>
          <pageSize>0</pageSize>
          <maxPageSize>0</maxPageSize>
        </genericPageProvider>
    
        <genericPageProvider class="org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchPageProvider" name="GET_DOCUMENTS_FOR_TAG_AND_USER">
          <property name="useUnrestrictedSession">true</property>
          <property name="language">NXTAG</property>
          <pattern>
            TAGISTARGET: SELECT DISTINCT relation:source FROM Tagging WHERE
            tag:label = ? AND dc:creator = ?
          </pattern>
          <pageSize>0</pageSize>
          <maxPageSize>0</maxPageSize>
        </genericPageProvider>
    
        <genericPageProvider class="org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchPageProvider" name="GET_TAGS_TO_COPY_FOR_DOCUMENT">
          <property name="useUnrestrictedSession">true</property>
          <property name="language">NXTAG</property>
          <pattern>
            TAGISTARGET: SELECT tag:label, dc:created, dc:creator,
            relation:target FROM Tagging
            WHERE relation:source = ?
          </pattern>
          <pageSize>0</pageSize>
          <maxPageSize>0</maxPageSize>
        </genericPageProvider>
    
        <genericPageProvider class="org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchPageProvider" name="GET_TAG_SUGGESTIONS">
          <property name="useUnrestrictedSession">true</property>
          <pattern>
            SELECT DISTINCT tag:label FROM Tag WHERE tag:label LIKE ? AND
            ecm:isProxy = 0
          </pattern>
          <pageSize>0</pageSize>
          <maxPageSize>0</maxPageSize>
        </genericPageProvider>
    
        <genericPageProvider class="org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchPageProvider" name="GET_TAG_SUGGESTIONS_FOR_USER">
          <property name="useUnrestrictedSession">true</property>
          <pattern>
            SELECT DISTINCT tag:label FROM Tag WHERE tag:label LIKE ? AND
            ecm:isProxy = 0
          </pattern>
          <pageSize>0</pageSize>
          <maxPageSize>0</maxPageSize>
        </genericPageProvider>
    
        <genericPageProvider class="org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchPageProvider" name="GET_ALL_TAGS">
          <property name="useUnrestrictedSession">true</property>
          <property name="language">NXTAG</property>
          <pattern>
            COUNTSOURCE: SELECT tag:label, relation:source FROM Tagging
          </pattern>
          <pageSize>0</pageSize>
          <maxPageSize>0</maxPageSize>
        </genericPageProvider>
    
        <genericPageProvider class="org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchPageProvider" name="GET_ALL_TAGS_FOR_USER">
          <property name="useUnrestrictedSession">true</property>
          <property name="language">NXTAG</property>
          <pattern>
            COUNTSOURCE: SELECT tag:label, relation:source FROM Tagging WHERE
            dc:creator = ?
          </pattern>
          <pageSize>0</pageSize>
          <maxPageSize>0</maxPageSize>
        </genericPageProvider>
    
        <genericPageProvider class="org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchPageProvider" name="GET_TAGS_FOR_DOCUMENTS">
          <property name="useUnrestrictedSession">true</property>
          <property name="language">NXTAG</property>
          <pattern>
            COUNTSOURCE: SELECT tag:label, relation:source FROM Tagging WHERE
            relation:source IN ?
          </pattern>
          <pageSize>0</pageSize>
          <maxPageSize>0</maxPageSize>
        </genericPageProvider>
    
        <genericPageProvider class="org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchPageProvider" name="GET_TAGS_FOR_DOCUMENTS_AND_USER">
          <property name="useUnrestrictedSession">true</property>
          <property name="language">NXTAG</property>
          <pattern>
            COUNTSOURCE: SELECT tag:label, relation:source FROM Tagging WHERE
            relation:source IN ? AND dc:creator = ?
          </pattern>
          <pageSize>0</pageSize>
          <maxPageSize>0</maxPageSize>
        </genericPageProvider>
    
        <genericPageProvider class="org.nuxeo.ecm.platform.query.nxql.CoreQueryAndFetchPageProvider" name="GET_TAGGED_DOCUMENTS_UNDER">
          <property name="useUnrestrictedSession">true</property>
          <pattern>
            SELECT ecm:uuid FROM Document WHERE ecm:path STARTSWITH ?
          </pattern>
          <pageSize>0</pageSize>
          <maxPageSize>0</maxPageSize>
        </genericPageProvider>
    
      </extension>
  • nuxeo-platform-collections-core-7.10-HF03.jar /OSGI-INF/collection-pageprovider-contrib.xml
    <extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">
    
        <coreQueryPageProvider name="default_collection">
          <property name="maxResults">PAGE_SIZE</property>
          <pattern escapeParameters="true" quoteParameters="false">
            SELECT * FROM Document WHERE dc:title ILIKE '?%' AND ecm:mixinType = 'Collection' AND
            (ecm:primaryType != 'Favorites' OR (ecm:primaryType = 'Favorites' AND dc:creator = '?')) AND
            ecm:isProxy = 0 AND ecm:mixinType != 'HiddenInNavigation' AND
            ecm:isCheckedInVersion = 0 AND ecm:currentLifeCycleState != 'deleted'
          </pattern>
          <parameter>#{currentUser.name}</parameter>
          <sort ascending="true" column="dc:title"/>
          <pageSize>50</pageSize>
        </coreQueryPageProvider>
    
        <coreQueryPageProvider name="default_collection_candidate">
          <property name="maxResults">PAGE_SIZE</property>
          <pattern escapeParameters="true" quoteParameters="false">
            SELECT * FROM Document where dc:title ILIKE '?%' AND ecm:isProxy = 0
            AND ecm:mixinType != 'SystemDocument' AND ecm:mixinType !=
            'NotCollectionMember' AND ecm:mixinType != 'HiddenInNavigation' AND
            ecm:isCheckedInVersion = 0 AND ecm:currentLifeCycleState != 'deleted'
          </pattern>
          <sort ascending="true" column="dc:title"/>
          <pageSize>50</pageSize>
        </coreQueryPageProvider>
    
        <coreQueryPageProvider name="default_content_collection">
          <property name="maxResults">PAGE_SIZE</property>
          <pattern>
            SELECT * FROM Document where ecm:mixinType != 'HiddenInNavigation' AND
            ecm:isCheckedInVersion = 0 AND ecm:currentLifeCycleState !=
            'deleted' AND collectionMember:collectionIds/* = ?
          </pattern>
          <sort ascending="true" column="dc:title"/>
          <pageSize>50</pageSize>
        </coreQueryPageProvider>
    
        <coreQueryPageProvider name="all_collections">
          <property name="maxResults">PAGE_SIZE</property>
          <pattern>
            SELECT * FROM Document WHERE ecm:mixinType = 'Collection' AND
            ecm:isProxy = 0 AND ecm:mixinType != 'HiddenInNavigation' AND
            ecm:isCheckedInVersion = 0 AND ecm:currentLifeCycleState != 'deleted'
          </pattern>
          <pageSize>1000</pageSize>
        </coreQueryPageProvider>
    
      </extension>
  • nuxeo-elasticsearch-audit-7.10.jar /OSGI-INF/admin-pageprovider-contrib.xml
    <extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">
    
          <genericPageProvider class="org.nuxeo.elasticsearch.audit.pageprovider.ESAuditPageProvider" name="EVENTS_VIEW">
            <property name="coreSession">#{documentManager}</property>
            <property name="generateUIComments">false</property>
            <whereClause docType="BasicAuditSearch">
              <predicate operator="BETWEEN" parameter="eventDate">
                <field name="startDate" schema="basicauditsearch"/>
                <field name="endDate" schema="basicauditsearch"/>
              </predicate>
              <predicate operator="=" parameter="category">
                <field name="eventCategory" schema="basicauditsearch"/>
              </predicate>
              <predicate operator="IN" parameter="eventId">
                <field name="eventIds" schema="basicauditsearch"/>
              </predicate>
              <predicate operator="=" parameter="principalName">
                <field name="principalName" schema="basicauditsearch"/>
              </predicate>
            </whereClause>
            <sort ascending="false" column="eventDate"/>
            <pageSize>10</pageSize>
            <maxPageSize>1000</maxPageSize>
          </genericPageProvider>
    
      </extension>
  • nuxeo-user-dashboard-7.10-HF01.jar /OSGI-INF/pageproviders-contrib.xml
    <extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">
    
        <coreQueryPageProvider name="user_domains">
          <property name="maxResults">DEFAULT_NAVIGATION_RESULTS</property>
          <pattern>
            SELECT * FROM Domain WHERE ecm:mixinType != 'HiddenInNavigation'
            AND ecm:currentLifeCycleState != 'deleted'
          </pattern>
          <sort ascending="true" column="dc:title"/>
          <pageSize>0</pageSize>
        </coreQueryPageProvider>
    
        <coreQueryPageProvider name="domain_documents">
          <property name="maxResults">DEFAULT_NAVIGATION_RESULTS</property>
          <pattern>
            SELECT * FROM Document WHERE ecm:path STARTSWITH ?
            AND ecm:mixinType != 'Folderish' AND ecm:mixinType !=
            'SystemDocument' AND ecm:mixinType !=
            'HiddenInNavigation' AND ecm:isCheckedInVersion = 0 AND ecm:isProxy = 0
            AND ecm:currentLifeCycleState != 'deleted'
          </pattern>
          <sort ascending="false" column="dc:modified"/>
          <pageSize>5</pageSize>
        </coreQueryPageProvider>
    
        <coreQueryPageProvider name="domain_published_documents">
          <property name="maxResults">DEFAULT_NAVIGATION_RESULTS</property>
          <pattern>
            SELECT * FROM Document WHERE ecm:path STARTSWITH ? AND ecm:mixinType !=
            'Folderish' AND ecm:mixinType != 'HiddenInNavigation' AND
            ecm:mixinType != 'SystemDocument' AND
            ecm:isCheckedInVersion = 0 AND ecm:isProxy = 1
          </pattern>
          <sort ascending="false" column="dc:issued"/>
          <pageSize>5</pageSize>
        </coreQueryPageProvider>
    
        <coreQueryPageProvider name="user_documents">
          <property name="maxResults">DEFAULT_NAVIGATION_RESULTS</property>
          <pattern>
            SELECT * FROM Document WHERE dc:contributors = ? AND ecm:mixinType !=
            'Folderish' AND ecm:mixinType != 'HiddenInNavigation' AND
            ecm:mixinType != 'SystemDocument' AND
            ecm:isCheckedInVersion = 0 AND ecm:isProxy = 0 AND
            ecm:currentLifeCycleState != 'deleted' AND ecm:path STARTSWITH ?
          </pattern>
          <sort ascending="true" column="dc:modified"/>
          <pageSize>5</pageSize>
        </coreQueryPageProvider>
    
        <coreQueryPageProvider name="user_sections">
          <property name="maxResults">DEFAULT_NAVIGATION_RESULTS</property>
          <pattern>
            SELECT * FROM Document WHERE ecm:primaryType = 'Section' AND
            ecm:mixinType != 'HiddenInNavigation' AND ecm:path STARTSWITH ?
          </pattern>
          <sort ascending="true" column="dc:modified"/>
          <pageSize>5</pageSize>
        </coreQueryPageProvider>
    
        <coreQueryPageProvider name="user_sites">
          <property name="maxResults">DEFAULT_NAVIGATION_RESULTS</property>
          <pattern>
            SELECT * FROM Document WHERE ecm:mixinType = 'WebView' AND
            ecm:currentLifeCycleState != 'deleted' AND webc:isWebContainer = 1 AND
            ecm:path STARTSWITH ?
          </pattern>
          <sort ascending="true" column="webc:name"/>
          <pageSize>5</pageSize>
        </coreQueryPageProvider>
    
        <coreQueryPageProvider name="user_workspaces">
          <property name="maxResults">DEFAULT_NAVIGATION_RESULTS</property>
          <pattern>
            SELECT * FROM Workspace WHERE ecm:mixinType != 'HiddenInNavigation' AND
            ecm:currentLifeCycleState != 'deleted' AND ecm:isProxy = 0 AND ecm:path
            STARTSWITH ?
          </pattern>
          <sort ascending="true" column="dc:title"/>
          <pageSize>5</pageSize>
        </coreQueryPageProvider>
    
        <coreQueryPageProvider name="user_deleted_documents">
          <property name="maxResults">DEFAULT_NAVIGATION_RESULTS</property>
          <pattern>
            SELECT * FROM Document WHERE dc:contributors = ? AND ecm:mixinType !=
            'Folderish' AND ecm:mixinType != 'HiddenInNavigation' AND
            ecm:mixinType != 'SystemDocument' AND
            ecm:isCheckedInVersion = 0 AND ecm:isProxy = 0 AND
            ecm:currentLifeCycleState = 'deleted'
          </pattern>
          <sort ascending="true" column="dc:modified"/>
          <pageSize>5</pageSize>
        </coreQueryPageProvider>
    
        <coreQueryPageProvider name="user_favorites">
          <property name="maxResults">DEFAULT_NAVIGATION_RESULTS</property>
          <pattern>
            SELECT * FROM Document where ecm:mixinType != 'HiddenInNavigation' AND
            ecm:isCheckedInVersion = 0 AND ecm:currentLifeCycleState !=
            'deleted' AND collectionMember:collectionIds/* = ?
          </pattern>
          <sort ascending="true" column="dc:title"/>
          <pageSize>5</pageSize>
        </coreQueryPageProvider>
    
        <coreQueryPageProvider name="user_shared_documents">
          <property name="maxResults">DEFAULT_NAVIGATION_RESULTS</property>
          <pattern>
            SELECT * FROM Document where ecm:mixinType != 'HiddenInNavigation' AND
            ecm:isCheckedInVersion = 0 AND ecm:currentLifeCycleState !=
            'deleted' AND ecm:acl/*1/grant = 1 AND
            ecm:acl/*1/permission IN ('Read', 'ReadWrite', 'ReadRemove', 'Everything') AND
            ecm:acl/*1/principal IN ?
          </pattern>
          <sort ascending="true" column="dc:title"/>
          <pageSize>5</pageSize>
        </coreQueryPageProvider>
    
      </extension>
  • nuxeo-search-ui-7.10-HF03.jar /OSGI-INF/search-pageproviders-contrib.xml
    <extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">
    
        <coreQueryPageProvider name="SAVED_SEARCHES">
          <property name="maxResults">DEFAULT_NAVIGATION_RESULTS</property>
          <pattern>
            SELECT * FROM Document WHERE ecm:mixinType = 'SavedSearch'
            AND cvd:contentViewName IS NOT NULL
            AND dc:creator = ? AND ecm:isProxy = 0
            AND ecm:isCheckedInVersion = 0
            AND ecm:currentLifeCycleState != 'deleted'
            AND SORTED_COLUMN IS NOT NULL
          </pattern>
          <sort ascending="true" column="dc:title"/>
        </coreQueryPageProvider>
    
        <coreQueryPageProvider name="SHARED_SAVED_SEARCHES">
          <property name="maxResults">DEFAULT_NAVIGATION_RESULTS</property>
          <pattern>
            SELECT * FROM Document WHERE ecm:mixinType = 'SavedSearch'
            AND cvd:contentViewName IS NOT NULL
            AND dc:creator != ? AND ecm:isProxy = 0
            AND ecm:isCheckedInVersion = 0
            AND ecm:currentLifeCycleState != 'deleted'
            AND SORTED_COLUMN IS NOT NULL
          </pattern>
          <sort ascending="true" column="dc:title"/>
        </coreQueryPageProvider>
    
      </extension>
  • nuxeo-routing-core-7.10-HF07.jar /OSGI-INF/pageproviders-contrib.xml
    <extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">
    
        <coreQueryPageProvider name="DOC_ROUTING_SEARCH_ALL_ROUTE_MODELS">
          <pattern>
            SELECT * FROM DocumentRoute WHERE ecm:currentLifeCycleState = 'validated'
          </pattern>
          <sort ascending="true" column="dc:title"/>
          <pageSize>20</pageSize>
        </coreQueryPageProvider>
    
        <coreQueryPageProvider name="DOC_ROUTING_SEARCH_ROUTE_MODELS_WITH_TITLE">
          <pattern>
            SELECT * FROM DocumentRoute WHERE ecm:currentLifeCycleState = 'validated' AND dc:title LIKE ?
          </pattern>
          <sort ascending="true" column="dc:title"/>
          <pageSize>20</pageSize>
        </coreQueryPageProvider>
    
        <coreQueryPageProvider name="DOC_ROUTING_SEARCH_ALL_ROUTE_INSTANCES">
          <pattern>
            SELECT * FROM DocumentRoute WHERE ecm:currentLifeCycleState =
            'running' AND dc:title LIKE ?
          </pattern>
          <sort ascending="true" column="dc:title"/>
          <pageSize>20</pageSize>
        </coreQueryPageProvider>
    
        <coreQueryPageProvider name="CURRENT_DOC_ROUTING_SEARCH_ATTACHED_DOC">
          <pattern>
            SELECT * FROM Document WHERE ecm:mixinType != 'Folderish' AND
            ecm:currentLifeCycleState != 'deleted' AND dc:title ILIKE ?
          </pattern>
          <sort ascending="true" column="dc:title"/>
          <pageSize>20</pageSize>
        </coreQueryPageProvider>
    
        <coreQueryPageProvider name="SEARCH_ROUTE_BY_ATTACHED_DOC">
          <pattern>
            SELECT * FROM DocumentRoute WHERE (ecm:currentLifeCycleState = 'running'
            OR ecm:currentLifeCycleState = 'ready') AND docri:participatingDocuments/*
            IN (?)
          </pattern>
          <sort ascending="true" column="dc:title"/>
          <pageSize>20</pageSize>
        </coreQueryPageProvider>
    
      </extension>
  • nuxeo-platform-suggestbox-core-7.10-HF01.jar /OSGI-INF/suggestbox-pageproviders-contrib.xml
    <extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">
    
          <coreQueryPageProvider name="DEFAULT_DOCUMENT_SUGGESTION">
            <property name="maxResults">PAGE_SIZE</property>
            <pattern escapeParameters="true" quoteParameters="false">
              SELECT * FROM Document WHERE ecm:fulltext.dc:title LIKE '?' AND ecm:mixinType !=
              'HiddenInNavigation' AND ecm:isCheckedInVersion = 0 AND
              ecm:currentLifeCycleState != 'deleted' AND ecm:parentId IS NOT NULL
            </pattern>
            <pageSize>10</pageSize>
          </coreQueryPageProvider>
    
      </extension>
  • nuxeo-platform-task-core-7.10-HF05.jar /OSGI-INF/task-pageprovider-contrib.xml
    <extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">
    
        <coreQueryPageProvider name="GET_TASKS_FOR_ACTORS">
          <pattern>
            SELECT * FROM Document WHERE ecm:mixinType = 'Task' AND
            ecm:currentLifeCycleState
            NOT IN ('ended', 'cancelled') AND ecm:isProxy =
            0 AND nt:actors/* IN ?
          </pattern>
          <pageSize>0</pageSize>
          <maxPageSize>0</maxPageSize>
        </coreQueryPageProvider>
    
        <coreQueryPageProvider name="GET_TASKS_FOR_TARGET_DOCUMENT">
          <pattern>
            SELECT * FROM Document WHERE ecm:mixinType = 'Task' AND
            ecm:currentLifeCycleState
            NOT IN ('ended', 'cancelled') AND ecm:isProxy =
            0 AND nt:targetDocumentId = ?
          </pattern>
          <pageSize>0</pageSize>
          <maxPageSize>0</maxPageSize>
        </coreQueryPageProvider>
    
        <coreQueryPageProvider name="GET_TASKS_FOR_TARGET_DOCUMENT_AND_ACTORS">
          <pattern>
            SELECT * FROM Document WHERE ecm:mixinType = 'Task' AND
            ecm:currentLifeCycleState
            NOT IN ('ended', 'cancelled') AND ecm:isProxy =
            0 AND nt:targetDocumentId = ? AND nt:actors/* IN ?
          </pattern>
          <pageSize>0</pageSize>
          <maxPageSize>0</maxPageSize>
        </coreQueryPageProvider>
    
        <coreQueryPageProvider name="GET_TASKS_FOR_TARGET_DOCUMENTS">
          <pattern>
            SELECT * FROM Document WHERE ecm:mixinType = 'Task' AND
            ecm:currentLifeCycleState
            NOT IN ('ended', 'cancelled') AND ecm:isProxy =
            0 AND (nt:targetDocumentId = ? OR nt:targetDocumentsIds/* IN (?))
          </pattern>
          <pageSize>0</pageSize>
          <maxPageSize>0</maxPageSize>
        </coreQueryPageProvider>
    
        <coreQueryPageProvider name="GET_TASKS_FOR_TARGET_DOCUMENTS_AND_ACTORS">
          <pattern>
            SELECT * FROM Document WHERE ecm:mixinType = 'Task' AND
            ecm:currentLifeCycleState
            NOT IN ('ended', 'cancelled') AND ecm:isProxy =
            0 AND (nt:targetDocumentId = ? OR nt:targetDocumentsIds/* IN (?)) AND
            nt:actors/* IN ?
          </pattern>
          <pageSize>0</pageSize>
          <maxPageSize>0</maxPageSize>
        </coreQueryPageProvider>
    
        <coreQueryPageProvider name="GET_TASKS_FOR_PROCESS">
          <pattern>
            SELECT * FROM Document WHERE ecm:mixinType = 'Task' AND
            ecm:currentLifeCycleState
            NOT IN ('ended', 'cancelled') AND ecm:isProxy =
            0 AND nt:processId = ?
          </pattern>
          <pageSize>0</pageSize>
          <maxPageSize>0</maxPageSize>
        </coreQueryPageProvider>
    
        <coreQueryPageProvider name="GET_TASKS_FOR_PROCESS_AND_ACTORS">
          <pattern>
            SELECT * FROM Document WHERE ecm:mixinType = 'Task' AND
            ecm:currentLifeCycleState
            NOT IN ('ended', 'cancelled') AND ecm:isProxy =
            0 AND nt:processId = ? AND nt:actors/* IN ?
          </pattern>
          <pageSize>0</pageSize>
          <maxPageSize>0</maxPageSize>
        </coreQueryPageProvider>
    
        <coreQueryPageProvider name="GET_TASKS_FOR_PROCESS_AND_NODE">
          <pattern>
            SELECT * FROM Document WHERE ecm:mixinType = 'Task' AND
            ecm:currentLifeCycleState
            NOT IN ('ended', 'cancelled') AND ecm:isProxy =
            0 AND nt:processId = ? AND nt:task_variables/*/key = 'nodeId' AND
            nt:task_variables/*/value = ?
          </pattern>
          <pageSize>0</pageSize>
          <maxPageSize>0</maxPageSize>
        </coreQueryPageProvider>
    
        <coreQueryPageProvider name="GET_TASKS_FOR_TARGET_DOCUMENTS_AND_ACTORS_OR_DELEGATED_ACTORS">
          <pattern>
            SELECT * FROM Document WHERE ecm:mixinType = 'Task' AND
            ecm:currentLifeCycleState
            NOT IN ('ended', 'cancelled') AND ecm:isProxy =
            0 AND (nt:targetDocumentId = ? OR nt:targetDocumentsIds/* IN (?)) AND
            (nt:actors/* IN ? OR nt:delegatedActors/* IN ?)
          </pattern>
          <pageSize>0</pageSize>
          <maxPageSize>0</maxPageSize>
        </coreQueryPageProvider>
    
        <coreQueryPageProvider name="GET_TASKS_FOR_ACTORS_OR_DELEGATED_ACTORS">
          <pattern>
            SELECT * FROM Document WHERE ecm:mixinType = 'Task' AND
            ecm:currentLifeCycleState
            NOT IN ('ended', 'cancelled') AND ecm:isProxy =
            0 AND (nt:actors/* IN ? OR nt:delegatedActors/* IN ?)
          </pattern>
          <pageSize>0</pageSize>
          <maxPageSize>0</maxPageSize>
        </coreQueryPageProvider>
    
      </extension>
  • nuxeo-platform-publisher-core-7.10.jar /OSGI-INF/publisher-pageprovider-contrib.xml
    <extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">
        <coreQueryPageProvider name="domains_for_publishing">
          <pattern>
            SELECT * FROM Document WHERE ecm:primaryType = 'Domain'
            AND ecm:parentId = ? AND ecm:currentLifeCycleState != 'deleted'
          </pattern>
          <sort ascending="true" column="dc:title"/>
          <pageSize>50</pageSize>
        </coreQueryPageProvider>
      </extension>
  • nuxeo-platform-audit-core-7.10-HF01.jar /OSGI-INF/pageprovider-contrib.xml
    <extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">
    
        <genericPageProvider class="org.nuxeo.ecm.platform.audit.api.AuditPageProvider" name="DOCUMENT_HISTORY_PROVIDER_OLD">
          <whereClause docType="BasicAuditSearch">
            <fixedPart>
              log.docUUID = ?
            </fixedPart>
            <predicate operator="BETWEEN" parameter="log.eventDate">
              <field name="startDate" schema="basicauditsearch"/>
              <field name="endDate" schema="basicauditsearch"/>
            </predicate>
            <predicate operator="IN" parameter="log.category">
              <field name="eventCategories" schema="basicauditsearch"/>
            </predicate>
            <predicate operator="=" parameter="log.eventId">
              <field name="eventId" schema="basicauditsearch"/>
            </predicate>
          </whereClause>
          <sort ascending="true" column="log.eventDate"/>
          <pageSize>10</pageSize>
        </genericPageProvider>
    
        <genericPageProvider class="org.nuxeo.ecm.platform.audit.api.document.DocumentHistoryPageProvider" name="DOCUMENT_HISTORY_PROVIDER">
          <whereClause docType="BasicAuditSearch">
            <predicate operator="BETWEEN" parameter="log.eventDate">
              <field name="startDate" schema="basicauditsearch"/>
              <field name="endDate" schema="basicauditsearch"/>
            </predicate>
            <predicate operator="=" parameter="log.category">
              <field name="eventCategory" schema="basicauditsearch"/>
            </predicate>
            <predicate operator="IN" parameter="log.category">
              <field name="eventCategories" schema="basicauditsearch"/>
            </predicate>
            <predicate operator="=" parameter="log.eventId">
              <field name="eventId" schema="basicauditsearch"/>
            </predicate>
            <predicate operator="IN" parameter="log.eventId">
              <field name="eventIds" schema="basicauditsearch"/>
            </predicate>
            <predicate operator="=" parameter="log.principalName">
              <field name="principalName" schema="basicauditsearch"/>
            </predicate>
            <predicate operator="IN" parameter="log.principalName">
              <field name="principalNames" schema="basicauditsearch"/>
            </predicate>
          </whereClause>
          <sort ascending="false" column="log.eventDate"/>
          <sort ascending="false" column="log.id"/>
          <pageSize>10</pageSize>
          <maxPageSize>1000</maxPageSize>
        </genericPageProvider>
    
      </extension>
  • nuxeo-platform-usermanager-api-7.10-HF07.jar /OSGI-INF/pageproviders-contrib.xml
    <extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">
    
        <genericPageProvider class="org.nuxeo.ecm.platform.usermanager.providers.UsersPageProvider" name="users_listing">
          <pageSize>20</pageSize>
        </genericPageProvider>
    
        <genericPageProvider class="org.nuxeo.ecm.platform.usermanager.providers.NuxeoPrincipalsPageProvider" name="nuxeo_principals_listing">
          <pageSize>20</pageSize>
        </genericPageProvider>
    
        <genericPageProvider class="org.nuxeo.ecm.platform.usermanager.providers.GroupsPageProvider" name="groups_listing">
          <pageSize>20</pageSize>
        </genericPageProvider>
    
        <genericPageProvider class="org.nuxeo.ecm.platform.usermanager.providers.NuxeoGroupsPageProvider" name="nuxeo_groups_listing">
          <pageSize>20</pageSize>
        </genericPageProvider>
    
      </extension>
  • nuxeo-platform-comment-workflow-7.10.jar /OSGI-INF/comment-pageprovider-contrib.xml
    <extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">
    
        <coreQueryPageProvider name="GET_COMMENT_MODERATION_TASKS">
          <pattern>
            SELECT * FROM Document WHERE ecm:mixinType = 'Task' AND
            ecm:currentLifeCycleState
            NOT IN ('ended', 'cancelled') AND ecm:isProxy =
            0 AND nt:targetDocumentId = ? AND nt:actors/* IN (?) AND
            nt:task_variables/*/key = 'commentId' AND nt:task_variables/*/value = ?
          </pattern>
          <pageSize>0</pageSize>
          <maxPageSize>0</maxPageSize>
        </coreQueryPageProvider>
    
      </extension>
  • nuxeo-platform-login-shibboleth-7.10.jar /OSGI-INF/shibboleth-contentview-contrib.xml
    <extension point="providers" target="org.nuxeo.ecm.platform.query.api.PageProviderService">
    
        <genericPageProvider class="org.nuxeo.ecm.platform.shibboleth.ShibbolethGroupsPageProvider" name="shibb_groups_listing">
          <pageSize>20</pageSize>
        </genericPageProvider>
    
      </extension>