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
22 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 ...
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
0answers
15 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 ...
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" /> ...
0
votes
1answer
24 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 ...
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 ...
3
votes
3answers
121 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
25 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 ...
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" ...
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" ...
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
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
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
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 ...
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
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 ...
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 = ...
3
votes
1answer
160 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 ...
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" ...
1
vote
1answer
59 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
87 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 ...
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 ...
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
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, ...
0
votes
1answer
127 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
89 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 ...
3
votes
0answers
43 views

<In> overrides everything else in SharePoint CAML query

I'm writing a CAML query for SharePoint. The list contains a term set field. I want to get all list items having specific terms, plus items where no term is set. My query contains this: <Or> ...
0
votes
1answer
102 views

Equivalent of Rest $filter in CSOM Caml query

I am trying to convert my rest implementation to CSOM. Rest API for the same : _api/web/sitegroups?$Filter=LoginName%20eq%20'Test_Grp' Unable to find an equivalent for $filter in lambda expressions. ...
0
votes
1answer
121 views

Display an Announcement List inside <div> tag

Here is my code to fetch Announcements List and display it as HTML table: <script type="text/javascript" src="/Test_Library/js/jquery-1.11.3.js"></script> <script ...
-2
votes
1answer
65 views

camlquery to get all link to document in library

As explian in the title i need a camlquery to retrieve all "link to document" inside a library. Are there a way to do this? For know in my camlquery i'm looking in fileleafref field if contains ...
1
vote
0answers
23 views

SPServices new item return expanded user information

I'm creating new discussion in a list using SPServices, like this: $().SPServices({ operation: "UpdateListItems", batchCmd: "New", listName: discListName, updates: "<Batch ...
0
votes
1answer
33 views

CAML Query and statement not working

I've been working on this query for a while now and I can't get it to return any rows. It was working before I added in the content between and added the and statement. ...
1
vote
1answer
239 views

How to call SharePoint Rest Service with CAML and Lookup column [duplicate]

I am trying to query sharepoint list which is having Lookup columns. So to do so I am using below JavaScript function function getDataWithCaml(oDataUrl, caml) { var requestData = { ...
0
votes
1answer
61 views

The collection has not been initialized. It has not been requested or the request has not been executed. It may need to be explicitly requested

I am getting below error on the second request. Strange thing is its not occurring on first request. The collection has not been initialized. It has not been requested or the request has not been ...
0
votes
3answers
104 views

CAML Lookup - get different value from lookup list using query

Say I have two lists: Support Pack ID : 1, SupportPackTemplateLookup:(ID#OtherValue), IsActive : True Support Pack Template: ID : 1, OtherValue: x, SuppType: 10 hr support pack ID : 2, ...
1
vote
0answers
34 views

CAML, how to get Fields which are having Unique condition

I am trying to get the field info of a list and I need to also know whether the field has Enforce unique values: as true. IEnumerable<List> lists = clientContext.LoadQuery( lists.Include(list ...
2
votes
4answers
494 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" ...
0
votes
1answer
197 views

CAML Query is throwing value does not fall within the expected range

I have the following CAML: ViewXml = @"<View> <Query><Where><AND> <Eq><FieldRef Name=""Status""></FieldRef><Value ...