New answers tagged caml
You had an extra <And> and </And>. Just remember that you only need a set of those around every 2 fields (or groups) you are comparing. Ex. <Where> <And> <And> <Eq> <FieldRef Name="HomeType"><Value Type="Choice">Condo</FieldRef> </Eq> <Eq> ...
Because someone already answered to your question, I'll suggest another solution. If you don't mind to use a thrid party library, you can look at my SharepointPlus library. With it you don't need to write the CAML Query but you use a SQL-like syntax for the WHERE clause. In your case, all the above code will look like this: ...
The below code will help you var context = new SP.ClientContext.get_current(); var list = context.get_web().get_lists().getByTitle("ProjectInformation"); var camlQuery = new SP.CamlQuery(); camlQuery.set_viewXml('<View><Query><Where>--your query goes here -- </Where></Query></View>'); var collListItem = ...
You can not use regex query with CAML. The closest thing you will get to wildcard searching and CAML is using either the BeginsWith or the Contains element. http://msdn.microsoft.com/en-us/library/ms196501.aspx So the only thing you are missing then is an EndsWith. In regards to dates make sure you format your dates as "yyyy-MM-dd-Thh:mm:ssZ" and all ...
You are using <Eq> with End_x0020_Time column, instead you should be using <Geq> or <Leq> as per your need.. Please have a look at: Using Date offset in CAML query
Your solution implies showing an item more than one time. OOTB you can't do that. You can make a filter view and show only the signoffs
Top 50 recent answers are included