About CAML in Sharepoint?


What is CAML in Sharepoint?
CAML is Collaborative Application Markup Language and is an XML-based query language that is used in SharePoint. CAML is used to querying, build and customize the SharePoint sites.
Writing CAML Query
CAML root element is <Query>. CAML query has 2 parts
1.       Sort  (For sorting use <OrderBy>) 
2.        Filter
 (For filter use <Where>)
 Basic syntax for CAML query
< [Operator]>
              <FieldRef Name=’ [Title]’/><Value Type=’ [Data Type] ‘> [Value] </Value>
</ [Operator]> 

Operators in CAML
 Logical Operators
                And
                Or
Comparison Operators
Eq =Equals
Neq =Not equal
Gt=Greater than
Geq =Greater than or equal
Lt =Lower than
Leq =Lower than or equal too
IsNull = is null
IsNotNull = is not null
BeginsWith=Begins with
Contains=Contains
BeginsWith = begins with
DateRangesOverlap= compare the dates
In= value of a list item
Includes= specified field is a Lookup field that allows multiple values
NotIncludes=
Membership= filter based on the type of membership.
Group operator
    GroupBy= grouping the data
Example
1            Filter
<Where>
    <Eq>
     <FieldRef Name='Country' />
     <Value Type='Lookup'>India</Value>
  </Eq>
</Where>
2           Sort
<OrderBy>
   <FieldRef Name=''Country' Ascending='False' />
</OrderBy>

Comments

Post a Comment

Popular posts from this blog

Display multiple marker point on Google Map with same location or same Longitude,Latitude

 Display multiple marker point on Google Map with same location or same Longitude, Latitude <!DOCTYPE html> <html> <head>     <title>Google Map</title> <!-- For Google Map Style Sheet--> <style type="text/css">     #map_canvas     {         height: 450px;         width: 980px;     }     .infowindow     {         font-size: 12px;         width: 200px !important;         font-family: verdana;     }     @media print     {         #map_canvas         {             height: 950px;         }     } </style> <!-- For Google Map--> <script src="http://maps.google.com/maps/api/js?v=3.7&amp;sensor=false" type="text/javascript"></script> <!--downlaod the oms.min.js javascript file from https://github.com/jawj/OverlappingMarkerSpiderfier --> <script src="JS/oms.min.js" type="text/javascript"></script> <script type="text/java
Read more

Implementing Zoom functionality in asp.net

Zoom functionality in asp.net 1. Write the Below code in the  <head> Tag  <script type="text/javascript">         function BrowserZoomPluse() {            nzoom = parseInt(divTest.style.zoom) + 30 + '%';             divTest.style.zoom = nzoom ;         }         function BrowserZoomMinuse() {             nzoom = parseInt(divTest.style.zoom) - 10 + '%';             divTest.style.zoom = nzoom ;         }         function ResetZoom() {             nzoom = parseInt(divTest.value);             divTest.style.zoom = '100%';         }     </script> 2. Add the below Code inside the <body> tag <div id="divTest" style="zoom: 100%">         <div class="textsize">          <a  href="javascript:void(0);" onclick="BrowserZoomPluse();">                 Zoom + </a>                  <a  href="javascript:void(0);" onclick="BrowserZoom
Read more

Check Session Timeot for Whole Application

1. Create a BasePage.cs in App_Code  and write the following code         protected void Page_Init(object sender, EventArgs e)         {             if (Context.Session != null)             {                 if (Session.IsNewSession)                 {                     HttpCookie newSessionIdCookie = Request.Cookies["ASP.NET_SessionId"];                     if (newSessionIdCookie != null)                     {                         string newSessionIdCookieValue = newSessionIdCookie.Value;                         if (newSessionIdCookieValue != string.Empty)                         {                             //This means Session was timed Out and New Session was started                             Response.Redirect("Home.aspx");                         }                     }                 }             }         } 2. Inherit this basepage on all the aspx pages such as using System; using System.Collections.Generic; using System.Col
Read more