Last call to make your voice heard! Our 2022 Developer Survey closes in less than a week. Take survey.

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
2 votes
3 answers
164 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?
user avatar
  • 641
0 votes
1 answer
207 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='...
user avatar
0 votes
1 answer
270 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 ...
user avatar
  • 269
0 votes
1 answer
394 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></...
user avatar
  • 1
0 votes
1 answer
231 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() +...
user avatar
  • 367
0 votes
1 answer
1k 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> ...
user avatar
0 votes
1 answer
919 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 ...
user avatar
  • 123
1 vote
1 answer
180 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&...
user avatar
  • 492
0 votes
2 answers
57 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> ...
user avatar
  • 367
0 votes
2 answers
1k 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....
user avatar
  • 367
2 votes
0 answers
48 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 = { ...
user avatar
  • 1,494
0 votes
1 answer
211 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 ...
user avatar
  • 269
2 votes
2 answers
387 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 = ...
user avatar
  • 367
2 votes
2 answers
1k 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 ...
user avatar
  • 269
1 vote
1 answer
398 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 ...
user avatar
2 votes
2 answers
4k 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 ...
user avatar
0 votes
0 answers
850 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'&...
user avatar
0 votes
1 answer
931 views

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

I want to reach the list's data. There is lookup column. I am using CAML query. But when I create a query with CAML, I am seeing look up columns like Microsoft.SharePoint.Client.FieldLookupValue[].I ...
user avatar
  • 641
1 vote
1 answer
392 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(...
user avatar
  • 145
0 votes
1 answer
179 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 ...
user avatar
  • 441
1 vote
1 answer
1k 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 ...
user avatar
1 vote
1 answer
278 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 ...
user avatar
  • 240
4 votes
3 answers
583 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> <...
user avatar
0 votes
0 answers
495 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 ...
user avatar
  • 1,119
0 votes
1 answer
574 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 ...
user avatar
3 votes
2 answers
163 views

Caml Query Issue

I'm fighting with the Caml Query which returns zero items: <View> <Query> <Where> <And> <Eq> <FieldRef ...
user avatar
  • 1,176
2 votes
0 answers
158 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?) &...
user avatar
  • 131
1 vote
2 answers
3k 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 ...
user avatar
  • 127
2 votes
1 answer
522 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 = "&...
user avatar
  • 1,494
0 votes
1 answer
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 ...
user avatar
0 votes
2 answers
1k 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#.
user avatar
2 votes
1 answer
1k 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="...
user avatar
0 votes
1 answer
106 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 ...
user avatar
  • 739
3 votes
0 answers
264 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 ...
user avatar
0 votes
2 answers
168 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 ...
user avatar
0 votes
0 answers
594 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 ...
user avatar
  • 1,298
7 votes
1 answer
23k 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 ...
user avatar
  • 1,298
2 votes
1 answer
230 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 ...
user avatar
0 votes
2 answers
6k 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 ...
user avatar
2 votes
3 answers
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&...
user avatar
1 vote
0 answers
361 views

How to get child WSSID based on parent term ID using CSOM

I have got parent term's WSSID by this method. How do i get its child terms ids like this to build my CAML query for search in a share point list using CSOM private static int GetWssIdByTermId(...
user avatar
  • 21
2 votes
1 answer
792 views

CamlQuery does not seem to return the value from LookupColumn

The below code work for all the Columns except for Publication which is a Lookup. The If publicationField is ALWAYS Null...ideas? // Assume the web has a list named "ADMPANewsAlertsWebAPI". ...
user avatar
0 votes
2 answers
403 views

Caml Query returns all the values from sharepoint online

i am using a caml query to check if a specific value exist in a sharepoint list. but it ends up returnning all the values instead of one. while (reader.Read()) { ...
user avatar
  • 1,453
2 votes
2 answers
688 views

How to get server side datetime using Caml query?

Using caml query I get Calender Events but Time will be changes..How to get server Time zone ..This return time +5.30 hrs. CamlQuery camlQuery = new CamlQuery(); camlQuery.ViewXml = "&...
user avatar
3 votes
2 answers
3k views

Query the year from a date field in CAML Query

I have a SharePoint 2013 list in which I have a date field say Formatted Date, now using CAML Query I need to retrieve only the records which have year 2017 in the Formatted Date.PFB my code: $()....
user avatar
  • 453
1 vote
1 answer
407 views

CAML query not retrieving items based on Start date and end date for EST Time zone?

I have one custom list name Test, Using the Following query SPList PollList = web.Lists["Test"]; SPQuery PollQuery = new SPQuery(); var CurrentDate = DateTime.Today; PollQuery.Query = "<OrderBy&...
user avatar
  • 1,712
2 votes
1 answer
209 views

Apply search in SharePoint Custom List

I want to apply Search functionality only on Custom List in SharePoint using Rest API or CAML query. I already tried that rest api example: $.getJSON("https://SharePointURL/_api/search/query? ...
user avatar
2 votes
0 answers
66 views

How to use GroupBy in QueryOverride for Content Query Web Part in SharePoint 2016?

I read a lot of forums, questions and answers and it looks like using GroupBy in QueryOverride is not taking in consideration. Here are the several ways I tried without success. Option 1 <...
user avatar
2 votes
0 answers
29 views

Query list item from top level site

Correction of my previous question:Link I have big list in my sub-site. I want to query a list item from a top level site. I can able to query from a sub-site , but my requirement is users want to ...
user avatar
  • 897
0 votes
1 answer
28 views

Report on file names over 200 char long

Will be going through a migration shortly and I need to identify any file/pages that have a title/page name over 200 charcters long. I don't have access to power shell so looking for any alternatives ...
user avatar
  • 123

1
3 4
5
6 7
19