openCMIS: SELECT Query

SELECT query is used to get the information from the repository.

Syntax

SELECT [fields_to_select] FROM table_name WHERE [conditionToFilter];

SELECT : SELECT clause is used to select the records in the table

FROM : It is used to query given query able object type

WHERE : Optional clause to specify the condition to filter the records.

How to run queries in CMIS Workbench?

Open CMIS work bench -> Click on the button ‘Query’, it is used to run the queries.

Once you click on the button, it opens new window like below, where you can run queries.

Get all the documents in the repository

‘SELECT * FROM cmis:document’ query is used to get all the documents from the repository.

Previous                                                 Next                                                 Home