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
196 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
193 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
333 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
182 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
717 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
484 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
140 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
729 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
165 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
271 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
692 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
255 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
651 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
542 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
238 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
91 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
714 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
235 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
565 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
381 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
416 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
153 views

Caml Query Issue

I'm fighting with the Caml Query which returns zero items: <View> <Query> <Where> <And> <Eq> <FieldRef ...
2
votes
0answers
105 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
679 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
358 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
915 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
707 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
71 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
162 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
135 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
417 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
15k 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
200 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
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
vote
0answers
319 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
536 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
308 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
533 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
301 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
168 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
143 views

Can we check the variable in IsNull tag in CamlQuery?

var strName; var query="<Query>" +"<Where>" +"<Or>" +"<IsNull>" + strName + //Can this Works? "</IsNull>...

1 2 3
4
5
18