Questions tagged [caml-query]

An XML-based language that is used to build and customize Web sites based on SharePoint Team Services from Microsoft.

Filter by
Sorted by
Tagged with
1
vote
1answer
369 views

Filter or CAML query - which is most effective

When using the REST API which approach is the most effective to retrieve items from a list? Is it the filter method or the CAML query? Both works prefectly fine, but I would suspect the query method ...
1
vote
1answer
321 views

Set Scope to recursive on list view

I'm trying to view only items without folders, here is my code to create listview Items = function () { return { "Title": "Items", "DefaultView": "false", "Hidden": "false"...
1
vote
1answer
803 views

CAML - Get Items Under ALL existing Folders

I have about 10 Document folders in my list 'ZooLibrary' and I would like Query to display all the PowerPoint files title from the folders in the list, sorted by ID. Currently, my View Scope='...
1
vote
1answer
388 views

Caml query for multiple status

I want to create a CAML Query like this (status= waiting for approval && Requestor Manager = UserID)or(status= stage2 && Approver= UserID) Please let me know what i am wrong here &...
1
vote
0answers
43 views

Update SP list with data from external DB

The requirements include quick edit, so BCS and OOTB external list are not an option here. The solution I'm looking for has to make these steps: foreach record in a datatable: if the record exists ...
1
vote
2answers
55 views

Display filtered list by category

The current script creates a table showing all Items from the list. e.g. In my list there is a column named 'Category' with 'Cats' and 'Dogs'. What I want to achieve is to FILTER and ONLY display '...
0
votes
1answer
450 views

SharePoint Query Content Class for Pages?

