English 中文(简体)
JCRQ 多种价值的财产搜索
原标题:JCR SQL2 Multivalue properties search

I want to do a search in the content repository using one or more of the values as an input parameter for a multivalue property Something like: find all nodes with the primary type nt:unstructured whose property multiprop (multivalue property) contains both values "one" and "two".

问询会如何解决Manager的问题。 创造 Qu?

Thank you.

最佳回答

你们可以像其他标准一样对待多价值财产的标准。 例如,下面的询问将发现对一些不动产具有白狗价值的所有节点:

SELECT * FROM [nt:unstructured] WHERE someProp =  white dog 

如果某些财产具有多重价值,那么在结果中将列入一个价值至少一的节点,即放弃标准。

找到具有多价值财产多重价值的节点,简单地和综合多种标准。 例如,以下询问将归还所有具有两种特定价值的节点:

SELECT * FROM [nt:unstructured] WHERE someProp =  white dog  
                                  AND someProp =  black dog 

任何经营者都将工作,包括:

SELECT * FROM [nt:unstructured] WHERE someProp LIKE  %white%   
                                  AND someProp LIKE  %black% 

Other combinations are possible, of course.

问题回答

暂无回答




相关问题
U2 UniVerse: update a multivalue field

I have a DICT that is set as a multivalue. When opening TCL, and doing an UPDATE DICT.FILE SET Blah = Y statement, I get the following error: Correlatives are illegal for UPDATE, column "Blah" How ...

Solr Mulivalued Problem

Consider The following is the json response i m getting from the solr if i use multivalued = true for the fields. { "id":["1","2","3"], "TS":["2010-06-28 00:00:00.0","2010-06-28 00:00:...

Multi valued profile property mapping to AD in Sharepoint

I m trying to map my skills and responsibilities profile sections to one of the custom properties in Active Directory (extensionattribute1 , 2, etc). I m entering comma seperated values in AD and it s ...

热门标签