CAML查询SharePoint 2013

Question

您好，我正在尝试为下面的语句编写caml查询查询，

(City="A“|| FirstName="A”|| LastName="A“) && (color=”红色“|| color=”绿色“||color=”蓝色“||color=”紫色“)

这是我编写的CAMl查询，但它不起作用

<Query><Where><And><Or><Contains><FieldRef Name='City' /><Value Type='Text'>A</Value></Contains><Or><Contains><FieldRef Name='FirstName' /><Value Type='Text'>A</Value></Contains><Contains><FieldRef Name='LastName' /><Value Type='Text'>A</Value></Contains></Or></Or></And><And><Or><Contains><FieldRef Name='Color' /><Value Type='Text'>Red</Value></Contains><Or>

GreenBlueViolet

Answer 1

我认为您添加了一个不完整的CAML查询，您需要的确切查询是：

<Query><Where><And><Or><Contains><FieldRef Name='City' /><Value Type='Text'>A</Value></Contains><Or><Contains><FieldRef Name='FirstName' /><Value Type='Text'>A</Value></Contains><Contains><FieldRef Name='LastName' /><Value Type='Text'>A</Value></Contains></Or></Or><Or><Contains><FieldRef Name='Color' /><Value Type='Text'>red</Value></Contains><Or><Contains><FieldRef Name='Color' /><Value Type='Text'>green</Value></Contains><Or><Contains><FieldRef Name='Color' /><Value Type='Text'>blue</Value></Contains><Contains><FieldRef Name='Color' /><Value Type='Text'>violet</Value></Contains></Or></Or></Or></And></Where></Query>

试试这个，然后让我知道。

Answer 2

请尝试使用以下查询，它可能会对您有所帮助。

​

<Query>
<Where>
    <And>
        <Or>
            <eq><FieldRef Name='City' /><Value Type='Text'>A</Value></eq>
            <OR>
                <eq><FieldRef Name='FirstName' /><Value Type='Text'>A</Value></eq>
                <OR>
                    <eq><FieldRef Name='LastName' /><Value Type='Text'>A</Value></eq>
                </OR>
            </OR>
        </Or>

        <Or>
            <In>
                <FieldRef Name="color" />
                <Values>
                    <Value Type='Text'>red</Value>
                    <Value Type='Text'>green</Value>
                    <Value Type='Text'>blue</Value>
                </Values>
            </In>
        </Or>
    </And>
</Where>
</Query>

​