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
56 views

creating CAML queries in a 32 bit environment?

I'm currently developing with SharePoint on my 32 bit computer. While I'm able to make simple changes with designer on my PC I'm aware that using visual studio to make changes (CAML queries) without ...
1
vote
1answer
113 views

CAML RenderPattern Get current list Item ID

In a my share point 2007 list i have a custom field. In the custom field i need to get the current Item ID. Later have to pass this to a JavaScript. How to get the current Item ID in RenderPattern ? ...
1
vote
0answers
70 views

Custom Field RenderPattern Customization - SharePoint 2007

I'm creating a custom field in SP 2007. I need to Get the Custom field value and field properties on Item click, in the list item display view. Also i Need to pass these values to a JavaScript. So, ...
1
vote
1answer
41 views

About CAML and its content

Problem: I have understood the foundation of CAML and there are some questions that are still unclear in my mind. What context and when should a SP developer use CAML? Why using CAML to retrieve ...
3
votes
2answers
397 views

CAML query for sharepoint list not working

I have a CAML query where I am getting records between a date range for a sharepoint 2010 list through an asmx web method call. It looks like this ...
0
votes
0answers
100 views

Get Items Lookup Mult timeout

I have a list with many records , and when I'm doing a filter for a column that is Lookup Multiple runs smoothly : Example <Where> <Eq> <FieldRef Name='Column' ...
2
votes
2answers
69 views

Items not showing in folder?

Basically, I have a situation where instead of creating 10 individual document libraries, I've created one and filter each "region" as such by subfolders in the library. Canada Finance > Document ...
0
votes
1answer
84 views

How to get list items same values in each two list items to display in 3rd list using with caml query

How can I write one caml query to get items from two lists joined on empid? will you please anybody give me help with suitable caml query or even otherwise possible code. Note: There is no lookup ...
0
votes
1answer
130 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
52 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
643 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 ...
0
votes
0answers
97 views

SharePoint 2007 data view web part - using datetime from querystring in CAML

I have a SharePoint list, with a Start Date (internal:StartDate) and End Date (internal:_EndDate) that I am displaying with a data form web part. I have a static version of the part working perfect. ...
2
votes
1answer
2k 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> ...
2
votes
1answer
216 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
1k 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
317 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
431 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
297 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
92 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
603 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
195 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
483 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
385 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
353 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
74 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 ...
0
votes
0answers
82 views

Filter SharePoint documents based on a Tag filter using the Client Object Model

I am successfully fetching SharePoint documents using a CAML query via the Client Object Model. I would now like to add list of tags as a filter to this query, so that only documents tagged with ...
1
vote
0answers
329 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
85 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
243 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
42 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
142 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 ...
1
vote
3answers
6k 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
67 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
63 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
732 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
470 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 ...
1
vote
2answers
2k 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
28 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 ...
9
votes
2answers
8k 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
119 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
931 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
41 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 http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spfolder.getproperty.aspx ...
0
votes
1answer
115 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 ...
3
votes
1answer
3k 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> ...
0
votes
1answer
458 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
135 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
2k 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
1k 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
711 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
556 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 ...