CmisQueryPageField

Some content management systems limit the number of items that are returned in response to a query. This means that if you set the parameter CmisQuery to retrieve information, the connector might not obtain all of the documents that are available.

To ensure that all of the items are ingested by running multiple queries, set this parameter to the name of a field that the connector can use to iterate over the items. The field must be returned in response to queries and must be sortable.

NOTE: If you set this parameter, the value of the CmisQuery parameter:

  • Must not contain an ORDER BY clause.
  • Can only contain a WHERE clause if you add the placeholder %AUTN_QUERY_PAGE_WHERE%. For example:

    SELECT * FROM cmis:document WHERE (<<existing where clause>>) %AUTN_QUERY_PAGE_WHERE%

    The connector replaces %AUTN_QUERY_PAGE_WHERE% with:

    AND (CmisQueryPageField > max CmisQueryPageField from last query)

If you need to set this parameter, OpenText recommends that you use the value cmis:creationDate.

This parameter is only used when you set the parameter CmisQuery, otherwise it is ignored.

Type: String
Default:  
Required: No
Configuration Section: TaskName or FetchTasks
Example:
CmisQuery=SELECT * FROM cmis:document
CmisQueryPageField=cmis:creationDate

Alternatively, if the CmisQuery parameter contains an existing WHERE clause:

CmisQuery=SELECT * FROM cmis:document WHERE (<<existing where clause>>) %AUTN_QUERY_PAGE_WHERE%
CmisQueryPageField=cmis:creationDate

See Also: CmisQuery