CAML Query to Return all rows

Question

I am having Sql Query like

// sTitle is my input string
 string sTitle='something';
 Select Title From EmployeeList WHERE Title like '%sTitle%' or 0=sTitle OrderBy Title Desc;

How do i Build it in CAML Query? In CAML Query we can match with the fieldNames but i need to compare with integer or some constant with my InputString

And one more thing How do i achieve the Descending concept in CAML query

Answer 1

Here is a sample CAML Query:

<Query>
   <Where>
      <Contains>
         <FieldRef Name='Title' />
         <Value Type='Text'>1234</Value>
      </Contains>
   </Where>
   <OrderBy>
      <FieldRef Name='Title' Ascending='False' />
   </OrderBy>
</Query>

In CAML Like may be done using Conatins. Moreover, OrderBy is used for sorting. I would suggest you to use CAML Query builder. It will help you understand the concepts of CAML.

Answer 2

One way to generate the CAML query is to start with a SharePoint list view.

If you can use the view dialog to define the filter and the sort, then you can grab the corresponding CAML with SharePoint Designer.

In this case, you may want to create a view on the EmployeeList. Filter by Title with "contains" and the desired string.

Use the Sort section to sort descending by the desire value.

Once the view shows the correct results, open the page with SharePoint Designer, select the web part and in code view look for the Query tag near the top of the web part definition. That's your CAML query.

You can also pass filter parameters into the query with either a filter web part or a URL parameter. If you need details for that, pipe up.