Collaborative Application Markup Language (CAML) is an XML-based language that is used in Microsoft SharePoint Foundation to define the fields and views that are used in sites and lists.

learn more… | top users | synonyms

2
votes
1answer
233 views

Is querying a particular folder faster?

I have a folder in document library. If I get the folder from folder collection of the document library and only query the items inside that folder will it work faster then querying a whole library ...
1
vote
3answers
46 views

CAML retrieve only the latest of each value in a column

(Sorry if the title isn't clear I'm not really sure how to phrase it in one question) Situation: I have a list in sharepoint containing some evaluation of different teams in a company with at least ...
0
votes
1answer
30 views

CAML Query with many conditions

I would like to know, is there a way to build such a CAML Query, or is this nonsense: I have a SharePoint List with two ContentTypes: ServiceGroup and Services. The Fields are Title ServiceGroup ...
0
votes
2answers
980 views

How to change a date format in CAML

I got a wrong date format to a CAML. I have got (yyyy-mm-dd) and must to be understand by CAML to the format(dd-mm-yyyy), how can I do this. I tried by String.Format("{0:yyyy-mm-dd}", dateISO1);, but ...
2
votes
1answer
779 views

SPSiteDataQuery for Documents using caml query

I am tring to query an entire site collection for all the documents where a certain field is equal to something. For example where LoanCategory = Insurance. I am trying to do this using an ...
0
votes
1answer
28 views

Caml Query on calendar to get the next x events (including recurring)

So far I'm able to get the next x events (without recurring events). Code: private SPListItemCollection GetNextEvents(SPList eventCalendar) { DateTime currentDateTime = DateTime.Now; ...
0
votes
1answer
697 views

Retrieve List items using CAML Query

I have a list which contains 3 columns -ID, TicketState and EndDate ID TicketState EndDate(DD-MM-YYYY) 1 Open 10/10/2012 2 Closed ...
0
votes
0answers
27 views

How to use CAML with CSOM for getting users in SP2013?

I want to get all the users in CSOM SP 2013 in javascript, but I don't want all users. I want to filter them by CAML. This is what I have so far which filters by first name is Tom, but the CAML is not ...
3
votes
1answer
1k views

Create Multiple List Items with One Function

Is it possible to create multiple list items with one function in JavaScript / ECMAScript? I know that a single item can be created with the code below, but would like to know if it is possible to ...
1
vote
1answer
998 views

SPServices Autocomplete and dynamic CAML query

I have two Text filter web parts (Project and Customer Name) with Apply Filters button for one list. There is a SPServices.SPAutocomplete on each and it works great. Now, I want to show the values in ...
1
vote
1answer
55 views

CAML query for current date

I want to get all items from the list, which has a start date from date.now or later in time. This is what I thought would work: var dateNow = Date.now(); var camlQuery = new SP.CamlQuery(); ...
1
vote
2answers
947 views

How to use SPServices search sql query - getting malformed query

I am using the SPServices javascript library to make a search request to sharepoint 2010 search. I am trying this query: queryText = "<QueryPacket xmlns='urn:Microsoft.Search.Query' ...
1
vote
1answer
61 views

Joining lists and accessing items fromt the joined list

I am working on a SharePoint Hosted app for SharePoint 2013 and I'm having real difficulty joining lists and accessing items from the joined list. In my app I build a CAML query in which two lists ...
3
votes
1answer
874 views

SP2010: Strange behavior querying on taxonomy field

I need to query a document library to get items associated with some taxonomy terms, or items with specific documentId (site collection scoped feature, not the integer ID of the item), but the whole ...
4
votes
2answers
1k views

IsNull not working in CAML query for indexed fields

So for example I have field 'TestField' which is indexed. How can I caml for items where 'TestField' value is null? My example down here will fail and won't find what I am querying for. <Where> ...
2
votes
1answer
114 views

CAML query filtering is not working

I've googled that it can be in case when query is not well-formed. But I'm verifying it for several hours and didn't find any mistake. Problem is common: query doesn't filters and returns all data. ...
0
votes
1answer
24 views

How to check if managed metadata has a keyword in CAML query?

