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
2answers
140 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
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
764 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
597 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
1k 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
1k 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
278 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
944 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
2k 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
25 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
55 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
134 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
247 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
142 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
172 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
4k 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
311 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
512 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
229 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
130 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
700 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
147 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
151 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
4k 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
197 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
2answers
3k 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
812 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
761 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), ...
1
vote
1answer
157 views

extend caml token ?

is there an hook or interface or whatever that could be used for extending token functionality of sharepoint? For example [Me] token is insufficient for me and I would like to for example develop my ...
2
votes
2answers
2k views

CAML Query for sub folder documents javascript

I'm trying to query for documents in a specified sub folder of a document library. Using U2U CAML builder, I can generate the query and return successfully within it. However, when I run the query ...
2
votes
0answers
299 views

How to find out whether or not a list is hidden without writing code (SP2010)?

Does anyone know if there is a way of telling (without writing any code) whether or not a list is "hidden"? I have a CAML query which contains the following and I'd like to eliminate the possibility ...
0
votes
2answers
163 views

CAML Query Issue A or B and C

I'm trying to write a CAML query with the following parameters and I'm not having much luck. It should be simple enough but I can't figure it out. WHERE (X) EQUALS (A or B) And C I'm hoping someone ...
1
vote
1answer
207 views

CAML Query results every time 0 items

I try to filter items in the list by using caml. The List contains elements that matches the Filter. The code: enter code here SPQuery qry = new SPQuery(); qry.Query = @" ...
1
vote
1answer
440 views

Build CAML query by value from ClientPeoplePicker

I use these lines of code: <SharePoint:ClientPeoplePicker ID="clpUser" runat="server" UseLocalSuggestionCache="True"/> JS: var peoplePicker = ...
3
votes
1answer
5k views

How to retrieve items from document libraries using client context without performance lag

I need to retrieve items/list items from SharePoint 2010 document library and display it in a list ListView using C#. I have used following CAML query to retrieve list items and its properties. ...
0
votes
1answer
36 views

Longest practical filter for an alert

Environment: SP2010 Enterprise SP1, Server/SQL 2008 R2, VS2012 When building alerts through object model, what is the longest or most complex CAML filter that can be applied to them? Can they be as ...
1
vote
0answers
85 views

How to check value from other sharepoint list?

I have two custom lists in SharePoint 2010 (Absent Request and Employee Leave Balance) with these columns: Absent Request List: Absent Type, Approver, Start Date, End Date, Absent Reason Employee ...
3
votes
1answer
795 views

CAML Query OrderBy ignoring non set values

I'm currently writing some CAML Query for a QueryOverride in one of my Content Query Web Parts as I'm in need of multiple "Sort by" fields. My issue is that one of the additional fields that I need ...
1
vote
3answers
2k views

how to query multiple lists using CAML

I have requestID, date column in 4 different lists. I want to build a webpart which shows user requests of different types therefore i need to query multiple lists with column requestID and date. How ...
1
vote
1answer
265 views

Open in new tab document link item from document library

I have a document link item that points to a URL. This item is inside a document library. Is there a way to make this item open to a new page? I opened the aspx file it creates, but I am unsure how ...
1
vote
3answers
476 views

Using a variable in alert filter (CAML/C#)

Environment: SP2010 Enterprise, VS2012 I've been using C# to programmatically create alerts for various users and implementing the alert.Filter property to assign filters that point to specific ...
0
votes
1answer
597 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 ...
0
votes
1answer
129 views

How to add id CAML grouping?

I write this code, and I try to group by Ascending or Descending. <Query> <Where> <Neq> <FieldRef Name='Nazwisko' /> <Value Type='Note'>" ...
1
vote
2answers
968 views

CAML query not filtering results

Can someone tell me why the following CAML query is not filtering results? It's returning files that do not contain "/Internal/Bug 594" in their FileRef value. Thanks. <View ...
1
vote
2answers
986 views

CrossListQueryInfo\SPSiteDataQuery how to skip items with specific WebId?

Customer wants to see 10 news items from all webs on front page. Also customer wants to specify some news that we should skip. I am trying to do next thing: var id =1; <Neq><FieldRef ...
0
votes
1answer
1k views

How to check DateTime condition in CAML Query?

I want to fetch the records from List which are created in Last 5 minutes. I have written following code, but its not working. giving me error. <Geq><FieldRef Name='CreatedDate' /> ...