Questions tagged [caml-query]
An XML-based language that is used to build and customize Web sites based on SharePoint Team Services from Microsoft.
887
questions
0
votes
1answer
51 views
Getting ID for a list item with JS
I am trying to set up a simple subscription tool where users can subscribe to or unsubscribe from various distribution list. The idea is that you select a user through a people picker ('subuser'), ...
1
vote
0answers
18 views
CAML query for child properties
I have a CSOM query like this one:
_context.Load(currentItems,
lis => lis.Include(
i => i.RoleAssignments.Include(
ra => ra.RoleDefinitionBindings,
...
2
votes
1answer
32 views
I want to get list where invoice _category is service please help? [closed]
I want to get the list items where invoice _category is equal to "Service".
Please help?
Current code:
camelQuery.Viewxml = "<View><Query> <Where><Eq><FieldRef Name='...
1
vote
0answers
15 views
On publishing sites, how does the user's preferred Display Languages preference affect page contents and CAML query results?
On an on-premise SharePoint 2016 farm with Language pack deployed, we see that users with different preferred Display Language (in their profile) get different results of CAML queries, different web ...
0
votes
1answer
18 views
SharePoint CSOM query against concrete subfolder is not working with RowLimit when thresold is reached [duplicate]
Can you please help with the following question. I have a document library with a lot of documents (>5000) which are organized in subfolders. I have to query all documents in subfolder. I use this ...
0
votes
0answers
23 views
Filtering documents on SharePoint Online Library folder in a different site
I have a mammoth document library with folders on a site. I'm trying to show specific files in these folders so this is how the original Library View displays:
I've migrated this over from a ...
1
vote
1answer
16 views
SharePoint 2010 CAML - Casting Date Fields?
So I'm trying to build a CAML Query in SharePoint to query a list where Date is greater than a certain value say 1/1/2016, my CAML looks kinda like this
<Where>
<Geq>
<FieldRef name = '...
0
votes
1answer
46 views
CSOM CAML Query - is there a returned fields limit?
I've just noticed that that there is a difference in result when searching for a list item with CAML Query and getting it by ID.
Following piece of code returns item with 100 FieldValues:
var item = ...
0
votes
1answer
27 views
Getting and setting multiple items from a Sharepoint list using CAML query?
I have a SharePoint list Catalog.
Using camlQuery I can get a list item value called Price.
With the following code I get the Price value of the list element which has the ID 5 and store it in a ...
0
votes
1answer
39 views
How to retrieve the SP list items without using CAML Query?
I have a SharePoint list and I need to get all items from that list without using CAML Query in JSOM.
How can I do this?
1
vote
1answer
52 views
Error retrieving items from large list, although the CAML query has a row limit
I'm able to use a console application to connect to a SharePoint Online large list (more than 5,000 items) and retrieve the title. However, even though my CAML query has a row limit, I still get an ...
0
votes
1answer
34 views
Query a single line of text filed using CAML <Contain> will return all items
I have a list inside SharePoint online site collection. the list contain a field named Processed which is of type single line of text, and only one item have a value inside this field while the other ...
0
votes
1answer
48 views
CAML Query Help - O365 Sharepoint with Managed Metadata
I'm trying to display only documents from a library named "How to get it done" and I want to show all document types that have the Managed Metadata tag of "HFM".
Some of my documents have multiple ...
1
vote
1answer
36 views
Binding certain value from SP List to DropdownList
I am currently trying to grab certain values(choice column) from a SP list into a DropdownList in Visual Studio, for example, currently in the SP List choice column, there're 5 choices altogether but ...
0
votes
3answers
40 views
CAML error when querying SharePoint List for more than one input
I have a CAML query which retrieves data from a SharePoint list. It passes for 1 input, but fails when there are 2 or more.
Error:
Microsoft.SharePoint.SPException: One or more field types are not
...
0
votes
1answer
17 views
Query Modified Date
I found tons of samples with query for modified. But following keeps giving an exception that the query limit was to large (I gues it is the threshold limit).
var query =
$@"<View Scope='...
0
votes
1answer
22 views
If Else in the CAML Append Method
I have been trying to do an if else condition in the append method however for some reason it's not reading the condition. Here is the code. Towards the bottom I want to show signNow if the list ...
0
votes
1answer
32 views
Help with using Caml in rest api calls - filtering doesn't work for me
I'm trying to filter a Posts list(Blog) by month and year.
I created a calculated column and used the Published Date to extract month and year.
But my below code doesn't filter correctly when i use ...
0
votes
1answer
27 views
CAML - Getting the URL's ID for the Where Clause
Is there a way to get the ID from the SPGetCurrentSite? I want to use in my Where clause for my CAML Statement/ID field in the SharePoint list item. I'm new to CAML and I was using the below but I'm ...
0
votes
0answers
13 views
Having trouble with SPServices AutoComplete pulling from specific columns
I have 2 issues really. I have set this up successfully for some of my fields on my Nintex form. The autocomplete works perfectly.
Issue 1: I attempted to set this up on another field on another ...
0
votes
1answer
63 views
CAML Query “Neq” not working with choice field
I an writing one CALM query as below. But seems like Neq is not working for choice field. I am getting wrong results.
Does anyone know the work around.
<View><Query><Where>
<...
1
vote
2answers
57 views
CAML Query: filter items between dates
How to filter items between two dates with camel query?
For example, I want to retrieve items created between 2019-9-1 and 2019-10-5.
0
votes
2answers
39 views
CAML - How to handle filter?
SP 2010. I have a value "East & West" and list name Region. How do I handle special characters?
here is the caml that breaks
<ViewFields>
<FieldRef Name='ActionStatus' />
&...
1
vote
1answer
19 views
Combine 3 queries for different lists into one
I am building API for client side apps. There are 3 API requests for 3 different lists as following:
tasksQuery = string.Format(@"<Where><And><Geq><FieldRef Name='Created' />&...
0
votes
1answer
25 views
How to set InfoPath form fields values in task list without using workflow?
I have 5x action items fields on the InfoPath form. This form have more than 500 fields so get touching the boundary limits in terms text box fields datatype. Is there any way that we can set the form'...
0
votes
1answer
29 views
'n' number of CAML queries in a single executeQueryAsync function
How to execute 'n' number of CAML queries to get a different list of objects? We can use multiple clientContext.load() if we have a defined number of queries like clientContext.load(collListItem); ...
0
votes
2answers
167 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
16 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
50 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>&...
asked Jul 23 '19 at 6:30
Akshay Dattatray Nangare
3,1144 gold badges41 silver badges82 bronze badges
1
vote
2answers
32 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 "[...
2
votes
2answers
122 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
46 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
27 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
52 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
89 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
49 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
227 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
25 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
216 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
20 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
27 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
44 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
24 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
39 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
23 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
40 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
82 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
28 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
289 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
225 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 ...
