如何获取不区分大小写的cmis:文件夹搜索查询 [英] How to get case insensitive cmis:folder search query

问题描述

stmt = session.createQueryStatement("SELECT * FROM cmis:folder WHERE IN_TREE(?)and cmis:name =?")； stmt.setString(1，'sites/test/documentLibrary'); stmt.setString(2，'Test');

stmt = session.createQueryStatement("SELECT * FROM cmis:folder WHERE IN_TREE(?) and cmis:name=?"); stmt.setString(1,'sites/test/documentLibrary'); stmt.setString(2,'Test');

我得到的结果带有正确的文件夹名称(测试)，区分大小写，但是如果我给了文件夹名称test或TEST结果，则找不到.

I got result with exact folder name(Test) case senstive, but If i gave foldername test or TEST result not found.

请帮助我进行大小写敏感的文件夹搜索.

Could you please help me on case insenstive folder search.

推荐答案

CMIS QL不支持不区分大小写的查询，因为许多存储库无法提供它.

The CMIS QL does not support case insensitive queries because many repositories can't provide it.

根据存储库和存储库设置，LIKE查询可能不区分大小写.

Depending on the repository and the repository setup, a LIKE query might be case insensitive.

顺便说一句. IN_TREE带有文件夹ID，而不是文件夹路径.

Btw. IN_TREE takes a folder ID, not a folder path.

这篇关于如何获取不区分大小写的cmis:文件夹搜索查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！