Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

6
votes
1answer
154 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 ...
3
votes
0answers
97 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 ...
3
votes
0answers
355 views

Is it possible to perform Inner Join with Lookup Multiple Value Field?

I use CAML Query to perform inner join between two lists. It works when the lookup field is single value. However, when this field is multiple value, it always throws error: the value does not fall ...
3
votes
0answers
81 views

<In> overrides everything else in SharePoint CAML query

I'm writing a CAML query for SharePoint. The list contains a term set field. I want to get all list items having specific terms, plus items where no term is set. My query contains this: <Or> ...
2
votes
0answers
97 views

Move documents from one subfolder to another/root folder

I have a document library with sub folders. I would like to move the document(s) from one folder to another/root folder. Is this possible using CSOM/CAML? I am pretty new to Sharepoint development so ...
2
votes
0answers
68 views

CAML Designer through ADFS authentication

I cannot seem to authenticate via CAML Designer for a SharePoint 2013 on premise installation that is using ADFS and Windows auth for authentication. In my case, all Windows Users have a deny access ...
2
votes
0answers
1k views

SP2013 : CAML query for managed metadata columns for multiple items selected ?

How to write a caml query to fetch data from a managed metadata column ? I have written caml query which works fine for data matching to "Business" . How do my query return results if the data is ...
2
votes
0answers
71 views

Does the total amount of lookups affect performance in a CAML query that has less than 8 lookup columns?

I have a large library with 12 lookup columns, and while I only use 6 of these columns when I retrieve data from this library (in a CAML query), the retrieval process often takes 20-30 seconds. Would ...
2
votes
0answers
120 views

CAML Query scheme in depth

I have a plan to develop my own version of the CAML builder app - as a pet project and in order to improve this field. :) It would be nice to support all the capabilities of the CAML query scheme ...
2
votes
0answers
1k views

How to find out whether or not a list is hidden without writing code (SP2010)?

Does anyone know if there is a way of telling (without writing any code) whether or not a list is "hidden"? I have a CAML query which contains the following and I'd like to eliminate the possibility ...
1
vote
0answers
187 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 ...
1
vote
0answers
196 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 ...
1
vote
0answers
48 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 ...
1
vote
0answers
122 views

Extract data from ows_MetaInfo

I'm trying to extract all data from an SPListItem. Most of the data is in the ows_MetaInfo attribute in some strange format. Is there a way to either deserialize ows_MetaInfo, or get the fields in an ...
1
vote
0answers
31 views

How Do SPViewScope Enum Members Map to CAML Scope Options?

The SharePoint CSOM library defines an enum named SPViewScope with the members Default, Recursive, RecursiveAll, and FilesOnly. The CAML specification defines the Scope attribute of the element as ...
1
vote
0answers
138 views

How to create a CAML query comparison that works on both numbers and strings?

I am working with a system that makes requests to SharePoint lists that have latitude and longitude columns. One of the most common use cases is requesting list items that fall within a certain ...
1
vote
0answers
187 views

SharePoint REST API & CAML query integration Online Add in/App

