Questions tagged [caml]
Collaborative Application Markup Language (CAML) is an XML-based language that is used in Microsoft SharePoint Foundation to define the fields and views that are used in sites and lists.
542
questions
0
votes
0
answers
38
views
How can i fetch custom list columns with javascript?
I created a list and it has got GroupName and EmailName columns. I want to fetch the data but this code is not working. How can i solve this?
var GroupName=$(this).attr("GroupName");
all the ...
- 641
1
vote
0
answers
486
views
CSOM (HighTrust) SP2013 Group by aggregate giving duplicates
Hi I've been reading about group by in SharePoint 2013 CSOM from this article here.
https://piyushksingh.com/2016/11/21/retrieve-grouped-listitems-sharepoint
I've recently upgraded to 2013 and though ...
- 187
1
vote
2
answers
802
views
CAML query cant read serverrelatedURL with special character
My scenario :
I am using a caml query to read all folder and files in a list but i noticed that if i get a folder by serverrelativeURl and the list name is(eg késhév,ie has special character or a ...
- 1,664
0
votes
2
answers
15k
views
Get all items of a Folder and subfolders using csom [duplicate]
My scenario: I need to update 2 columns of items in a certain subfolder.But here the subfolder can contain subfolder and so on which i need to update too.I am using csom to try to accomplish that.I ...
- 1,664
1
vote
2
answers
1k
views
Filter and Sort the List with Caml Query
We are required to display the list data based on below 3 conditions for the based on 3 columns (Customer Category, Test Type ,Exercise Result) and sort with column (stage Plan) .
1. Customer ...
- 1,155
4
votes
1
answer
3k
views
How to Group by the Column using CAML Query
My requirement is to get the unique values from the column "Month" I am using the below code to group the column "Month" , But I don't find any luck .Can any one tell me what's wrong in my below code ...
- 1,155
0
votes
0
answers
549
views
CAML Query on value ending with space
I have the following CAML query:
<Where><Eq><FieldRef Name="Title" /><Value Type="Text">TestDocument </Value></Eq></Where>
I have an item in the list with ...
- 443
2
votes
2
answers
2k
views
Sharepoint 2013 Check if path folder exists
I have a query like this:
camlQuery.set_viewXml('<View Scope="RecursiveAll"><Query><Where>
<In><FieldRef Name="FileDirRef" />
...
- 21
0
votes
1
answer
471
views
CAML query incorrectly returns all items
I am querying a list with this CAML Query:
var camlQuery = @"<Query>
<Where>
<Eq>
<FieldRef Name='...
- 656
0
votes
1
answer
3k
views
How to pass variable value in CAML query?
I have a Dropdown list, I want to pass selected value of this dropdown to caml query. Please suggest solutions for this SharePoint online query.
- 13
1
vote
2
answers
502
views
How to insert CAML query into SharePoint site?
I am trying to insert some CAML into my site and I am not sure how to do so.
I have been looking around at the available Web Parts (and other areas) to allow me to add a CAML query to my site, but I ...
- 35
0
votes
1
answer
430
views
MultiLookup column and CAML query
How to create CAML query to find items which have all specified lookup values?
The query below returns items which have item1 or item2, or (item1 and item2).
But I would like to return only items ...
- 25
5
votes
2
answers
701
views
CAML Query Logics
For this below logic, how to write a CAML query? Kindly guide me.
Query Logic:
where department ='HR' And (Team='A' Or Team ='C' Or Team ='D')
Here "department" and "Team" is ...
1
vote
0
answers
1k
views
CAML Query to get filename with the corresponding DocumentSet
I have a document library with Document Sets, and inside document sets I have files.
I need a CAML Query to return ONLY the files, but I need to know to which Document Set each file belongs to.
I am ...
- 5,201
1
vote
1
answer
1k
views
CAML - Get Items Under ALL existing Folders
I have about 10 Document folders in my list 'ZooLibrary' and
I would like Query to display all the PowerPoint files title from the folders in the list, sorted by ID.
Currently, my View Scope='...
- 109
1
vote
1
answer
489
views
Caml query for multiple status
I want to create a CAML Query like this
(status= waiting for approval && Requestor Manager = UserID)or(status= stage2 && Approver= UserID)
Please let me know what i am wrong here
&...
- 337
1
vote
1
answer
41
views
JS: If 'X' is mentioned anywhere in the LIST. Display
My list categories:
Cats
Dogs
Cats and Dogs
What i want to achieve:
If 'Cats' is ANYWHERE mentioned in the list field, display data in HTML table. This means category
Cats
Cats and Dogs
will ...
- 109
0
votes
1
answer
585
views
Display CAML Query Results in Existing Webpart using JavaScript
I am probably missing an obvious solution but after spending a couple of days on this topic I'm a bit stuck. The scenario I have is a site page with Content Editor Web Part (CEWP) and a Document ...
3
votes
0
answers
133
views
Construct CAML Query from ListView Filter URL-Params in SP2013
Im trying to construct a CAML query from the current Listview filter settings. I dont know in prior how many filters the user may set.
My goal is to create a CAML query which has the exact same ...
- 331
2
votes
3
answers
170
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
210
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,226
0
votes
1
answer
413
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
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,201
0
votes
1
answer
80
views
CAML Query to get approved items and items submitted before today is failing
I do not have a CAML Builder installed so just wanted to freehand this code. However I find that it is failing.
<View>
<Query>
<Where>
<And>
<Leq&...
- 1
1
vote
1
answer
1k
views
How to JOIN two lists by lookup column in Sharepoint Online
I'm a newbie in javascript and i'm using jsom to retrieve list items in Sharepoint Online.
I have two lists BnzPersons and Sessions.
This is my first code variant:
<div id="divListItems"></...
- 11
1
vote
1
answer
182
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&...
- 522
1
vote
0
answers
89
views
CAML Query preserve line breaks
I am querying a list containing a multi-line text-field using CAML. However - how do I preserve line-breaks when retrieving the content? The field contains HTML-markup using <pre> tags.
Any ...
- 355
0
votes
1
answer
589
views
Adding a chart using chart.js. How to call data from a list on different page
I am trying to build some visuals in Sharepoint to present the list data in a more useful fashion.
charts.js appears to be a free resource for this purpose so i have been playing with that and have ...
0
votes
1
answer
1k
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
2
answers
185
views
Help with this Caml Query ? Use in SharePoint Add-In
I'm using this caml query in order to receive only the item with title "Full Day"
CamlQuery getFullDayHoursQuery = new CamlQuery();
getFullDayHoursQuery.ViewXml =
...
- 367
2
votes
1
answer
256
views
How are the results of a SPQuery sorted by default if OrderBy is not specified?
Take this simple SPQuery for example:
SPQuery query = new SPQuery();
query.Query = "<Where><IsNotNull><FieldRef Name='Modified' /></IsNotNull></Where>";
query.RowLimit = ...
- 23
0
votes
1
answer
155
views
Is there an enumeration for field properties on Field creation?
I want to create a CAML for creating fields. There are some properties that could be different. So the XML at the end looks something like this:
void CreateField(string name, bool isCharacter, bool ...
- 774
3
votes
1
answer
1k
views
CAML query list created date +2
I am wanted to query a list which brings back items which are greater than 2 days old. I am unsure how the CAML query should look. Below is my code
<Where>
<And>
<Eq>
...
- 71
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
0
votes
1
answer
624
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
173
views
Caml Query Issue
I'm fighting with the Caml Query which returns zero items:
<View>
<Query>
<Where>
<And>
<Eq>
<FieldRef ...
- 1,190
1
vote
1
answer
118
views
Sp.Js Error When Running CAML Queries
I have added the below code to a (non-Publishing feature enabled) page in SPO to grab some items from another list and render them out; have done this sort of thing before without an issue (code is ...
- 1,308
1
vote
1
answer
38
views
Internet Explorer 8(Default) Issue, Chrome is Ok
I have created CAML query. Below is the code for searching list item.
<input type="text" style="width:350px" id="txtSearch" />
<dl class="dropdown">
<dt>
<a href="#">
&...
- 897
1
vote
2
answers
659
views
CAML query from the check box list
I have a CAML query. Users want to select more than two country from the check box at one time and search. How can I do array in CAML ?
<input type="checkbox" name='country' value="Global/Other"&...
- 897
1
vote
1
answer
1k
views
SharePoint - Document Library - File Size Units?
I am fetching file properties from a document library using below query(I am using c#,csom)
camlQuery.ViewXml = @"<View Scope='RecursiveAll'>
<Query>
...
- 431
0
votes
1
answer
709
views
Sharepoint CAML choice query returns the same value
I'm trying to take records from a list, based on Article Type field, which value type is choice. The problem is, that no matter what I'm giving as a type in query, result is still the same. I ran it ...
- 41
0
votes
0
answers
619
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,308
8
votes
1
answer
26k
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,308
1
vote
2
answers
255
views
CAML index of option?
I got a question regarding CAML and retrieving data. I need to determine the proper people based upon the places user submits.
So I created the lists People-Place where I have column Place and ...
- 11
0
votes
1
answer
486
views
O365\SharePoint rest call on Large list - checked out (recursive)
Wondering if anyone has a suggestion for querying a large list > 5000 items to get all the checked out files (recursively).
Can I query the search index for this?
Here's what I've done so far ...
- 61
1
vote
1
answer
2k
views
CAML Query to Get Single List Item Failing
So this is about the third script I've copied (this time from C# Corner) in an attempt to get a CAML query working but as with the others, I can't get it to work. Starting to get pretty upset about it ...
- 1,308
0
votes
1
answer
264
views
Display CAML Result In SharePoint page
How would I display the result of a CAML query via javascript on a SharePoint page? I'm trying to use this result in inline HTML similar to this:
<h5> Current OnCall: [CAML Result]</h5>
2
votes
1
answer
579
views
CAML Query to Filter On DateTime Field using DateDiff
I'm looking to use javascript and CAML to place a value on a SharePoint page.
I need to find the current On-Call person based on the start and end date of a list item, and the next on-call person ...
1
vote
2
answers
2k
views
CSOM C# Caml Query on managed metadata field not working
I am trying to find an item in a list where the managed metadata field is equal to a certain text value. This is the code that I have which is not getting any items in the list (ListItemCollection ...
- 245
6
votes
1
answer
177
views
SharePoint 2010 list Item Query
We have a big list in SharePoint 2010. I'm gonna query SharePoint 2010 list item in the web part based on country. I used CAML and JS. I have got errors in different browser"
Internet explorer says
...
- 897