I want to make a caml query that checks if a managed metadata column (which is a list of phrases) contains a certain phrase. I have this which seems to work, but the problem is it does a substring ...
0
votes
1answer
29 views

build caml query for multiple AND & OR

how to build caml query for following condition. All the fields all from single list. select empid, ename, salary from emp where empid=(100 or 107 or 99 or 103 or 105) and deptno=10 and mgrId=23
0
votes
1answer
19 views

How to filter document libraries using CAML query?

In my powershell script, I get all lists, then loop through and filter based on if its a document library and if its a certain content type, but I want to do this through CAML. This is the loop logic ...
0
votes
1answer
19 views

CAMLQuery with multiple and/or

I want to be able to check if (1 = 1) AND (2=2 OR 3=3) this is the following code i've tried so far: "<View>" + "<Query>" + "<Where>" + "<And>" + "<Eq><FieldRef ...
1
vote
2answers
38 views

Sharepoint CAML Query IN operator

I have a sharepoint list with managed metadata column and I have to find items matching values from columns. If I filter the list for a column, let's say COLUMN1 <In> <FieldRef ...
0
votes
2answers
30 views

How can I get my CAML to only return non-hidden (user created) fields without specifing every field?

I can provide the ViewFields but I was wondering if there is a way to return all the user created fields (non-hidden ones) without having to do that. I know this works: <ViewFields> ...
1
vote
1answer
35 views

How to fetch highest value item from SharePoint list

I created a Custom List in developer Site. In that List I created a column called Totalsumma and added some numeric items like "324", "567" etc. How can I fetch the highest value from that column. ...
-1
votes
1answer
74 views

ItemUpdated Event Receiver how to change element from one list to secound list

I have got two lists. I must do synchronize this list, but one have got only 3 columns, and secound list have got 3 columns too, but have got more columns with hidden value. I done synchronizing ...
0
votes
1answer
34 views

CAML query for the last document uploaded by a particular user

I'm trying to write a query using the JSOM to get the last document uploaded to a document library by the current user. The reason I'm doing this is because I have an upload button on a form and need ...
0
votes
1answer
70 views

paging on list not working

I want to do paging on sharepoint list. I have below code which is giving error. var customlist; var allItems; var context = new SP.ClientContext.get_current(); var web = context.get_web(); var ...
1
vote
2answers
52 views

“float;#22.0000000000000” Number Returned From CAML Query

I'm running a CAML query to retrieve list items. Some of the columns retrieved contain decimal numbers. The problem is the values coming back from the query look like float;#22.0000000000000. I just ...
0
votes
0answers
40 views

OrderBy in CAML query (using Camlex) cause an error