I am trying to integrate CAML query in rest API and trying to get data from a SharePoint List residing in host web. I am using method: function getDataWithCaml(listName, caml) { var executor = new SP....
1
vote
0answers
27 views

How can i retrieve only sub folders inside a folder in a document Library?

How can i retrieve folders and documents that are immediate child in a folder (level 1).
1
vote
0answers
46 views

Can SharePoint use an index for 'Begins with' queries?

Lets say I have a 'Begins with' CAML query for a column and I also created an index for this column. Can SharePoint use this index for the query?
1
vote
0answers
119 views

Query for SharePoint 2013 REST search

I have to site columns (column1, column2) that are also crawled by the search and available as Crawled properties, so I can use them as filters in REST query as well. I'm now trying to build the REST ...
1
vote
0answers
212 views

SPServices new item return expanded user information

I'm creating new discussion in a list using SPServices, like this: $().SPServices({ operation: "UpdateListItems", batchCmd: "New", listName: discListName, updates: "<Batch OnError='...
1
vote
0answers
87 views

CAML, how to get Fields which are having Unique condition

I am trying to get the field info of a list and I need to also know whether the field has Enforce unique values: as true. IEnumerable<List> lists = clientContext.LoadQuery( lists.Include(list =&...
1
vote
0answers
47 views

Is there any way to implement numbered pagination instead of PREV | NEXT using JSOM without using search

I'm wondering if there any way to implement Numbered pagination while retrieving items from a list like "PREV 1,2,3..NEXT" instead of just having "prev | next". I followed this code example MSDN and ...
1
vote
0answers
217 views

CAML Query to get only items from SharePoint Library

I have a large document library with folders, I'd like having all the items except the folders. for now, i use this where columns is a list of all internal name from the list CamlQuery q = CamlQuery....
1
vote
0answers
167 views

Recurring Event Filtering Using CAML queries

I used following query to search between 2 dates ranges but it doesnt filter recurring instance of that day <Query> <Where> <And> <Geq> <...
1
vote
0answers
171 views

Custom Field RenderPattern Customization - SharePoint 2007

I'm creating a custom field in SP 2007. I need to Get the Custom field value and field properties on Item click, in the list item display view. Also i Need to pass these values to a JavaScript. So, ...
1
vote
0answers
55 views

SP2010 - Visual Web Part - Storing metadata in folders in document libraries

I want to store a number to folders to enforce ordering. I noticed these three pages Get Property Set Property Add Property And I want to know if it's possible to use these to add a number to the ...
1
vote
0answers
321 views

Sharepoint Webservice not filtering Data

Working Version Issue: I am querying SharePoint using SP CAML Query Helper. Using SPCQH I am able to retrieve one order. The query works. Once I add the query to my Biztalk solution the query below ...
1
vote
0answers
125 views

How to check value from other sharepoint list?

I have two custom lists in SharePoint 2010 (Absent Request and Employee Leave Balance) with these columns: Absent Request List: Absent Type, Approver, Start Date, End Date, Absent Reason Employee ...
1
vote
0answers
76 views

Calendar repeating alert

I have a sharepoint calendar which I would like to send out alerts for recurring appointments. All the appointments are on a monthly basis, e.g. every 3rd of the month. I have a reminder web part ...
1
vote
0answers
138 views

Sharepoint - caml join with numbers

I have done a join in Caml with my list (example list A) to another list (example list B) One of the fields in list B is a number of 2 decimal places. However, in the view it is displaying lots of ...
0
votes
0answers
4 views

Filter webpart for XsltListViewWebPart postback and paging problem

I am building a custom list filter webpart farm solution for Sharepoint 2013 and 2016. It is put on the same page as the XsltListViewWebPart to be filtered. I do this by changing the caml query inside ...
0
votes
0answers
22 views

CAML query inside my List view which contain 19 critiria is not working

I want to create a list view inside sharepoint on-premises team site. the list view need to show items which are under any of the 18 customers + that are not Expired.. so i wrote the following CAML ...
0
votes
0answers
9 views

Two lists with Site, one with site number, and one with column with many site number Need Assistance

I have got two lists one with one site number in record, and one with many site numbers in one column: -------------------- --------------------------------- | Site | Name | |...
0
votes
0answers
146 views

Get two items from same list in a single CAML query

We have a list with following fields: FlagField : Yes/No DateField : Date only I need to fetch two items from the list One where FlagField is set to Yes and DateField is latest (Descending order) ...
0
votes
0answers
56 views

CAML Query Type as text, show all items

I have this query camlQuery.ViewXml = "<View><Query><Where><Eq><FieldRef Name='Title'/><Value Type='Text'>21094460</Value></Eq></Where></...
0
votes
0answers
34 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 ...
0
votes
0answers
161 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 ...
0
votes
0answers
320 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 ...
0
votes
0answers
144 views

SP2013: CAML query return result paged?

I have a list of 2500 items which I need to filter and then iterate through. Since the payload of returning (potentially) 2500 items is too big I need to break it down into small pieces. For this ...
0
votes
0answers
340 views

SPQuery not returning expected results

I am trying to filter a SPListItemCollection with CAML but I don't get the results I want. Here is my code: query.Query = "<Eq><FieldRef Name=\"Title\" /><Value Type=\"Text\">" + ...
0
votes
0answers
679 views

Error : “Value does not fall within the expected range.” while using JOIN in CAML query

Here is my code: SPList list = web.Lists["List1"]; SPQuery query = new SPQuery(); query.Query = @"<Where>" + "<And>" + "<Eq>" + ...
0
votes
0answers
406 views

return empty fields using lists.asmx and GetListItems

I have a list with 3 fields. I'm able to get the rows but in the returned XML if one of the fields is empty then the field is not in the XML. Is there anyway to get all fields I specify in ViewFields ...
0
votes
0answers
1k views

Caml LookupId and LookupValue

I need to get the LookupId value and the lookup text value by CAML. With this query I get the ID but I can not get the value text anymore. <RSSharePointList xmlns:xsi="http://www.w3.org/2001/...
0
votes
0answers
44 views

CAML query Problem

I tried several CAML query builder for generating query but its not generating correct Query. I want to query calender list with following logic StartDate >= Today And EndDate <= Today ...
0
votes
0answers
156 views

sharepoint alert filter not working on first alert only then filtering is ok

have a strange behaviour with alerts on my sharepoint site. I have a document library where i want to add alerts to specific users when adding,updating,deleting folders or documents. Alerts must not ...
0
votes
0answers
417 views

CAML query on site to get all items modified after a date

I'd like to know a way or if it's possible to get all items modified from a date in a site. Now for having this, I've got a client script because I'm in sandbox solution, I've to loop on each list of ...
0
votes
0answers
659 views

Sharepoint 2013 List WYSIWYG Designer views

We need to offer our users a way to freeform format Custom List fields anywhere on a SharePoint page. The designer can not be InfoPath, SharePoint Designer or Reporting Services. Design experience ...
0
votes
0answers
278 views

Get Items Lookup Mult timeout

I have a list with many records , and when I'm doing a filter for a column that is Lookup Multiple runs smoothly : Example <Where> <Eq> <FieldRef Name='Column' LookupId='TRUE'...
0
votes
0answers
104 views

Get SPListItem by title is very slow

I want to get a SPListItem by title. I´m using a CAML query to filter the list (Around 1000 items). There is only 1 item with the title in the list. My problem is now that the performance is really ...