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
566 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
260 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
895 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
23 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
54 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
122 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
245 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
167 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
1k 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
289 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
497 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
224 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
128 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
630 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
142 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
146 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
191 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
781 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
726 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
152 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
286 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
162 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
205 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
434 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
773 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
255 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
462 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
540 views

How tu change a date format in CAML

I have got a wrong format of date to a CAML. I have got (yyyy-mm-dd) and must to be understand by CAML to the format(dd-mm-yyyy), how could I done this. Please help me. I tried by ...
0
votes
1answer
127 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
936 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
961 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
991 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' /> ...
2
votes
2answers
1k views

Error in CAML Query with multiple “AND”

When I run the following query I get an error: <Where> <And> <Eq> <FieldRef Name="IssueLOB" LookupId="TRUE" /> <Value ...
2
votes
1answer
302 views

Add content type from sandboxed solution to list definition (farm solution) does not work

I'm using a sandboxed solution from a 3rd party vendor which contains some site columns and a site content type. I want to add this content type to my document library definition in CAML. But when I ...
0
votes
1answer
621 views

Caml Join Field Type

I'm having trouble using the Join via Caml. In a way, I'm having trouble working with 1 field, that is "new window" that the field type is boolean. My code looks like this: SPQuery oQuery = new ...
0
votes
1answer
111 views

SP2010 and Report Builder

I have an SSRS report integrated with SP 2010, the data in the report is loaded from a SP list. The current issue that I am facing is not being able to read minimum and maximum date time field for the ...