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
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
1answer
21 views

Need CAML query LookupMulti column help, Is it possible?

I am trying to create a CAML query for querying list, here is my problem. There is a list Employees and it has a LookupMulti column for Hobbies. I want to get all Employees who have selected Reading ...
1
vote
2answers
1k views

Retrieve List items using CAML Query

I have a list which contains 3 columns -ID, TicketState and EndDate ID TicketState EndDate(DD-MM-YYYY) 1 Open 10/10/2012 2 Closed ...
2
votes
2answers
34 views

CSOM get document by ID

I'm using the following CSOM code to retrieve a document title by id: ClientContext context = new ClientContext("http://sharepoint"); List oList = context.Web.Lists.GetByTitle("Documents"); ...
1
vote
0answers
10 views

FeatureUpgrading - Providing an updated schema.xml file possible? [duplicate]

I've read a lot now about the FeatureUpgrading method. But I'm still asking myself, if I could provide an updated list definition (schema.xml) file in the ElementManifests. There are new views in this ...
-3
votes
0answers
28 views

How to fetch the data from list and display through a visual webpart in SP2013 through CAML Query? [duplicate]

I have a list called Employee details. I need to fetch/retrieve the data from Employee details List (which is custom list Out Of Box) and to display it through a visual web part by using CAML query. ...
0
votes
2answers
126 views

Detect if a document or list item was deleted

I'm working on building a synchronizer for certain kinds of data from some lists to an outside application. Via the SOAP API, I can get updates and new items; by using CAML Queries, we can fetch all ...
0
votes
0answers
14 views

How can you get results from a SharePoint document library (with folder and child items) in a SSRS report?

I have a SSRS report that uses a SharePoint document library as a data source. The issue is that the list has folder and in those folders are child items. The dataset is only returning items from the ...
0
votes
1answer
15 views

Join 3 lists initiating the join from the middle list

I need to join 3 Lists, but i have no access to the on-prem sharepoint to test my idea right now. So I hope anybody can tell me, if it's possible. I have Lists A, B and C. LookupFields are connected ...
2
votes
3answers
2k views

Query for retrieving managed metadata column where the column values are a subset of a list of values