I am trying to build a query to filter only returning a specific section of new pages using Content Class. I am wondering what is the content class for pages? I know for List Item, I could do {...
1
vote
1answer
837 views

Load and use a specifed List View in JavaScript

I have a list view set up via the webinterface of Sharepoint. Now I want to use this view (the CAML XML) to be loaded into javscript to provide list items for a Content Editor Webpart. The view works ...
0
votes
2answers
522 views

Query list having more than 5K items in it

I need to fetch items from a list which has around 20000 items in it. Using caml query i can only fetch 5000 items. What approach should i follow using a server side code.
1
vote
1answer
493 views

Get count of duplicates column value in sharepoint list

Is there a way to find out the count of duplicates column values in sharepoint list using caml query? if yes how ?
2
votes
3answers
108 views

How can i add CAML query to my page?

Sorry for this basic question.I want to read list items. I will use CAML query . But i dont want to use Visual Studio and C#. Is there any way to do this?
0
votes
1answer
201 views

not able to get CAML query to work as desired

I am trying to get items that have travelDate lesser than 30 days before today. and then orderby traveldate But the below query doesn't seem to work <OrderBy> <FieldRef Name='...
0
votes
1answer
203 views

CamlQuery that traverses multiple folders

I've got a CamlQuery that traverses the /public/ folder and returns all files that match a certain criteria and it works gorgeously. Now I need it to do the same for a separate library but have the ...
0
votes
1answer
345 views

SPServices CAML Query Not Working

I have the following CAML filter: CAMLQuery: "<Query><Where><Contains><FieldRef Name='Title'/><Value Type='Text'>WD</Value></Contains></Where></...
0
votes
1answer
192 views

Caml query in visual studio always returns all items in list. U2U Caml query builder returns correct results

I'm using the following query : camlQuery.set_viewXml = "<View><Query><Where><Eq><FieldRef Name='Employee'/><Value Type='User'>" + currentUser.get_title() +...
0
votes
1answer
762 views

CAML Query with contains not working

I have a Multiple Lookupfield on my List (list of document sets) When I do this query it works and shows me the results on the screenshot: <Query> <Where> <Eq> ...
0
votes
1answer
538 views

How to know what are the FileRef field names when build a CAML query?

I am new to SharePoint and for this project I need to add new filter to the CAML query, but I have no idea what field names are available. Is there anyway I can know what FiledRef name I should use ...
1
vote
1answer
145 views

CAML query range does not bring correct number of results

I have a CAML Query that brings 53 results. When I add the range below I get 13 results instead of 10. <Range> <StartAt>41</StartAt> <Count>10</Count> </Range&...
0
votes
2answers
56 views

Is there something wrong with my caml query for List view?

I want to get all the list items that have status "Waiting Approval" and current user is either Manager1 or Manager2. <Query> <OrderBy> </OrderBy> <Where> ...
0
votes
2answers
784 views

sharepoint CAML query in Ascending order

we have webpart that fetch the data from the sharepoint list camlQuery.set_viewXml("<View></View>); now i am trying to do sort the display by enddate (ascending order) camlQuery....
2
votes
0answers
44 views

Unable to see All columns of list in result which is generated by Caml Query

here I am passing caml query to REST Api to get some result on sharepoint online 2016, the same query works fine on sharepoint 2013. my caml query is as below var viewXml = ""; viewXml = { ...
0
votes
1answer
175 views

CamlQuery not returning any items

I'm trying to build a CamlQuery that returns all documents in my /public/ folder but I keep getting the same error. Am I formatting the query incorrectly? {"One or more field types are not installed ...
2
votes
2answers
291 views

Trying to use caml query to get match with lookup field

I want to match the current user with a lookup field in a specific list. It seems something is wrong with my caml query. var clientContext = new SP.ClientContext.get_current(); var web = ...
2
votes
2answers
765 views

Using CamlQuery in SharePoint 2010

I'm trying to write a CamlQuery that goes through all of the documents in the library and returns a list of docs that contain certain metadata tags. I have a working version which recursively does ...
1
vote
1answer
307 views

Display SharePoint 2013 List RowCount in HTML after Query

I am new to CAML queries and javascript but I would like to display a result from a SharePoint list query in HTML. My list has approximately 300 total rows and I would like to get a row count when ...
2
votes
2answers
3k views

CAML Query on SharePoint Online View

I have a very large library in a SharePoint Online environment: > 3000 (document sets) in the root folder and more than 7000 (document sets, folders and documents) in total. The system is mainly based ...
0
votes
0answers
683 views

Optimal way to query over 5000 items in a SharePoint Document library - C# CSOM

I am currently using the below code to query over 5000 items in a SharePoint Online Library. CamlQuery camlQuery = new CamlQuery(); camlQuery.ViewXml = "<View Scope='RecursiveAll'&...
0
votes
1answer
606 views

Can i reach the lookup column's data with CAML query?

I want to reach list's datas. There is look up column. I am using CAML query. But when i create query with CAML, i am seeing look up column like Microsoft.SharePoint.Client.FieldLookupValue[].I want ...
1
vote
1answer
263 views

CAML query not working on another list

So Ive been sitting for half a day already trying to solve that. I have been able to successfully run the following query to find a value of another column on a small test-list: $(document).ready(...
0
votes
1answer
99 views

CAML Query at a time how many OR Conditions we can use?

I was retrieving data from sharepoint list. When my query was less that time no issues to display the data. But more than 300 or conditions invloved in that query exception is coming "value does not ...
1
vote
1answer
779 views

CAML Query Where dates are around or between two fields

I'm having some difficulty thinking this through. I have columns in Sharepoint: Date_Start and Date_End I want to query these fields based on a date range. So for instance, the user supplies two ...
1
vote
1answer
249 views

List threshold - When will the CAML query fail? [closed]

From the blog it seems that If my CAML - internally fired by Nintex's query list action - has a filter on a list which has more than threshold items it's prone to failure. Question: Will it fail if ...
4
votes
3answers
573 views

I am filtering a SharePoint list based on two criteria: “Assigned To” and “status”.What is the CAML Query for it?

The list should be filtered like this SQL given below: select * from SPLIST where status="complete" AND Assigned To="Samrat Sarkar" I have this CAML query but it doesnt work: "<View> <...
0
votes
0answers
396 views

Modify CAML query to overcome threshold limit error

Below is my CAML query using JS. How can I modify my query in order to avoid the threshold limit error? I have more than 5000 items in the list and I need to retrieve all of them to be exported into ...
0
votes
1answer
447 views

CAML to Return rows Where Created is Between 2 dates

The below query returns the entirety of the List, instead of those which fall inside the correct date range. I have tried querying with and without a time added to the date. CamlQuery ...
3
votes
2answers
154 views

Caml Query Issue

I'm fighting with the Caml Query which returns zero items: <View> <Query> <Where> <And> <Eq> <FieldRef ...
2
votes
0answers
113 views

Caml query on contents of a file

I have a document library which contains metadata and a file (The file is .msg). I was wondering if it is possible to create a Caml-Query to query on the contents of the .msg? (Something as below?) &...
1
vote
2answers
824 views

Use OData parameter $filter and $orderby operators in an rest API call

I am using API call to fetch news items from a custom list, and filter by its date and then orderby news item's title. However orderby clause never works, if I put $orderby before $filter, then ...
2
votes
1answer
389 views

How to Access the “ows_owshiddenversion” property of sharepoint calendar list in c#?

here I am trying to Access the ows_owshiddenversion i.e Hidden property of sharepoint calendar list as like below code. CamlQuery camlQuery = new CamlQuery(); camlQuery.ViewXml = "&...
0
votes
1answer
34 views

Using AND in query causes the query to return everything

I am attempting to return all records by a certain User by Today, Yesterday and Last Week. In each case, the query returns all records instead of the correct data. I use Today OffsetDays='-1' and ...
0
votes
2answers
990 views

How to get Items from whole site collection using Content type?

I create multiple Lists using Content type in different sites.I want to get all Items from this Content type using Client context object(Caml Query) in C#.
2
votes
1answer
774 views

How can I expand lookup fields while using the /getitems end point?

I have a query that filters a Workflow Tasks list to return only items where the task is assigned to either the current user or a group the current user is in: <Or> <Membership Type="...
0
votes
1answer
72 views

Is it possible to get 13+ lookup field values in an All Items query via CSOM?

I know I could split the queries into 2 or 3 and combine them if I only specify 4-5 lookup fields I want to retrieve each time.. But is it possible to get all of the lookup IDs with CSOM in one CAML ...
2
votes
0answers
177 views

Does Microsoft Graph support CAML queries for SharePoint Online lists?

Can you query lists in SharePoint Online via Microsoft Graph using CAML queries? Beta/Preview functionality would be ok for me to use. If not: any alternative apporoaches to use similar sophisticated ...
0
votes
2answers
140 views

CAML Query not working on weeks that have split months

So, I have been using this query in my SharePoint app for Months and its has always worked perfectly fine. But i just realized that if the week I'm trying to get has a split month like July 31st to ...
0
votes
0answers
459 views

CAML: Render 'Multiple lines of text' as seperate lines

I have a CAML query that grabs among other things a field with Multiple Lines of Text data type (used to hold an address) but when I put it out to HTML it is displayed as a single line. Is there any ...
5
votes
1answer
16k views

Filter CAML Query by List Item ID

I have the below code which grabs all items from a List with the following structure: I want to limit the query results by a specific value of 'ID' (so when the code gets to the enumerator part, I ...
2
votes
1answer
205 views

Sharepoint 2013 Joins CSOM C# or OOTB

I am using Two list. Is this possible left join using caml query? or Two list available joins available in sharepoint 2013 with out programmatically?? Is this possible in sharepoint Rest api? Lis1 ...
0
votes
2answers
5k views

Sharepoint Online: Powershell recursive CAML query possible?

I was wondering if it's possible to write am CAML query in SPO Online that also let's me search elements within folders in a list, so basically a recursive one. In combination with PnP Powershell I'm ...
2
votes
3answers
2k views

CAML Query Condition use to REST API in SharePoint

How to use and understood CAML query condition and how to apply the condition to SharePoint's REST API? Please see my CAML query condition and my REST API code also. CAML query condition: "<View&...

1 2 3
4
5
19