Questions tagged [caml-query]
An XML-based language that is used to build and customize Web sites based on SharePoint Team Services from Microsoft.
862
questions
0
votes
2answers
20 views
SharePoint CSOM list group by and filter
I have a list with columns "fruit" and "ripeness". Using csom, how can I return "Banana" where Yellow count >= 3?
ClientContext ctx = new ClientContext("https://sharepoint.blah.com");
List list = ctx....
0
votes
0answers
11 views
Populate Fields when Clicking “Save” on Custom List
I have a SP 2013 Custom List with 2 automatically generated numbers. Currently, they are queried and populated upon selection of input values for the first 2 fields. The form works great for a single ...
1
vote
1answer
29 views
Camel Query OrderBy not working for Decimal Number
I have column name OrderBy of Type Number:
I am using below CAML Query:
"<View><Query><OrderBy><FieldRef Name='OrderBy' Ascending='TRUE' />
</OrderBy></Query>&...
1
vote
2answers
26 views
Field Value of Loaded List Item is Unexpectedly Returning “NaN”
I'm trying to query the last item in the current list where status = New, so I can auto-populate one of the fields based on the previous item's value. Executing "alert(collListItem);" displays "[...
1
vote
2answers
32 views
CAML Query Last List Item Where Status = New
I have a SharePoint 2013 custom list and a requirement to load the last list item where Status = New. I first tried SPGetLastItemID with a CAML query filter - however, that method only returns items ...
0
votes
1answer
25 views
CSOM, GroupBy, specific ViewFields and system fields
From my SP library, I would need to retrieve a list of meetingID grouped by MeetingID.
I tried several attempts with CAML but it didn't work:
CamlQuery query = new CamlQuery();
...
0
votes
1answer
14 views
how to get file from library which stored in unknown folder( need c# csom)
I have library which has many folders and I have file name and want to find using name of the file from those folders (dont know in which folder that file placed). please help to write code using c# ...
0
votes
2answers
19 views
Order List Using Caml Query in a text field as a number on SP 2010
How can I order a Column where the type is text, but all the values stored are numeric,
I want to order it descending but considering the Column a Numeric field without changing the column type
...
0
votes
1answer
19 views
Possible to get tasks based on a local custom field value using Project Server JSOM?
I have been working on a web part that lives on a SharePoint site in a Project Web App instance, and interacts with Project Server using the Project REST API.
I need to be able to get tasks based on ...
0
votes
1answer
21 views
CAML Query to search comma separated values similar to SQL query
Instead of below query, is possible to write dynamic CAML query for below CAML query. because below query will not work for dynamic data:
<Where>
<Or>
<Or>
&...
0
votes
2answers
45 views
Caml query to retrieve image from a document library
I am currently facing an obstacle where I have to create a webpart that uses CAML to get the latest image from a document library in Visual Studio. May someone share their code with me on how to do ...
2
votes
0answers
22 views
Sharepoint CAML Query does not work in IE when searching by Taxonomy Field
I've the code below:
function ReceivePages(FirstFolderProd, FirstFolderWithoutSpaceProd, GetTagFolder){
var restUrl = "https://tenant.sharepoint.com/sites/sites/Negocio/...
0
votes
1answer
25 views
Fetch All fields from a people group field using Caml Query
I have a SharePoint list which contains a people or group field where I want to fetch the Id which is stored internally and name is displayed.
Can anyone tell me how to fetch all the values from ...
0
votes
0answers
19 views
Accessing and counting from same list only works once
I've been trying to show a count subtracted from a maximum of 35 for a seating count.
I've tried everything I can think of and have come to a dead end for myself. What am I doing wrong in my below ...
0
votes
1answer
23 views
CAML query to enable/disable custom ribbon button
I have a custom list and when the user open the list item Display form there is a custom ribbon. This ribbon should be enabled if the current user is a member of a particular Group. Here is the caml ...
1
vote
1answer
20 views
CAML QUERY does not work in IE11 when searching by content type
I've this code below:
function BuscarDocumentosHoje(Departamento,NivelAutorizacao,NumeroColaborador,todayfinal){
var restUrl = "https://tenant.sharepoint.com/sites/site/Negocio/Precario/_api/web/...
0
votes
1answer
14 views
Using Count values in another function for my Chart.js Pie Chart
Using Chart.js to display a Pie Chart.
However, I'm hard coding the data values.
Below is the entire code:
$(function(){
//Start Data Pull
//End Data Pull
//get the pie chart canvas
var ctx1 =...
0
votes
1answer
17 views
CAML - Querying with multiple WHERE Clause
Getting my feet wet on CAML. I was able to get a query that shows a count for a list. Now I need to do count based on multiple information.
Dog
Dog
Cat
Cat
Cat
fish
fish
fish
fish
Loops through and ...
0
votes
1answer
21 views
Count to display in a page
I received this fix via StackExhange Sharepoint but I can't seem to locate it again for my post (sorry)...but it did work using CAML Query to count items in a list.I want to change one thing...I want ...
0
votes
1answer
33 views
Create custom webpart that uses CAML Query
I am quite new to Sharepoint and I am supposed to create a webpart that can display all the titles with a specific value from a managed metadata column(TAGS). I am required to write a CAML Query to ...
1
vote
1answer
57 views
Get unique value using Sharepoint CAML Query JavaScript
I've this code below:
function ReceivePages(FirstFolderProd, FirstFolderWithoutSpaceProd, GetTagFolder){
var restUrl = "https://tenant.sharepoint.com/sites/site/Negocio/OfertaParticulares/...
0
votes
0answers
24 views
Will a CAML query using Method and Filter against an external list be passed through to the external data source?
I have an external list/content type set up that reads data from a SQL database view. (I only have access to one view, I do not have access to any tables directly.)
This database has been around for ...
0
votes
2answers
84 views
Get User Name Using CAMLQuery
In a CAMLQuery what token can we use if we want to query against a person or group field with value as our user account?
5
votes
2answers
126 views
Create list alert with filter on managed metadata field
I'm trying to create an alert on a list. The alert should only trigger on a subset of the list items for which a certain managed metadata field has a certain value. So I'm setting the Filter-Property ...
0
votes
1answer
33 views
Filter list data after retrieving the list using JavaScript
I am trying to carry out a number of queries on a share point list. I know you can use CAML queries to filter the list to only show specific information. However I am looking to retrieve the entire ...
0
votes
0answers
12 views
Get no data when querying with date in caml query sharepoint
When I am trying to query on any date field I am not able to get any data even with caml query:
<Where>
<Eq>
<FieldRef Name='date' />
<Value IncludeTimeValue='...
0
votes
0answers
17 views
How to retrieve all the SharePoint surveys I didn’t answer yet?
How to retrieve all the SharePoint surveys I didn’t answer yet using Rest API?
0
votes
1answer
31 views
sharepoint Image gallery application with lighbox
I want to create Image gallery widget in my sharepoint website that will access the image from sharepoint list.Below is my requirement
Image gallery view will display in carousel or slider
when we ...
0
votes
0answers
17 views
Sharepoint application to show image gallery in carousel
create a photo gallery with lightbox feature as well in sharepoint website with carousel as the image will show in slide and when the click the current image that will display on screen it display ...
0
votes
0answers
21 views
Sharepoint 2013 CSOM get subfolder items only
I want to get particular folder or subfolders items only on demand, not all recursive.
My code so far:
private static void GetListItems(string relativeUrl)
{
var context = new ...
1
vote
3answers
69 views
Issue while retrieving data in SPFX
I am trying to get data in SPFx using REST and also need to use CAML for making the query. CAML is required as I want to filter based on certain groups the user is present in, so giving that up is not ...
0
votes
1answer
63 views
how to change caml query with condition <OR> for 5000+ list items
I have this CAML query that wouldn't work if i change it to but works with HOWEVER. since our list no has 15k items using OR doesnt work. basically this remote event receiver gets list items with ...
1
vote
1answer
23 views
Retrieve a Value From A List Based On Who Is Logged In
I currently have the vacation days for all the employees saved in a SharePoint list. I would like to display the number of vacation days the employee that is logged in has on the Home page. For ...
1
vote
0answers
63 views
Check if Parent Folder contains more than 1 document and then delete particular document CAML Query SharePoint 2013 CSOM
I want to delete document with name 'Test' in CSOM. this document is present in subfolder. whereas code should delete this document only if its parent folder(i.e subfolder) has more than 1 document. I ...
1
vote
1answer
34 views
How can I get a subfolder's GUID which is under a document library with soap and javascript or CAML query?
I want to fetch this subfolder's documents. but CAML is not showing the documents clearly . thak you.
2
votes
1answer
28 views
Order By Ascending with CamlBuilder()
How to write a function to order by ascending: true for date field. There is a picture library in our site.
I find .OrderByDesc('year'), but I need it's opposite:
var query = new CamlBuilder()
...
1
vote
1answer
41 views
CAML Query with more than one condition
Hi I am currently writing a sharepoint add in application which reads and writes to sharepoint lists.
For one of the lists I want to retrieve a list item based on the user logged in and also based on ...
1
vote
0answers
201 views
JSOM: CAML Query List view threshold error for large lists
This is a topic discussed many times before but I have a peculiar case now and need some expert opinion on this.Below is a sample scenario I am trying to test:
My List Set up:
List has 10k items.
...
1
vote
1answer
82 views
CAML query returns different data
I created a CAML query that I need to use as a workaround for REST API and the 5k threshold limit: However when I was testing it using the SharePoint CAML Query Helper Online, it returns the correct ...
1
vote
0answers
19 views
Want Filter fetch data from SharePoint lIst on the below code of autocomplete JS
where DocumentOwner(People Group Type Column) = Me (Current Logged in User)
Here i save current logged in user in a variable named as OwnerTitle
and RequestStatus(Choice Type Filed) is equals to ...
0
votes
1answer
39 views
Camlquery Datetime strange problem
Sharepoint hosted app where saving and reading data from sharepoint list.
Getting time to Datetimepicker and convert it to current timezone:
var Time1 = $('#TextBox_Startdate').val();
var ...
0
votes
1answer
57 views
Build caml query in javascript in sharepoint designer
<script type="text/javascript">
$(document).ready(function () {
var listName = "Leave Request";
var context = new SP.ClientContext.get_current();
var list = context.get_web()....
0
votes
1answer
89 views
Caml Query weekly and monthly
I want to build a CAML query that show the data on monthly and weekly basis.
Please help me to provide the best solutions for the query
In SharePoint there is a list created for leave application ...
0
votes
1answer
149 views
Searching through REST API and CAML with Paging
I have requirement to filter two fields with substring but I found out that substring is not working in REST API it have some kind of bug. So below question stackexchange.com suggested to use listdata....
0
votes
3answers
147 views
caml query won't return rows with null value in contains query
I have written a CAML query using <Or> with <Contains>.
the query looks similar to below:
<Where>
<Or>
<Or>
<Contains><FieldRef Name="Field1" /...
0
votes
1answer
52 views
How To: Filter A Query on All Lists Based on Title Contains
I have queried all of the lists within a subsite but need to filter based on criteria in the title.
I then need to display the filtered list contents. Is this possible if the list contents are not ...
0
votes
4answers
69 views
How To: Query & Display items from ALL lists within a subsite
I am looking to query and display items from all of the lists that exist (and will exist in the future) on a specific subsite (SP 2013).
Below is what I have so far but it is not producing any alert,...
2
votes
0answers
54 views
SPQuery.viewFields does not return specified fields
I have a list that contains multiple views. I am filtering the view data on the basis of date range using CAML Query. But I don't want all the fields to be return so I used viewFields property of ...
0
votes
1answer
71 views
How to change date display
Currently the below code gives me a date display of: 2019-01-31 00:00:00. I would like to see it displayed as: 31 January 2019 instead...
<table width="35%" align="left" id="myHTMLTable" border=...
1
vote
2answers
401 views
CAML Query for retrieving only document library items in only one folder
I'm trying to access the documents in a specific folder in a SharePoint document library. the library has multiple folders but I do know the name of the folder.
here is an example of the file tree (I ...
