How to query with 3 Conditions? CAML QUERY

Question

I have the first query:

  queryMuaj.Query = "<OrderBy>" +
                          "<FieldRef Name ='testb' Ascending = 'TRUE'/>" +
                    "</OrderBy>" +
                    "<Where>" +
                    "<And>" +
                          "<Geq>" +
                           "<FieldRef Name='testb' />" +
                              "<Value Type='DateTime' IncludeTimeValue='FALSE'>" + startDateFx + "</Value>" +
                          "</Geq>" +
                          "<Leq>" +
                              "<FieldRef Name='testb' />" +
                              "<Value Type='DateTime' IncludeTimeValue='FALSE'>" + endDatFx + "</Value>" +
                          "</Leq> " +
                    "</And>" +
                    "</Where>";

And I have the second qyery:

    query.Query = @"<Where><Eq>
                     <FieldRef Name='Team' />
                     <Value Type='Text'>" + selvalcomp+ @"</Value>
                  </Eq></Where>"

And I want to merge the 2 queries into a single query how can I do this? HELP ME PLEASE

Thanks.

Answer 1

queryMuaj.Query = "<OrderBy>" +
                          "<FieldRef Name ='testb' Ascending = 'TRUE'/>" +
                    "</OrderBy>" +
                    "<Where>" +
                    "<And>"+    
                       "<And>" +
                            "<Geq>" +
                            "<FieldRef Name='testb' />" +
                               "<Value Type='DateTime' IncludeTimeValue='FALSE'>" + startDateFx + "</Value>" +
                            "</Geq>" +
                            "<Leq>" +
                               "<FieldRef Name='testb' />" +
                                "<Value Type='DateTime' IncludeTimeValue='FALSE'>" + endDatFx + "</Value>" +
                            "</Leq> " +
                      "</And>" +
                      "<Eq>"+
                         "<FieldRef Name='Team' />"+
                         "<Value Type='Text'>" + selvalcomp+ "</Value>" +
                     "</Eq>"+
                   "</And>"+    
                   "</Where>";

Check my answer on how to write nested query

Answer 2

Try this query:

<OrderBy> <FieldRef Name ='testb' Ascending = 'TRUE'/> </OrderBy>
    <Where>
    <And>
    <Eq><FieldRef Name='Team' /><Value Type='Text'>" + selvalcomp+ "</Value></Eq>
    <And>
    <Geq><FieldRef Name='testb' /><Value Type='DateTime' IncludeTimeValue='FALSE'>" + startDateFx + "</Value></Geq>
    <Leq><FieldRef Name='testb' /><Value Type='DateTime' IncludeTimeValue='FALSE'>" + endDatFx + "</Value></Leq></And>
    </And>
    </Where>

Get some reference from this link about nest conditions in CAML query.