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

0
votes
1answer
194 views

Why is my CAML query for my list view not valid: filtering a date and membership of created by

The below query works only for each segement alone. Either: <And> <Geq> <FieldRef Name="Von"/> <Value Type="DateTime">{startdatum}</Value> </Geq> <Leq> ...
0
votes
0answers
68 views

Get SPListItem by title is very slow

I want to get a SPListItem by title. I´m using a caml query to filter the list (Around 1000 items). There is only 1 item with the title in the list. My problem is now that the performance is really ...
0
votes
2answers
2k views

CAML query order by not working in SPList

I am using the following code display items in list but it is not sorting them. No matter what I write in order by clause, it always brings the same results. SPListItemCollection items = null; using ...
5
votes
2answers
9k views

CAML query limitation of values in IN operator

I have less than 5000 items in my library. I want to get 530 items by ids. So I am using following query. <Where> <In> <FieldRef Name="ID" /> <Values> ...
3
votes
1answer
452 views

Expand recurring events for the next 2 years

How can I get an expanded list of recurring events for the next 2 years? I am currently using this CAML expression: <DateRangesOverlap> <FieldRef Name="EventDate" /> <FieldRef ...
0
votes
3answers
2k views

How to get list of documents checked out by me in view?

I have created a document library definition in which I want to insert a view that shows all documents which are checked out by me. The declarative code is: <View BaseViewID="140" Type="HTML" ...
1
vote
1answer
763 views

CAML Query - Does <IN> count as one or multiple lookups?

In a CAML Query I filter for multiple lookup fields by combining multiple <Or> statements. This caused a log entry like this: Some lookup fields were omitted from the query result because the ...
1
vote
1answer
604 views

Get values from one list where a value is present in another list

I have 2 lists with a parent child relationship. List A ID Title ---------------- 1 First 2 Second 3 Third List B ID Title List A Lookup ---------------------------- 1 ...
1
vote
2answers
576 views

CAML In clause - Value does not fall within the expected range

I get a 'Value does not fall within the expected range' error from the following CAML. <Query> <Where> <In> <FieldRef Name="ID"/> <Values> ...
0
votes
1answer
110 views

Why do my CAML queries always have excess characters like “#”, etc. in the values?

Whenever I do CAML queries for SharePoint list items I find that the return results always have strange characters in the value. For example, if I do a query against the filename (FileLeafRef) I will ...
1
vote
1answer
1k 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
2answers
381 views

How to retrieve the login of the user who checked-out a given file

I am currently developping a C# application which has to retrieve some data from a SharePoint website through a CAML request. I successfully get everything I need except one information : the login ...
1
vote
1answer
1k views

Sharepoint 2013 .NET CSOM CamlQuery Join

I am unable to create a working query with join in my .net csom application. I was using this article: http://msdn.microsoft.com/en-us/library/ff798388.aspx here is my code: ClientContext context ...
0
votes
1answer
746 views

CAML Join for retrieving FieldLeafRef

I'va a custom list which contains a lookup field to a document library. Now I need to retrieve all items from this list with the corresponding file name from the document library with Javascript CSOM. ...
2
votes
2answers
518 views

Nested REST or CAML code to list “NOT-IN” List Join Logic. Possible?

I'm thinking this is possible in SPO 2013? Two Custom Lists. Submitted and Universe (common field employee number) One qualifier condition that applies to both .. dept = Sales I need to list ...
1
vote
1answer
96 views

Generate Guid upon field creation in caml field definition

I'm trying to figure out a way to generate a new Guid upon field creation without using event handling. I.e something like this <?xml version="1.0" encoding="utf-8"?> <Elements ...
2
votes
1answer
813 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 ...
1
vote
1answer
112 views

Caml query returning extra divs

I need my caml query to return only text, e.g. now it's returning me this <div class=ExternalClass104BBsdfEEDCEdddsf48C68C18AsdfB056FBsdfAB805>Real Content.....</div> When I want Real ...
2
votes
1answer
374 views

CAML Query Custom Ordering

I have looked around a bit, but have not found any reference to this particular issue. Is it possible to specify a custom ordering in a CAML query? What I mean by this is, say I have a list with a ...
2
votes
1answer
47 views

CAML - how important is it? [closed]

What is your experience when you go dealing with caml coding? Do you have to do lots of caml coding or is it compulsory to enable to read only?
0
votes
1answer
226 views

CAML query many-to-many relationship