I'm developing a visual web-part for SharePoint 2010. I've to do a query with OrderBy clause. This is my code: if (ViewState["sortExp"] == null) { sortCol = "Column_x0020_A"; } else { ...
1
vote
0answers
52 views

SP2010 - Visual Web Part - Storing metadata in folders in document libraries

I want to store a number to folders to enforce ordering. I noticed these three pages Get Property Set Property Add Property And I want to know if it's possible to use these to add a number to the ...
0
votes
1answer
25 views

“0x80070003” error getting while I custom web part in SP2013

"0x80070003" error getting while I retrieve Only document from the document library In scop="Recursive all" in caml Query and that caml Query data pass in the Webpart...but while I Insert that custom ...
6
votes
3answers
183 views

CAML query for Sharepoint Calender Lists

I am using CAML query for SharePoint calender list. I am able fetch proper daily data. but when i choose weekly, monthly and yearly, it doesn't give me reports as expected. it doesn't take date ...
1
vote
2answers
38 views

CAML query with Beginwith/EQ/Contains/ Retrieving All rows from Lists

I have a caml query to retrieve only specific row which matched to the criteria, but it returns all the items in the LIST, @"<Where><BeginsWith><FieldRef Name='custaname' ...
1
vote
1answer
82 views

Using where clause in caml query

I want to select all items from a list where Title is equal to logInUser (which is current login user name). In my code I have created : var logInUser = context1.get_web().get_currentUser(); But ...
2
votes
1answer
103 views

What are the user data returned from Person or Group column (People Only) query?

I'm using SPServices to query a SharePoint Online (2013) list that contains a Person or Group column. (This column is set to allow selection of People Only, in case that matters.) The query used is ...
10
votes
4answers
15k views

Where can i download the U2U CAML query Builder for Sharepoint 2010?

I have try to download form below links. But the site is not opening. http://www.u2u.be/res/Tools/files/CamlBuilderSetupv4.0.0.0.zip . http://www.u2u.be/res/tools/camlquerybuilder.aspx ...
0
votes
1answer
49 views

Joining lists and create dynamic columns

I have 3 lists A, B and C in the same site and i have to make a View joining them and generate few dynamic columns: Columns of A: Title (Indexed), Util(number) Columns of B: Title, Title_A (Lookup), ...
0
votes
1answer
419 views

Export contents of a sharepoint list to a html table

How can I export the contents of a list to a html table? I know how to extract the elements of a list using CAML Queries, but how do I generate a html table containing the elements dynamically?
0
votes
2answers
56 views

Detect if a document or list item was deleted

I'm working on building a synchronizer for certain kinds of data from some lists to an outside application. Via the SOAP API, I can get updates and new items; by using CAML Queries, we can fetch all ...
0
votes
1answer
91 views

CAML query to get data for SSRS from SharePoint list

I am writing CAML query to get data from sharepoint list <RSSharePointList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> ...
0
votes
0answers
18 views

Left outer join in caml query to get tasks

Here is caml query. It does not retrieve any results. Showing empty pages. What I am trying to do is: "In the last 24 hours what task did not complete" I need to display those tasks in my web ...
0
votes
0answers
49 views

Webpart with parameter binding injected into CAML query?

I'm trying to do a custom webpart that takes in a query string parameter and inject that parameter into a CAML query. Is this legal? <ParameterBinding name="QuerystringBinding" ...
1
vote
1answer
987 views

Sharepoint REST API - Using caml query and select/expand to get lookup data

I have a Sharepoint app and I use a caml query to filter the data I get back: var caml = "<View><Query><Where><And><Contains><FieldRef Name='PublishingPageLayout' ...
0
votes
0answers
93 views

CAML Query - Data Between Two Date Sets

I'm trying to get the data between two date sets, but the CAML query doesn't seem to be working. I'm trying to get anything opened between the two dates or anything closed between the two dates. ...
0
votes
0answers
27 views

OrderBy on a lookupMulti

I need to order a Caml query result's on a lookupmulti. Is that even possible ? Thx in advance.
5
votes
4answers
18k views

Building CAML query with AND and Order by Clause

Hi I am trying to build a query using caml query builder - Below is the query (The query = get the values only whose address = 1234st AND LastName = Doe) - I believe the placement of AND operator is ...
0
votes
1answer
85 views

Add filter and pagination to CAML query

I'm developing a visual web part for Sharepoint 2010. I would display all documents from a specific DL, but this DL contains more than 7000 items. So I would like to add a pagination (show only 20 ...
0
votes
0answers
23 views

SharePoint CAML query vs FQL

I am building an application with very complex CAML queries. Everything is working without any problem. But my question is: Is it possible to create also very complex queries with FQL. And which one ...
0
votes
1answer
149 views

CAML query OrderBy is not working

SPWeb _SPweb = _SPSite.OpenWeb(); SPList _SPlist = _SPweb.Lists[FL.ToString()]; SPQuery _spquery = new SPQuery(); _spquery.Query = "<Query><Where><Eq><FieldRef ...
1
vote
1answer
34 views

CAML - Understanding when to use Eq, Geg and Value

With the following CAML query: camlQuery.set_viewXml('<View><Query><Where><Geq><FieldRef Name=\'ID\'/>' + '<Value ...
0
votes
1answer
97 views

Is it possible to write a CAML query that will update or insert an entry based on its existence?

I'm working with Sharepoint using CSOM and Javascript. I need to cache usage statistics in a List with one entry per user, updating values in a user's list entry when they interact with the site in a ...