2021:CMISQL Query - Revision history

Dgreenwood: Dgreenwood moved page 2021:CMIS Query (Concept) to 2021:CMISQL Query without leaving a redirect

2025-09-09T19:25:56Z

Dgreenwood moved page 2021:CMIS Query (Concept) to 2021:CMISQL Query without leaving a redirect

← Older revision	Revision as of 14:25, 9 September 2025
(No difference)

2025-08-05T16:14:37Z

2024-04-23T19:11:44Z

← Older revision		Revision as of 14:11, 23 April 2024
Line 1:		Line 1:
	{{AutoVersion}}		{{AutoVersion}}
	<blockquote ~~style="font-size~~:~~125%">~~
	~~'''''~~CMIS ~~Queries''''' are utilized to search documents in '''CMIS Repositories''' and to filter documents upon import when using the '''''Import~~ Query ~~Results''''' provider.~~		<blockquote>{{#lst:Glossary\|CMIS Query}}</blockquote>
	</blockquote>

	Also called a "CMISQL query", the querying language '''''CMIS Queries''''' use is based on a subset of the SQL-92 grammar. Where SQL is a querying language to search and select data in a database, "CMISQL" is a querying language to search and select documents (and their metadata properties) in a storage location, represented by a '''CMIS Repository''' in Grooper.		Also called a "CMISQL query", the querying language '''''CMIS Queries''''' use is based on a subset of the SQL-92 grammar. Where SQL is a querying language to search and select data in a database, "CMISQL" is a querying language to search and select documents (and their metadata properties) in a storage location, represented by a '''CMIS Repository''' in Grooper.

2024-04-16T15:16:10Z

Randallkinard moved page 2021:CMIS Query to 2021:CMIS Query (Concept) without leaving a redirect: new naming convention

← Older revision	Revision as of 10:16, 16 April 2024
(No difference)

2023-12-22T17:50:02Z

Dgreenwood moved page CMIS Query - 2021 to 2021:CMIS Query without leaving a redirect

← Older revision	Revision as of 12:50, 22 December 2023
(No difference)

2023-12-22T17:49:31Z

← Older revision		Revision as of 12:49, 22 December 2023
Line 1:		Line 1:
			{{AutoVersion}}
	<blockquote style="font-size:125%">		<blockquote style="font-size:125%">
	'''''CMIS Queries''''' are utilized to search documents in '''CMIS Repositories''' and to filter documents upon import when using the '''''Import Query Results''''' provider.		'''''CMIS Queries''''' are utilized to search documents in '''CMIS Repositories''' and to filter documents upon import when using the '''''Import Query Results''''' provider.
Line 482:		Line 483:
	The '''''SharePoint Binding''''' has a hard limitation when it comes to querying larger repositories, with many thousands of folders and files. There is currently a threshold limit of 5000 rows. This means if a query has to scan more than 5000 items to return an item, SharePoint will return the following error:		The '''''SharePoint Binding''''' has a hard limitation when it comes to querying larger repositories, with many thousands of folders and files. There is currently a threshold limit of 5000 rows. This means if a query has to scan more than 5000 items to return an item, SharePoint will return the following error:
	* "Internal Server Error (500): The attempted operation is prohibited because it exceeds the list view threshold."		* "Internal Server Error (500): The attempted operation is prohibited because it exceeds the list view threshold."


	~~[[Category:Articles]]~~
	~~[[Category:Version 2021]]~~

2023-11-07T16:32:39Z

Randallkinard moved page CMIS Query to CMIS Query - 2021

← Older revision	Revision as of 11:32, 7 November 2023
(No difference)

2023-11-07T15:09:03Z

CMIS Query Editor

← Older revision		Revision as of 10:09, 7 November 2023
Line 139:		Line 139:

	As such, these bindings are '''''not''''' suitable for the '''''Import Query Results''''' provider (You should instead use '''''Import Descendants'''''). Furthermore, you will not have access to the "Search Repository" tab for these bindings when selecting a '''CMIS Repository'''.		As such, these bindings are '''''not''''' suitable for the '''''Import Query Results''''' provider (You should instead use '''''Import Descendants'''''). Furthermore, you will not have access to the "Search Repository" tab for these bindings when selecting a '''CMIS Repository'''.
			<br>
			Again, the exception to this is '''''NTFS'''''. If the folder path IS indexed in Windows and the Windows Search service IS running, then you CAN use the "Search Repository" tab and '''''CMIS Queries'''''.
	\|}		\|}

2023-09-25T14:40:10Z

Unsupported Query Configurations

← Older revision		Revision as of 09:40, 25 September 2023
Line 478:		Line 478:
	* Be aware the <code>IN_TREE</code> search is recursive where <code>IN_FOLDER</code> is not. This means any subfolders will be queried as well as the targeted folder.		* Be aware the <code>IN_TREE</code> search is recursive where <code>IN_FOLDER</code> is not. This means any subfolders will be queried as well as the targeted folder.

	The '''''SharePoint Binding''''' has a hard limitation when it comes to querying larger repositories, with many thousands of ~~documents~~. There is currently a threshold limit of 5000 rows. This means if a query has to scan more than 5000 items to return an item, SharePoint will return the following error:		The '''''SharePoint Binding''''' has a hard limitation when it comes to querying larger repositories, with many thousands of folders and files. There is currently a threshold limit of 5000 rows. This means if a query has to scan more than 5000 items to return an item, SharePoint will return the following error:
	* "Internal Server Error (500): The attempted operation is prohibited because it exceeds the list view threshold."		* "Internal Server Error (500): The attempted operation is prohibited because it exceeds the list view threshold."

2023-09-25T14:39:24Z

← Older revision		Revision as of 09:39, 25 September 2023
Line 470:		Line 470:
	:[[#How to Use the CMIS Query Editor\|Click here to return to the top]]		:[[#How to Use the CMIS Query Editor\|Click here to return to the top]]
	</tabs>		</tabs>

			== Unsupported Query Configurations ==

			The '''''NTFS Binding''''' will not support full text search (the <code>CONTAINS()</code> predicate) unless the Windows file system has been indexed by the Windows Indexing Service.

			The '''''SharePoint Binding''''' does not support the <code>IN_FOLDER</code> predicate when selecting a folder location to query. You must use the <code>IN_TREE</code> predicate instead.
			* Be aware the <code>IN_TREE</code> search is recursive where <code>IN_FOLDER</code> is not. This means any subfolders will be queried as well as the targeted folder.

			The '''''SharePoint Binding''''' has a hard limitation when it comes to querying larger repositories, with many thousands of documents. There is currently a threshold limit of 5000 rows. This means if a query has to scan more than 5000 items to return an item, SharePoint will return the following error:
			* "Internal Server Error (500): The attempted operation is prohibited because it exceeds the list view threshold."


	[[Category:Articles]]		[[Category:Articles]]
	[[Category:Version 2021]]		[[Category:Version 2021]]