CMIS Connector 24.3

# 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

Copyright 2024 Open Text
Version 24.3 | Last updated June 2024

Send documentation feedback

Close

Send documentation feedback

To send feedback using your default email client, open an email window.

Otherwise, send your feedback and the information below to MFI-swpdl.idoldocsfeedback@opentext.com.

We appreciate your feedback!

Product: IDOL CMIS Connector 24.3

Topic Title: CmisQueryPageField