Questions tagged [caml-query]
An XML-based language that is used to build and customize Web sites based on SharePoint Team Services from Microsoft.
942
questions
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?
- 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='...
- 3,176
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 ...
- 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></...
- 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() +...
- 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>
...
- 5,191
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 ...
- 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&...
- 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>
...
- 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....
- 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 = {
...
- 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 ...
- 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 = ...
- 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 ...
- 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 ...
- 31
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 ...
- 965
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'&...
- 965
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 ...
- 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(...
- 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 ...
- 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 ...
- 113
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 ...
- 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>
<...
- 41
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 ...
- 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 ...
- 209
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 ...
- 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?)
&...
- 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 ...
- 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 = "&...
- 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 ...
- 209
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#.
- 573
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="...
- 118
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 ...
- 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 ...
- 1,839
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 ...
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 ...
- 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 ...
- 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 ...
- 53
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 ...
- 521
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&...
- 53
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(...
- 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".
...
- 209
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())
{
...
- 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 = "&...
- 573
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:
$()....
- 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&...
- 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?
...
- 331
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
<...
- 23
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 ...
- 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 ...
- 123