Platform Explorer / CMF 1.8

Extension point model

Documentation

Registry for QueryModelDescriptor instances.

Contribution Descriptors

  • Class: org.nuxeo.ecm.core.search.api.client.querymodel.descriptor.QueryModelDescriptor

Existing Contributions

Contributions are presented in the same order as the registration order on this extension point. This order is displayed before the contribution name, in brackets.

  • nuxeo-platform-webapp-core-5.4.2-HF05.jar
    <extension point="model" target="org.nuxeo.ecm.core.search.api.client.querymodel.QueryModelService">
    
        <queryModel name="CURRENT_DOC_CHILDREN">
          <pattern>
            SELECT * FROM Document WHERE ecm:parentId = ? AND ecm:isCheckedInVersion
            = 0 AND ecm:mixinType != 'HiddenInNavigation' AND
            ecm:currentLifeCycleState != 'deleted'
          </pattern>
          <sortable defaultSortAscending="true" defaultSortColumn="dc:title" value="true"/>
          <max>20</max>
        </queryModel>
    
        <queryModel name="CURRENT_DOC_DELETED_CHILDREN">
          <pattern>
            SELECT * FROM Document WHERE ecm:parentId = ? AND ecm:isCheckedInVersion
            = 0 AND ecm:mixinType != 'HiddenInNavigation' AND
            ecm:currentLifeCycleState = 'deleted'
          </pattern>
          <sortable defaultSortAscending="true" defaultSortColumn="dc:title" value="true"/>
          <max>20</max>
        </queryModel>
    
        <queryModel name="CURRENT_DOC_ORDERED_CHILDREN">
          <pattern>
            SELECT * FROM Document WHERE ecm:parentId = ? AND ecm:isCheckedInVersion
            = 0 AND ecm:mixinType != 'HiddenInNavigation' AND
            ecm:currentLifeCycleState != 'deleted' ORDER BY ecm:pos
          </pattern>
          <sortable value="false"/>
          <max>20</max>
        </queryModel>
    
        <!-- This query model may be 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.
        -->
        <queryModel name="TREE_CHILDREN">
          <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>
          <sortable defaultSortAscending="true" defaultSortColumn="dc:title" value="true"/>
          <max>50</max>
        </queryModel>
    
        <queryModel name="TREE_ORDERED_CHILDREN">
          <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' ORDER BY ecm:pos
          </pattern>
          <sortable value="false"/>
          <max>50</max>
        </queryModel>
    
        <queryModel name="SIMPLE_SEARCH">
          <pattern>
            SELECT * FROM Document WHERE ecm:fulltext LIKE ? AND ecm:mixinType !=
            'HiddenInNavigation' AND ecm:isCheckedInVersion = 0 AND
            ecm:currentLifeCycleState != 'deleted'
          </pattern>
          <max>20</max>
          <sortable value="true"/>
        </queryModel>
    
        <queryModel docType="AdvancedSearch" name="ADVANCED_SEARCH">
          <max>20</max>
          <whereClause>
    
            <predicate operator="FULLTEXT" parameter="ecm:fulltext">
              <field name="fulltext_all" schema="advanced_search"/>
            </predicate>
    
            <predicate operator="=" parameter="ecm:isCheckedInVersion">
              <field name="isCheckedInVersion" schema="advanced_search"/>
            </predicate>
    
            <predicate operator="STARTSWITH" parameter="ecm:path">
              <field name="searchpath" schema="advanced_search"/>
            </predicate>
    
            <predicate operator="FULLTEXT" parameter="dc:title">
              <field name="title" schema="advanced_search"/>
            </predicate>
    
            <predicate operator="FULLTEXT" parameter="dc:description">
              <field name="description" schema="advanced_search"/>
            </predicate>
    
            <predicate operator="LIKE" parameter="dc:rights">
              <field name="rights" schema="advanced_search"/>
            </predicate>
    
            <predicate operator="LIKE" parameter="dc:source">
              <field name="source" schema="advanced_search"/>
            </predicate>
    
            <predicate operator="IN" parameter="dc:coverage">
              <field name="coverage" schema="advanced_search"/>
            </predicate>
    
            <predicate operator="IN" parameter="dc:subjects">
              <field name="subjects" schema="advanced_search"/>
            </predicate>
    
            <predicate operator="BETWEEN" parameter="dc:created">
              <field name="created_min" schema="advanced_search"/>
              <field name="created_max" schema="advanced_search"/>
            </predicate>
    
            <predicate operator="BETWEEN" parameter="dc:modified">
              <field name="modified_min" schema="advanced_search"/>
              <field name="modified_max" schema="advanced_search"/>
            </predicate>
    
            <predicate operator="BETWEEN" parameter="dc:issued">
              <field name="issued_min" schema="advanced_search"/>
              <field name="issued_max" schema="advanced_search"/>
            </predicate>
    
            <predicate operator="BETWEEN" parameter="dc:valid">
              <field name="valid_min" schema="advanced_search"/>
              <field name="valid_max" schema="advanced_search"/>
            </predicate>
    
            <predicate operator="BETWEEN" parameter="dc:expired">
              <field name="expired_min" schema="advanced_search"/>
              <field name="expired_max" schema="advanced_search"/>
            </predicate>
    
            <predicate operator="LIKE" parameter="dc:format">
              <field name="format" schema="advanced_search"/>
            </predicate>
    
            <predicate operator="LIKE" parameter="dc:language">
              <field name="language" schema="advanced_search"/>
            </predicate>
    
            <predicate operator="IN" parameter="ecm:currentLifeCycleState">
              <field name="currentLifeCycleStates" schema="advanced_search"/>
            </predicate>
          </whereClause>
    
          <sortColumn>
            <field name="sortColumn" schema="advanced_search"/>
          </sortColumn>
    
          <sortAscending>
            <field name="sortAscending" schema="advanced_search"/>
          </sortAscending>
    
        </queryModel>
    
      </extension>
  • nuxeo-classification-web-5.4.2-HF05.jar
    <extension point="model" target="org.nuxeo.ecm.core.search.api.client.querymodel.QueryModelService">
    
        <queryModel name="CLASSIFICATION_ROOTS">
          <pattern>
            SELECT * FROM ClassificationRoot WHERE ecm:currentLifeCycleState !=
            'deleted'
          </pattern>
          <sortable defaultSortAscending="true" defaultSortColumn="dc:title" value="true"/>
        </queryModel>
    
      </extension>
  • nuxeo-platform-filemanager-core-5.4.2-HF05.jar
    <extension point="model" target="org.nuxeo.ecm.core.search.api.client.querymodel.QueryModelService">
    
        <queryModel name="DEFAULT_CREATION_CONTAINER_LIST_PROVIDER">
          <pattern>
            SELECT * FROM Document WHERE ecm:primaryType IN ('Workspace', 'Folder') AND ecm:currentLifeCycleState != 'deleted'
          </pattern>
          <sortable defaultSortAscending="true" defaultSortColumn="ecm:path" value="true"/>
        </queryModel>
      </extension>
  • nuxeo-platform-imaging-jsf-5.4.2-HF05.jar
    <extension point="model" target="org.nuxeo.ecm.core.search.api.client.querymodel.QueryModelService">
        <queryModel name="CURRENT_PICTUREBOOK_CHILDREN">
          <pattern>
            SELECT * FROM Document WHERE ecm:parentId = ? AND
            ecm:isCheckedInVersion = 0 AND ecm:mixinType != 'HiddenInNavigation'
          </pattern>
          <sortable defaultSortAscending="true" defaultSortColumn="dc:title" value="true"/>
          <max>20</max>
        </queryModel>
      </extension>
  • nuxeo-case-management-core-1.8.jar
    <extension point="model" target="org.nuxeo.ecm.core.search.api.client.querymodel.QueryModelService">
    
        <!-- Case Management Default Service -->
    
        <queryModel name="GET_MAILBOX_FROM_ID">
          <pattern>
            SELECT * FROM Document WHERE mlbx:mailbox_id=? AND
            ecm:currentLifeCycleState != 'deleted' AND ecm:mixinType = 'Mailbox'
          </pattern>
        </queryModel>
    
        <queryModel name="GET_ALL_MAILBOX">
          <pattern>
            SELECT * FROM Document WHERE ecm:currentLifeCycleState != 'deleted' AND
            ecm:mixinType = 'Mailbox'
          </pattern>
        </queryModel>
    
        <queryModel name="byType">
          <max>10</max>
          <whereClause>
            <predicate operator="STARTSWITH" parameter="cmdoc:type">
              <field name="type" schema="case_item"/>
            </predicate>
            <fixedPart>
              ecm:mixinType != 'HiddenInNavigation' AND ecm:currentLifeCycleState
              !='deleted' AND ecm:mixinType = 'CaseGroupable' AND ecm:mixinType =
              'Distributable'
            </fixedPart>
          </whereClause>
          <sortColumn>
            <field name="sortColumn" schema="advanced_search"/>
          </sortColumn>
          <sortAscending>
            <field name="sortAscending" schema="advanced_search"/>
          </sortAscending>
        </queryModel>
    
        <queryModel name="CURRENT_CASE_ITEM_RELATION_SEARCH">
          <pattern>
            SELECT * FROM Document WHERE ecm:mixinType = 'CaseGroupable' AND
            ecm:mixinType = 'Distributable' AND ecm:currentLifeCycleState !=
            'deleted' AND ecm:uuid != ? AND ecm:fulltext LIKE ?
          </pattern>
          <sortable defaultSortAscending="true" defaultSortColumn="dc:title" value="true"/>
          <max>20</max>
        </queryModel>
    
        <queryModel name="SIMPLE_SEARCH">
          <pattern>
            SELECT * FROM Document WHERE ecm:fulltext LIKE ? AND ecm:mixinType !=
            'HiddenInNavigation' AND ecm:isCheckedInVersion = 0 AND
            ecm:currentLifeCycleState != 'deleted' AND ecm:mixinType =
            'CaseGroupable' AND ecm:mixinType = 'Distributable'
          </pattern>
          <max>10</max>
          <sortable value="true"/>
        </queryModel>
    
        <!-- we override the contribution to start route on case only -->
        <queryModel name="CURRENT_DOC_ROUTING_SEARCH_ATTACHED_DOC">
          <pattern>
            SELECT * FROM Document WHERE ecm:currentLifeCycleState != 'deleted'
            AND dc:title LIKE ? AND ecm:mixinType != 'CaseGroupable' AND
            ecm:mixinType = 'Distributable'
          </pattern>
          <sortable defaultSortAscending="true" defaultSortColumn="dc:title" value="true"/>
          <max>20</max>
        </queryModel>
      </extension>
  • nuxeo-platform-syndication-5.4.2-HF05.jar
    <extension point="model" target="org.nuxeo.ecm.core.search.api.client.querymodel.QueryModelService">
    
        <queryModel name="SIMPLE_SEARCH_PATH">
          <pattern>
            SELECT * FROM Document WHERE ecm:fulltext LIKE ? AND
            ecm:mixinType != 'HiddenInNavigation' AND
            ecm:isCheckedInVersion = 0 AND ecm:path STARTSWITH ?
          </pattern>
          <sortable defaultSortAscending="true" defaultSortColumn="dc:title" value="true"/>
          <max>10</max>
        </queryModel>
    
        <queryModel name="RELEVANT_DOCUMENTS">
          <pattern>
            SELECT * FROM Document
            WHERE ecm:mixinType != 'Folderish'
              AND ecm:mixinType != 'HiddenInNavigation'
              AND ecm:isCheckedInVersion = 0
              AND ecm:isProxy = 0
              AND ecm:currentLifeCycleState != 'deleted'
              AND ecm:uuid IN ?
          </pattern>
          <sortable defaultSortAscending="false" defaultSortColumn="dc:modified" value="true"/>
          <max>5</max>
        </queryModel>
    
      </extension>
  • nuxeo-platform-document-routing-core-5.4.3-I20110729.jar
    <extension point="model" target="org.nuxeo.ecm.core.search.api.client.querymodel.QueryModelService">
    
        <queryModel name="CURRENT_DOC_ROUTING_SEARCH_ATTACHED_DOC">
          <pattern>
            SELECT * FROM Document WHERE ecm:mixinType != 'Folderish' AND
            ecm:currentLifeCycleState != 'deleted' AND dc:title LIKE ?
          </pattern>
          <sortable defaultSortAscending="true" defaultSortColumn="dc:title" value="true"/>
          <max>20</max>
        </queryModel>
    
        <queryModel name="DOC_ROUTING_SEARCH_ALL_ROUTE_MODELS">
          <pattern>
            SELECT * FROM DocumentRoute WHERE ecm:currentLifeCycleState =
            'validated' AND dc:title LIKE ?
          </pattern>
          <sortable defaultSortAscending="true" defaultSortColumn="dc:title" value="true"/>
          <max>20</max>
        </queryModel>
    
        <queryModel name="SEARCH_ROUTE_BY_ATTACHED_DOC">
          <pattern>
            SELECT * FROM DocumentRoute WHERE (ecm:currentLifeCycleState = 'running'
            OR ecm:currentLifeCycleState = 'ready') AND docri:participatingDocuments
            IN (?)
          </pattern>
          <sortable defaultSortAscending="true" defaultSortColumn="dc:title" value="true"/>
          <max>20</max>
        </queryModel>
    
      </extension>