In CAML, if I have a managed metadata column with multiple values, you can determine if one of a list of values is in the column using the following query (where the order of the Values/FieldRef ...
0
votes
2answers
29 views

Nested AND OR inside my Content Query web part's CAML query is not working well

I added a content query web part to my team site collection, then i export it , and i modified the QueryOverride tag as follow:- <OrderBy><FieldRef Name="Created" ...
0
votes
2answers
1k 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 ...
2
votes
1answer
39 views

GroupBy site name inside my CAML query

I wrote the following CAML query to be used inside my Content Query Web part, but i am not sure if i can define to Group the retrieved item by site name :- <property name="QueryOverride" ...
0
votes
0answers
27 views

CAML Query using <In> element breaks after >60 values are placed inside

The following CAML Query works on my list that has over 5,000 items because the Title field is indexed: <View Scope="RecursiveAll"> <ViewFields> <FieldRef Name="Editor" /> ...
2
votes
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' ...
0
votes
1answer
23 views

Executing multiple REST queries without error

I've pulled the following example of a REST Query from the SharePoint 2010 Documentation. It's working well except when I try to run multiple queries at once by renaming the functions: ...
1
vote
1answer
16 views

How can I move ONE document to another library without looping an entire collection?

Currently I'm looping through all the files in a collection, which is every single document in the library. Once I find the unique document name, I move it. I'm trying to getting away from looping ...
4
votes
2answers
968 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 ...
4
votes
2answers
869 views

How do I get list items' attached files with CAML via REST API?

I'm retrieving items from a list. The list contains entries which have attachments. Can I modify my query to include the attachment URLs? What's the most efficient way of doing this? <View> ...
2
votes
1answer
45 views

SP2013 use Rest with CAML query and expand lookup column

I'm trying to query a sharepoint list that contains lookup columns and taxonomyfields. When I use the $expand option I can't expand taxonomyfields, but when I use a camlquery i can't expand lookup ...
2
votes
2answers
63 views

CAML Query Where (x AND y) OR Z

I've been struggling with this all day. I've referenced several SO questions/answers but to no avail. Not quite sure what I'm doing wrong. I also cannot use a CAML Builder, unfortunately, due to some ...
2
votes
4answers
493 views

Display Announcements List in HTML Table on a SharePoint 2010

Consider this as my code for displaying Announcements list in a site page on my SharePoint 2010 site: <html> <head> <script type="text/javascript" ...
7
votes
4answers
224 views

CAML query for Sharepoint Calender Lists

I am using CAML query for SharePoint calender list. I am able fetch proper daily data. but when i choose weekly, monthly and yearly, it doesn't give me reports as expected. it doesn't take date ...
5
votes
1answer
949 views

SP2010: Strange behavior querying on taxonomy field

I need to query a document library to get items associated with some taxonomy terms, or items with specific documentId (site collection scoped feature, not the integer ID of the item), but the whole ...
3
votes
3answers
118 views

Query multiple lists using javascript/CSOM

I'm about to query multiple lists using JavaScript (JSOM, SharePoint 2010). It's working when querying one list in a time, but that's annoying when I'm having lots of lists. Working example: ...
2
votes
0answers
24 views

SP2013 : CAML query for managed metadata columns for multiple items selected ?

How to write a caml query to fetch data from a managed metadata column ? I have written caml query which works fine for data matching to "Business" . How do my query return results if the data is ...
0
votes
1answer
37 views

Getting a unique reference number when users can only see their own items

I have created a SharePoint List (on 365 Enterprise) for logging accidents and incidents in our business. The list is populated using an InfoPath form that presents the user with the relevant fields ...
2
votes
2answers
33 views

Trouble updating rows of data in an External Content Type using Javascript

I've tried a few different ways of doing this, including querying the External Content Type and then updating the current item. However as far as I ever get is an undefined variable error. This is my ...
2
votes
0answers
25 views

Is it possible to perform Inner Join with Lookup Multiple Value Field?

I use CAML Query to perform inner join between two lists. It works when the lookup field is single value. However, when this field is multiple value, it always throws error: the value does not ...
2
votes
2answers
89 views

Updating number column in SharePoint programmatically

This is my code which updates single line of text SPQuery query = new SPQuery(); query.Query = string.Concat("<Where><Eq>", "<FieldRef Name=" + txtColumnName.Text + "/>", ...
2
votes
1answer
20 views

Querying Standard Rendering Elements in CAML

Folks I'm looking to use the "standard rendering element" <PageUrl/> within a CAML query as per below: <Or> <Eq> <FieldRef Name="Webpage" /> <Value ...
0
votes
0answers
22 views

Providing a custom QueryOverride + Group items by <site> is not working together inside my Content Query web part

I am working on a Team site collection inside my SharePoint 2013. And I added a Content Query web part, and I define to Group the items by the Site:- And I got the following result which is ...
0
votes
1answer
38 views

DVWP does not honor CalendarDate in SharePoint:SPDataSource SelectCommand

I've been able to use the below code to get a DVWP to return appointments for the current month, including recurrences. However, no matter what I try, I cannot get it to honor the CurrentDate option ...
1
vote
1answer
58 views

Query a SPList with managed metadata column with CAML including child terms

I have a SharePoint list which has a managed metadata column. This is bound to my term store which look like as following: Cars Mercedes S600 CL65 G BMW 5 6 7 X5 Maybach ... Bentley I ...
1
vote
2answers
86 views

Create a dynamic WHERE clause with LINQ to SharePoint

I have a custom application where the user can select multiple (13) parameters to select data from a SharePoint list. To achieve this, I want to use LINQ to query this data from SharePoint. The ...
0
votes
0answers
41 views

CAML query is returning extra items that are not part of the filters

I am working on a Team site collection inside SharePoint server 2013. now inside the team site collection i have 5 subsites, and i want to return list items from the subsites that have the following ...
1
vote
2answers
59 views

How to programmatically distinguish between simply uploaded documents (not check-out nor check-in) and check-in documents in SharePoint 2010?

I'm using SharePoint 2010 and I want to get the files that are not either checked out nor checked in. Meaning that I want to retrieve all documents that: - were uploaded in the Documents library ...
3
votes
1answer
159 views

How to filter items inside CQWP, based on Content type + People/ Group site column

I am working on a Team Site collection inside SharePoint 2013. and i want to display items that have specific content type + a people or group site column matches the login user. so i did the ...
0
votes
0answers
10 views

Unable to Query Document Library on Lookup Column using CAML

I'm trying retrieve all items from a Document Library where a lookup column equals a certain value. The query returns no items for the given value but the same query with the same value returns items ...
1
vote
1answer
41 views

Caml Query not applying to my list requests

I have a SharePoint Application that needs to data from lists to be inserted into elements. Here is the JavaScript: Collection.List.DropDown = function (listTitle, element) { //listTitle = ...
1
vote
0answers
35 views

Query for SharePoint 2013 REST search

I have to site columns (column1, column2) that are also crawled by the search and available as Crawled properties, so I can use them as filters in REST query as well. I'm now trying to build the REST ...
1
vote
1answer
125 views

How to specify a CAML Query to return items that have any of two site columns?

I want to define a query to return items that satisfy the following :- if any item have a CT & login user = site column so i wrote the following :- <property name="QueryOverride" ...
2
votes
0answers
28 views

Does the total amount of lookups affect performance in a CAML query that has less than 8 lookup columns?

I have a large library with 12 lookup columns, and while I only use 6 of these columns when I retrieve data from this library (in a CAML query), the retrieval process often takes 20-30 seconds. Would ...
0
votes
2answers
76 views

Get all years of date field in document library programmatically

I have a library with lots of documents. Now I need to get all years of the documents for a custom navigation programmatically. Input: Many documents in a library that all have a custom ContentType, ...
5
votes
1answer
110 views

Ignore Null Values in OrderBy Asc While creating CAML Query

I have 3 Columns in my List Id Name SortBy 1 A 1 2 B 3 C 2 4 D 3 and my CAML query is : Query = @"<OrderBy><FieldRef Name='SortOrder' Ascending='False' ...
0
votes
1answer
126 views

CAML query for 'FileRef' does not return relative path

I'm having trouble retrieving the relative path of a file using CAML: ...
0
votes
0answers
31 views

Remove Random Characters

After we upgraded to 2013 SharePoint, random characters are added to lookup fields when I pull using spservices. Ex: AAA is one of many values in a list called Vendors. I have another list called ...
4
votes
1answer
88 views

CSOM combining CAML query with method call (GetWOPIFrameUrl) or two queries on the same instance

I am trying to optimize some code that calls the GetWOPIFrameUrl method for list items that were retrieved using a CAML query. The original code executed the CAML query to get the list of items, then ...
0
votes
1answer
57 views

Group by field UserMulti in view (Request CAML)

I have a view where I have to do a group by a field UserMulti , I did the following: <Query> <GroupBy Collapse="TRUE" GroupLimit="30"> <FieldRef ...
0
votes
0answers
52 views

Multiple Inner Joins CAML query

I'm trying to convert the following SQL statement to a CAML query: SELECT t.Id, t.Name, t.CustomerId FROM Ticket AS t INNER JOIN Customer AS ...