A message from our CEO about the future of Stack Overflow and Stack Exchange. Read now.

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
0
votes
1answer
149 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
241 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
615 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
232 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
2k 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
617 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
466 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
225 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
79 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
620 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
220 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
545 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
364 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
381 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
152 views

Caml Query Issue

I'm fighting with the Caml Query which returns zero items: <View> <Query> <Where> <And> <Eq> <FieldRef ...
1
vote
0answers
99 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
509 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
320 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
33 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
857 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
619 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
59 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
154 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
130 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
396 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
13k 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
196 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
4k 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
1k 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
vote
0answers
305 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(...
2
votes
1answer
493 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". ...
0
votes
2answers
289 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()) { ...
2
votes
2answers
491 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 = "&...
3
votes
2answers
2k 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: $()....
1
vote
1answer
286 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&...
2
votes
1answer
158 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? ...
2
votes
0answers
58 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 <...
2
votes
0answers
27 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 ...
0
votes
1answer
27 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 ...
1
vote
1answer
134 views

Can we check the variable in IsNull tag in CamlQuery?

var strName; var query="<Query>" +"<Where>" +"<Or>" +"<IsNull>" + strName + //Can this Works? "</IsNull>...
3
votes
1answer
768 views

Searching Criteria in SharePoint JSOM with the help of CamlQuery

Suppose i want to replicate following Sql condition in CamlQuery in JSOM The Condition is: WHERE @StudName IS NULL OR [StudentName] LIKE '%'+@StudName+'%' In above condition the @StudName ...
1
vote
2answers
204 views

CAML query to retrieve list metadata

Does SharePoint expose a list that can be queried for list metadata as returned in List.Fields? Background: My aim is to request only the data that I need. When I write: // string listName = "My ...
1
vote
0answers
230 views

SharePoint Online - Some fields are not loaded in List Item CSOM

1) I am getting list items from a list by CAML query in ListItemCollection objects of Max 5000 items 2) I am pushing each ListItemCollection into a List of ListItem to enable the capability of ...
0
votes
2answers
12k views

CAML query using OR and AND Condition

I need to write a CAML query which satisfies the below condition: projectstatus == "hold" OR projectstatus == "obsolete " AND ilprilt not equal to "ilp frozen" When I run this query, am ...
2
votes
2answers
3k views

How to query a list's user field for a given login name in Javascript?

I need to build a query a custom list with a user field. The where clause filters the results to a given list of user login names of a dynamic length, so I build the query according to the numbers of ...
2
votes
1answer
858 views

SharePoint Online CSOM CAML query problem in view

I have a pages library in sharepoint online with 2 views. Custom view - (I have added a condition in the view based on a content type) - contains 500 items, It has got 100 items where title starts ...
6
votes
1answer
12k views

CAML Query - Going around the 5000 List Item Threshold

I have developed a SharePoint system for a client and I am planning forward with regards to CSOM code that runs on a specific library. This will eventually expand to a large set of data. Experience ...
0
votes
0answers
247 views

How to read Article pages Title & Description from page Library using CSOM

In C# code get Article pages Title & Description from page Library... For this I used below code:- ClientContext clientContext = new ClientContext("siteUrl"); clientContext.Credentials = cred; ...
0
votes
2answers
44 views

unable to pass spuser as paramter into CAML query

I want to pass the spuser as a paramter to the caml query but when i tried the below code its throwing error: using (SPWeb spWeb = spSite.OpenWeb()) { ...
1
vote
1answer
236 views

How to filter a document in document library based on file properties using caml query?

I need to filter several documents in document library based on file properties(Two managed metadata property)using CAML query. Please suggest me an idea to achieve this