Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Working Version

Issue: I am querying SharePoint using SP CAML Query Helper. Using SPCQH I am able to retrieve one order. The query works.

Once I add the query to my Biztalk solution the query below does not work. It return all records in the list. Is there a critical piece of data that I am missing?

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
        <soap:Body>
            <GetListItems xmlns="http://schemas.microsoft.com/sharepoint/soap/">
                <listName>Orders</listName>
                <viewName />
                <query>
                    <Query xmlns="">
                        <Where>
                            <Or>
                                <Eq>
                                    <FieldRef Name="FAC_OrderNumber" />
                                    <Value Type="Text">12095-1</Value>
                                </Eq>
                                <Eq>
                                    <FieldRef Name="FAC_Related_Order" />
                                    <Value Type="Text">12095-1</Value>
                                </Eq>
                            </Or>
                        </Where>
                    </Query>
                </query>
                <viewFields>
                    <ViewFields xmlns="" />
                </viewFields>
                <rowLimit />
                <queryOptions>
                    <QueryOptions xmlns="">
                        <IncludeMandatoryColumns>FALSE</IncludeMandatoryColumns>
                    </QueryOptions>
                </queryOptions>
                <webID />
            </GetListItems>
        </soap:Body>
    </soap:Envelope>

Version that Does not work

<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">
    <s:Body>
        <ns0:GetListItems xmlns:ns0="http://schemas.microsoft.com/sharepoint/soap/" xmlns:ns1="http://microsoft.com/wsdl/types/">
            <ns0:listName>Orders</ns0:listName>
            <ns0:viewName/>
            <query>
                <Query>
                    <Where>
                        <Or>
                            <Eq>
                                <FieldRef Name="FAC_OrderNumber"/>
                                <Value Type="Text">12095-1</Value>
                            </Eq>
                            <Eq>
                                <FieldRef Name="FAC_Related_Order"/>
                                <Value Type="Text">12095-1</Value>
                            </Eq>
                        </Or>
                    </Where>
                </Query>
            </query>
            <viewFields>
                <ViewFields/>
            </viewFields>
            <ns0:rowLimit/>
            <queryOptions>
                <QueryOptions>
                    <IncludeMandatoryColumns>FALSE</IncludeMandatoryColumns>
                </QueryOptions>
            </queryOptions>
            <ns0:webID/>
        </ns0:GetListItems>
    </s:Body>
</s:Envelope>
share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.