I have a case where a customer can have many contacts and a contact can be assigned to many customers. Currently I have a page for each customer, on load I get all the contacts (a publishing page for ...
2
votes
3answers
15k views

Get field value from item in SPListItemCollection

I am confused with SPQuery. How can I use it to get listitem values. Let's say I have a list "Cinema" with 20 columns but i only want 4. Film ID Film Name Film Type Film Review How can i get all ...
0
votes
1answer
77 views

JavaScript CAML Query- Alter Column Name

Is there any way to control what name a column is returned as when a CAML query is run? I am interested in passing the results of several queries (on related items) to a single function, and as the ...
1
vote
1answer
87 views

Combining 1 item from 2 SharePoint lists

I have SPList A which has the columns: Title, Description, Category. and SPList B which has the following columns: Column1, Column2, Category. I want to make one object for items with the same ...
7
votes
2answers
993 views

Can a CAML query find all documents that were ever modified by a specific user?

I'm trying to list all documents that were (ever) modified by a specific user, using a CAML query like this one: var query = new CamlQuery{ ViewXml = "<View Scope='Recursive'>" + ...
1
vote
2answers
804 views

CAML query to retrive data from 3 lists present in three different site

I have a parent site X, and three child site A, B and C. There is a list by the name "MyList" in all the list sites. I want a CAML Query to retrieve the latest ten records,from "MyList"(now ten ...
5
votes
4answers
20k 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
38 views

How can I make sure that if the startdate column is null in the list view display the item anyway in the schema file

I have a list with 2 different views one that shows all items and one that shows current items. But if startdate is null the item wont show up on current view. startdate should be nullable. How can i ...
11
votes
4answers
16k 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
3answers
220 views

Is there a way to say getitembyid and use caml query to get no fields?

In my visual webpart, I want to get an item by it's id from a document library, and change it's field value. I don't want to actually read any of its field values, so I was wondering is there is a way ...
1
vote
1answer
2k views

SP2010 JSOM: updating with CAML where clause

So I learned and have used the following to update a list item by ID using Javascript Client Object Model: function updateItem(passedID) { var ctx = new SP.ClientContext.get_current(); var myList = ...
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
178 views

SP 2010 Visual Webpart - How to get all documents in a folder and sort them by caml query?

I am making a visual web part for sharepoint 2010. I have a SPFolder object and I want to get all items in it, but I want to sort it by a specific field. I want to do this by CAML query instead of ...
4
votes
1answer
9k views

CAML Query Lookup/Choice Value Type as Text

So, here is some lines of code that i write to retrieve data from Sharepoint list using CAML query. string qryCaml = string.Format(@"<Where> <And> ...
1
vote
2answers
1k 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
2answers
258 views

How to write a caml query that filters by .pdf or folders?

How can I write a CAML query (for javascript ecma) that filters by only pdf documents or folders in sharepoint 2010? (this is for document libraries) Thanks.
3
votes
1answer
4k views

SP2010 JSOM Client Object Model: How to get all documents in libraries including all folders recursively

I have seen a lot of examples and questions about this out there but nothing I have found has helped me accomplish this. I need to be able to grab all the names of the documents within a given ...
3
votes
2answers
2k views

SP 2010 - Client object model (javascript) - How to use get_listItemCollectionPosition for paging?

This is my code: When I call the function to get the items, it fails (doesn't go to the fail function, it goes into the success function but crashes when I try to get the position object), and I get ...
1
vote
2answers
1k views

CAML query on people and group

I have a list with a "People and Groups" type column and multiple selection allowed is checked. Another column call "Region" Say, I have John, doe and barry, williams in the "SalesGuy" column and ...
1
vote
1answer
1k views

How to get only the first x items starting at position y from a list, using CAML query?

In sharepoint 2010 client object model in javascript, I want to create a caml query, that can download items from a list. I have this part working, but I want to download only x items, not the whole ...
4
votes
2answers
2k views

How to get caml query to return list items created by the current user?

I want a caml query that only retrieves items created by the user currently logged in. I tried this specifier = "<Eq><FieldRef Name='AssignedTo'/><Value ...
0
votes
2answers
2k views

How to check checkboxes in caml query?

In SharePoint 2010 client object model (JavaScript), I am using this caml query to download list items. There is a column called 'Office' and in it, there are several check boxes (i.e. its a ...
0
votes
2answers
416 views

CAML Query for Date Range - Not Working

Hey guys I am trying to get a list of items with a "Created" date range. The problem is that upon executing the query it seems to be completely ignoring the 5000 row limit. <View ...
2
votes
2answers
2k views

What does the “Overwrite” attribute in a site column definition actually do

I'am deploying some site columns, content types and lists to my site via CAML definition. This works as expected. However, I faced problems with re-using site columns that reference my lists. My site ...
4
votes
1answer
4k views

Can I sort CAML queries by multiple fields?

I have the following query: <query> \ <Query> \ <Where><Eq><FieldRef Name='FSObjType'/><Value Type='Lookup'>0</Value></Eq></Where>\ ...
0
votes
1answer
33 views

Is there in CAML any equivalent of SQL query Prepare

I'm looking for any equivalent of SQL query Prepare in CAML. Could You help me.I need optymalization in CAML.
0
votes
1answer
65 views

ProcessBatchUpdate has no effect

I have an application I am working on that uses an Event receiver to propagate metadata to a document library. I am trying to use SPWeb.ProcessBatchUpdate to copy the metadata back. my code looks like ...
1
vote
0answers
219 views

Sharepoint Webservice not filtering Data

Working Version Issue: I am querying SharePoint using SP CAML Query Helper. Using SPCQH I am able to retrieve one order. The query works. Once I add the query to my Biztalk solution the query below ...
0
votes
1answer
318 views

SharePoint 2013: Creating Site Columns using CAML

I had a SharePoint solution which is working perfectly in SharePoint 2007 and SharePoint 2010. The solution contained Site Columns that were created using CAML (XML Files). Further I created a ...
0
votes
1answer
215 views

Need help with getting List Item counts

I have a custom list created that tracks project status by stages. I need to present the same in a chart format. Below is the list information. Columns *Project Name *Development(Phase1) ...