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

1
vote
1answer
95 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
299 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
43 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
175 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
9k 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
74 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
68 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
849 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
608 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 ...
2
votes
3answers
7k 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
35 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
11k 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
160 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
1k 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
43 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
135 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
6k 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
658 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
162 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
3k 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
857 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
834 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 ...
1
vote
1answer
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
335 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
1k 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
3k 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
30 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
60 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
167 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
266 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
160 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) ...
2
votes
1answer
198 views

is querying a perticular 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 ...
0
votes
1answer
5k views

CAML Query to get Lookup field value

I've written an autohosted-app to show a few data that are in a list. To get the data in the list, I use this piece of code with a CAML Query. using (var clientContext = ...
1
vote
3answers
2k views

Web service based CAML query breaks 5,000 item limit

I have a CAML query of the form shown below which is called via the Sharepoint web service interface to search the entire Sharepoint site containing 600,000 documents looking for documents: ...
1
vote
1answer
451 views

SharePoint 2007 List as Datasource for SSRS 2005 - Query invalid and formating SharePoint Dates?

I have this XML query that pulls all entries and fields from a SharePoint list. <Query> <SoapAction>http://schemas.microsoft.com/sharepoint/soap/GetListItems</SoapAction> ...
0
votes
2answers
569 views

CAML Query returning null

I'm very new to sharepoint and have the following query on my Shared Documents. It is returning null for all three documents I have. I'm wondering where to check in database to see if values are null ...
2
votes
1answer
245 views

Can we query and fetch data from LIST between different subsites using CAML Query.?

Have LIST created under one site, can the same LIST be used to fetch data from other site using CAML Query.? eg: Consider a LIST "xxx" created under SitePages/AAA/Lists/ Can i access the LIST "xxx" ...
0
votes
1answer
2k views

Search for specific folder in library with CAML

I'm looking for a way to search for folder which name starts of 'Foo' using caml query in list. How can I narrow results to return only folders?
0
votes
1answer
156 views

How are columns in SharePoint connected to CAML with regards to data submission?

I am trying to make an alteration to an infopath form that was created to submit data to sharepoint. I added a dropdown box and want to submit that data to sharepoint. The submission has been ...
2
votes
0answers
910 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
158 views

CAML Query where X =(A && B && C && D)

CAML makes me sad some days. Can someone point me in the right direction for the syntax in regards to a CAML query that would evaluate where X= A&B&C&D. My nesting is all off i'm assuming. ...
2
votes
2answers
1k views

SPQuery works on libraries under the list view threshold, but not over

So I am building a webpart which enumerates all doclibs in the current web, grabbing all checked out files and listing them in a table, allowing a user to apply some required metadata and check in ...
0
votes
1answer
170 views

Appropriate List permissions and read/write using visual webpart

I am learning SharePoint and just learned how to develop Visual Webparts and read data through CAML and write data also. I have a portal where I have one site collection and under that site collection ...
1
vote
1answer
5k views

CAML Query in Powershell Issues

I have a powershell script that I am running that executes a caml query to get some list items. The problem I am having is that whenever I execute this query in CAML Builder I am only getting 3 ...
0
votes
1answer
226 views

Adding the other fields in addtional to lookup field in CAML

I have a custom field definition in VS2010 that contains a lookup field (Title). All is well and I can use the Title ref to add items in the SharePoint list UI. in the instance UI, I can also check ...
3
votes
1answer
4k views

Multiple fields to same list in join (CAML)

Current situation: ============= In my example, I've got 2 custom lists: Accounts Addresses In the "Accounts"-list I've created 2 lookup columns to the "Addresses"-list Address1 Address2 When ...
2
votes
1answer
956 views

Caml Query - skip X first results

Let's assume I have list with 100 items. Is it possible to write CAML query to get 5 items, but skip 10 items from the beggining? Something like LIMIT and OFFSET in SQL?
4
votes
1answer
896 views

Error using javascript to retrieve a SharePoint list's items

I am trying to use this method to query items of a column of a list in my SP site via javascript (the reason I am doing this is to display that info on the page by modifying the html tags in the DOM), ...