Platform Explorer / Nuxeo Platform LTS 2017 9.10

Contribution org.nuxeo.ecm.collections.pageprovider--providers

In component org.nuxeo.ecm.collections.pageprovider
This contribution is part of XML component org.nuxeo.ecm.collections.pageprovider inside nuxeo-platform-collections-core-9.10.jar /OSGI-INF/collection-pageprovider-contrib.xml

Extension Point

Extension point providers of component PageProviderService.

Contributed Items

  • <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="user_collections">
      <pattern escapeParameters="true" quoteParameters="true">
        SELECT * FROM Document WHERE dc:title ILIKE :searchTerm AND ecm:mixinType = 'Collection' AND
        ecm:primaryType != 'Favorites' AND
        ecm:isProxy = 0 AND ecm:mixinType != 'HiddenInNavigation' AND
        ecm:isCheckedInVersion = 0 AND ecm:currentLifeCycleState != 'deleted'
      </pattern>
      <parameter>#{currentUser.name}</parameter>
      <sort ascending="false" column="dc:modified"/>
      <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:mixinType != 'SystemDocument' AND ecm:mixinType !=
        'NotCollectionMember' AND ecm:mixinType != 'HiddenInNavigation' AND
        ecm:currentLifeCycleState != 'deleted'
      </pattern>
      <sort ascending="true" column="dc:title"/>
      <pageSize>50</pageSize>
    </coreQueryPageProvider>
  • <coreQueryPageProvider name="default_content_collection">
      <pattern>
        SELECT * FROM Document where ecm:mixinType != 'HiddenInNavigation' AND
        ecm:currentLifeCycleState !=
        'deleted' AND collectionMember:collectionIds/* = ?
      </pattern>
      <sort ascending="true" column="dc:title"/>
      <pageSize>50</pageSize>
    </coreQueryPageProvider>
  • <coreQueryPageProvider name="ordered_content_collection">
      <pattern>
        SELECT collection:documentIds/* FROM Document where ecm:mixinType != 'HiddenInNavigation' AND
        ecm:isCheckedInVersion = 0 AND ecm:currentLifeCycleState !=
        'deleted' AND ecm:uuid = ?
      </pattern>
      <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>

XML Source

<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="user_collections">
      <pattern escapeParameters="true" quoteParameters="true">
        SELECT * FROM Document WHERE dc:title ILIKE :searchTerm AND ecm:mixinType = 'Collection' AND
        ecm:primaryType != 'Favorites' AND
        ecm:isProxy = 0 AND ecm:mixinType != 'HiddenInNavigation' AND
        ecm:isCheckedInVersion = 0 AND ecm:currentLifeCycleState != 'deleted'
      </pattern>
      <parameter>#{currentUser.name}</parameter>
      <sort ascending="false" column="dc:modified"/>
      <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:mixinType != 'SystemDocument' AND ecm:mixinType !=
        'NotCollectionMember' AND ecm:mixinType != 'HiddenInNavigation' AND
        ecm:currentLifeCycleState != 'deleted'
      </pattern>
      <sort ascending="true" column="dc:title"/>
      <pageSize>50</pageSize>
    </coreQueryPageProvider>

    <coreQueryPageProvider name="default_content_collection">
      <pattern>
        SELECT * FROM Document where ecm:mixinType != 'HiddenInNavigation' AND
        ecm:currentLifeCycleState !=
        'deleted' AND collectionMember:collectionIds/* = ?
      </pattern>
      <sort ascending="true" column="dc:title"/>
      <pageSize>50</pageSize>
    </coreQueryPageProvider>

    <coreQueryPageProvider name="ordered_content_collection">
      <pattern>
        SELECT collection:documentIds/* FROM Document where ecm:mixinType != 'HiddenInNavigation' AND
        ecm:isCheckedInVersion = 0 AND ecm:currentLifeCycleState !=
        'deleted' AND ecm:uuid = ?
      </pattern>
      <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>