Questions tagged [caml]

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.

Filter by
Sorted by
Tagged with
6
votes
3answers
5k 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: ...
5
votes
1answer
16k views

Sharepoint REST API - Using caml query and select/expand to get lookup data

I have a Sharepoint app and I use a caml query to filter the data I get back: var caml = "<View><Query><Where><And><Contains><FieldRef Name='PublishingPageLayout' ...
24
votes
3answers
35k views

CAML query limitation of values in IN operator

I have less than 5000 items in my library. I want to get 530 items by ids. So I am using following query. <Where> <In> <FieldRef Name="ID" /> <Values> <...
2
votes
2answers
12k views

Using CAML Query to Retreive from Multiple Lists

I am creating an applicant tool which contains the following lists: Applicant; Applicant Answers; Job Questionnaire; Job Title The lists are related as follows: Applicant.ID = Applicant Answers....
4
votes
2answers
5k views

Sharepoint CAML Query IN operator

I have a sharepoint list with managed metadata column and I have to find items matching values from columns. If I filter the list for a column, let's say COLUMN1 <In> <FieldRef ...
22
votes
4answers
33k 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 http://www....
12
votes
1answer
50k views

CAML Query, get item by lookup value, not by ID

I have the value of a lookup column, but I don't have the ID, I want to query items from SharePoint list using the lookup value. How do I achieve that in CAML?
12
votes
2answers
35k views

Querying a simple list with a 'User' column, using CAML

I'm having some trouble getting a CAML Query working against a very simple list. My custom list has the fields: Person : User Date : Date Amount : Lookup My query looks like this: <Query> &...
2
votes
2answers
15k views

Export contents of a sharepoint list to a html table

How can I export the contents of a list to a html table? I know how to extract the elements of a list using CAML Queries, but how do I generate a html table containing the elements dynamically?
1
vote
2answers
15k views

Retrieve single field using CAML Query in Sharepoint using Javascript

I have a List called ProjectInformation and contains following Fields.. ID ProjectName1 ProjectManager ProjectExecution 1 EDS PPB Time and Material 2 CS ...
6
votes
1answer
157 views

SharePoint 2010 list Item Query

We have a big list in SharePoint 2010. I'm gonna query SharePoint 2010 list item in the web part based on country. I used CAML and JS. I have got errors in different browser" Internet explorer says ...
3
votes
1answer
4k 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 ...
6
votes
2answers
250 views

Selecting only PowerPoint files in a CAML query

I am trying to select all PowerPoint files in a list. How do I do that? Up until now I used this: class UsedIn { private static NetworkCredential credential = new NetworkCredential("login", "pwd", "...
4
votes
1answer
6k views

Create Multiple List Items with One Function

Is it possible to create multiple list items with one function in JavaScript / ECMAScript? I know that a single item can be created with the code below, but would like to know if it is possible to ...
4
votes
2answers
2k 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 ...
2
votes
1answer
10k views

SP Online - Get items from list(CAML) with JSOM

I want to get list item with caml query for SharePoint Hosted Add'in. Query will returned one item.. This is my code: function getUserData() { var employeeList = clientContext.get_site()....
2
votes
3answers
5k 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
3answers
329 views

SharePoint - CAML query where check TextBox for existing “User Name”

I need to make query in SharePoint WebPart with VisualStudio. I have list "Employees" and need to check this list for existing UserName! <tr> <td class="auto-style1">...
1
vote
2answers
657 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.
1
vote
2answers
12k 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 ...
12
votes
2answers
23k views

CAML query to filter items by Content Type, independent of column name

In a SharePoint list I have a column, created using a custom content type. Let's say, the content types is "MyContentType". I used in a column "My Custom Column". Need to filter out items if the "My ...
6
votes
1answer
652 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' /&...
5
votes
2answers
13k 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 Type="Lookup">1</...
4
votes
3answers
3k views

CAML query for sharepoint list not working

I have a CAML query where I am getting records between a date range for a sharepoint 2010 list through an asmx web method call. It looks like this <Query><Where><And><Geq><...
3
votes
1answer
982 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 ...
3
votes
3answers
3k 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"); ...
2
votes
2answers
6k views

CAML query for filtering list view

I have a SharePoint list that I need to filter according to this: First of all, the items must be Booked by = Travel and Meeting Support and the Category should never be visible if they are Cancelled....
2
votes
2answers
440 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
2k views

How do I fetch the data from list present in root web of the root site collection?

We need to populate some data on an application page. The application page is present in the layouts folder and hence is accessible via the respective site URL. There are multiple site collections. ...
2
votes
1answer
5k views

Client Object Model & CAML -> Getting Items of a specific view

I need some support as I am struggling to understand what is wrong with my code. I try to retrieve the data of a specific view. The line camlQuery.ViewXml = view.ViewQuery; throws an exception The ...
2
votes
1answer
355 views

Is querying a particular 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 ...
2
votes
2answers
2k views

CAML query to retrieve the second set of three list items from the announcements list?

The CAML query to pull say 3 items based off of the following requirements seems pretty starightforward: Title is not null Expires(Expiry Date) is greater than or equal to Today Order Created in ...
2
votes
1answer
3k views

Sharepoint 2013 .NET CSOM CamlQuery Join

I am unable to create a working query with join in my .net csom application. I was using this article: http://msdn.microsoft.com/en-us/library/ff798388.aspx here is my code: ClientContext context =...
1
vote
3answers
2k views

“float;#22.0000000000000” Number Returned From CAML Query

I'm running a CAML query to retrieve list items. Some of the columns retrieved contain decimal numbers. The problem is the values coming back from the query look like float;#22.0000000000000. I just ...
1
vote
0answers
277 views

CSOM (HighTrust) SP2013 Group by aggregate giving duplicates

Hi I've been reading about group by in SharePoint 2013 CSOM from this article here. https://piyushksingh.com/2016/11/21/retrieve-grouped-listitems-sharepoint I've recently upgraded to 2013 and though ...
1
vote
1answer
11k views

Get all files under subfolder in Shared Documents list - SP Object Model

I am trying to get all files in a subfolder, in the Document Library "Shared Documents" in SP 2010. So the structure looks like http://sp2010site/sitename/shared documents/folder1/ http://sp2010site/...
1
vote
3answers
7k 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
2answers
2k 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
713 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 type="text/javascript"...
0
votes
1answer
211 views

CAML is ordering by content type even though not specified

I have a library in SharePoint 2010. The library has folders, each item in the library, including the folder, are tagged with a number (separate column). When I do an 'OrderBy' the column, the ...
0
votes
2answers
671 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 Scope='Recursive'...
0
votes
1answer
3k views

Expanding ListViewByQuery Web Part stuck on “Working on it…”

I am using a ListViewByQuery in a custom web-part. If I set the CAML GroupBy to <GroupBy Collapse='FALSE'> (i.e. expanded), the webpart works fine. However, if I set it to <GroupBy Collapse='...