Skip to main content

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.

Filter by
Sorted by
Tagged with
1 vote
0 answers
262 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....
Sree Kuttan's user avatar
0 votes
3 answers
765 views

caml Query Returning Last Item in List

I have a CamlQuery which I set as follows: camlQuery.set_viewXml('<Where><Eq><FieldRef Name="Part_x0020_Name" /><Value Type="Text">' + partName + '</Value></Eq><...
Ulthran's user avatar
  • 127
7 votes
2 answers
1k views

Selecting only PowerPoint files in a CAML query

I am trying to select all PowerPoint files in a list. How do I do that? Up until now I used this: class UsedIn { private static NetworkCredential credential = new NetworkCredential("login", "pwd", "...
UsefulUserName's user avatar
2 votes
1 answer
1k views

2010 : Get specific File from specific sub folder using CSOM C#

I have a document library with following structure. Document Library Name |_FolderA |_SubFolderA |_FileName_A |_FolderB |_SubFolderB |_FileName_A Now I just want to update the field for ...
Aakash Maurya's user avatar
1 vote
0 answers
34 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).
TheCoder's user avatar
  • 469
1 vote
1 answer
643 views

Getting the object values of a hyperlink column using JSOM

I have a column defined as a Hyperlink or Picture. Using JSOM and CAML in the CAML is have specified <FieldRef Name='HyperLinkFieldName' /><Value Type='URL'></value>" I'm able to ...
PianoMan's user avatar
  • 367
0 votes
1 answer
113 views

Caml designer for SP2010 - connection probelm

I am new to SharePoint. I have a problem with CamlDesigner2013, it does not want to connect to my site (SP2010). It complains about the Credentials!! I am using the administrator account, and still ...
Suha Alhabaj's user avatar
0 votes
1 answer
291 views

Or clause in CAML query behaving like And clause

I have a custom content type in the Pages library of a publishing site, which contains two multi-value taxonomy fields. I'm trying to write a CAML query that will return any items from the Pages ...
MerkinMuffley's user avatar
1 vote
1 answer
497 views

Method to get list headers & filters via jQuery SPServices CAML GetListItems or similar?

Is there a method similar to GetListItems to grab the column headers and/or filters for a list? Or a way to use GetListItems to get that information?
totl's user avatar
  • 11
1 vote
1 answer
80 views

Error updating List Items

I have found this code to perform batch update function updateListItems() { var itemArray = []; var clientContext = SP.ClientContext.get_current(); var oList = clientContext.get_web()....
Shomit's user avatar
  • 35
4 votes
4 answers
225 views

SP - CodError with CAML query,

I want go get last record field value from my SPList with CAML query. Really code working but gives me following ERROR... My Code: void ddCarNumber_TextChanged(object sender, EventArgs e) { try ...
Goshky's user avatar
  • 2,058
-1 votes
1 answer
784 views

Caml query with more than 2 or conditions [closed]

var fieldName; var listFields; var CmalQuery; $(document).ready(function () { $('#btnSearch').on('click', function () { txtValue = $('#txtSearch').val(); ...
user56369's user avatar
0 votes
1 answer
2k views

What is the limit of nested OR's in a CAML Query?? For each Version?

I'm needing to know what the exact nested CAML Query limits are for each version of Sharepoint? Also are these limits the same for using the IN, INCLUDES Operators with 2010+ ???
adha409's user avatar
  • 169
0 votes
1 answer
80 views

error : collection has not been initialized on deleting an item from list

Below is the function and its fetching the Amount and uno but it throws an exception on clientContext.executeQueryAsync(). Here is the Code: function delRec() { var uno; var itemArray = []; ...
Shomit's user avatar
  • 35
1 vote
0 answers
72 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?
pindumb's user avatar
  • 25
0 votes
1 answer
288 views

CAML to query a recurrent event - SP 2010

I´m using SP CAML Query Helper Online fot getting all the elements of a recurrent event but it only get the general recurrent event. there is possible to get all the days of this recurrent event in ...
Sebastián A's user avatar
0 votes
1 answer
112 views

CSOM request sometimes works, sometimes fails

I try to modify the value of some fields in a list with CSOM on a button click. Here is the script I call in the html: $("#palettebutton").click(function(){ getItemsToBeUpdated(); }); ...
Jey10's user avatar
  • 424
6 votes
3 answers
996 views

Multiple Lookup Columns return no items CAML Query SharePoint Views

I have a document library that has reached it's 5000 view limit and I'm trying to retrospectively create views on indexed lookup columns. I can successfully return views that are customised in ...
GrantMcW's user avatar
  • 411
2 votes
1 answer
296 views

Union Multiple Lists with Client JavaScript Object Model

I have several SP 2010 lists with the exact same columns. I would like to perform a union on the lists and display a filtered subset from this union. I tried doing it using a joined datasource in SP ...
JimShelley's user avatar
0 votes
0 answers
168 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 ...
Morten K's user avatar
  • 1,229
0 votes
1 answer
1k views

SP07 - How to get SPListItem Author and Last Editor

I want to get author and editor on SP ListItem: With this Page_load Code : SPQuery myQuery = new SPQuery(); myQuery.Query = "<Where><Eq><FieldRef Name='ID'/><Value Type='Text'&...
Goshky's user avatar
  • 2,058
4 votes
2 answers
24k views

Getting this error: An entry without a type name was found, but no expected type was specified

I am new to sharepoint.I am getting below error on ajax call i dont know where it is occuring. "{\"error\":{\"code\":\"-1, Microsoft.SharePoint.Client.InvalidClientQueryException\",\"message\":{\"lang\...
user2602635's user avatar
0 votes
1 answer
3k views

Can't make a caml query works for a boolean

I try to take the elemtens in a list where the field "Mise à jour parc" is set to "No" with the boolean type. My field 'Mise à jour parc" has for db name for sharepoint "...
Jey10's user avatar
  • 424
1 vote
1 answer
538 views

Empty CAML Query recursively search through document sets

I want to search for every single item within a document library. This is working just fine, but isn't working if the files within a document set in that library. I'm using an empty CAML query ...
user3519261's user avatar
2 votes
2 answers
539 views

SP - CAML Query with three AND operators

I have a CAML Query with range between two dates and one text from DropDownList. Where I'm wrong in this query: myquery.Query = " <Where> <And> <FieldRef Name='...
Goshky's user avatar
  • 2,058
4 votes
1 answer
16k views

CAML Query to retrieve list item by title

I'm trying to query for only this the item called Test1. I'm using this caml query but I'm returning all items in the list for some reason. private static int GetlookUpId(List hrLookupList, string ...
user3519261's user avatar
0 votes
1 answer
120 views

Retrieve all List items in library caml

I have reference to a document library. I want to now create a CAML to pull out every item contained within this document library. I can't seem to figure out the CAML in which to do this. Every CAML ...
user3519261's user avatar
1 vote
2 answers
3k views

Select 5 items with caml beginning at the fifth row

I can get the 5 first items of a list with caml : var collListItemToBeUpdated = ""; var listItemToBeUpdated = ""; var enumerator; function getItemsToBeUpdated2() //this function ...
Jey10's user avatar
  • 424
3 votes
1 answer
5k views

camlQuery rowlimit not working on a list

I'm trying to update some elements in a list with client object and caml query. It's working, my values are updated, but for all the items (around 15) even I have a rowlimit of 5 : var ...
Jey10's user avatar
  • 424
0 votes
2 answers
359 views

SP07 - CAML Query between two dates

I have two datetimeControllers : DateTimeControl dtFrom = new DateTimeControl(); dtFrom.ID = "startDate"; DateTimeControl dtTo = new DateTimeControl(); dtTo.ID = "endDate"; I want to get ...
Goshky's user avatar
  • 2,058
2 votes
1 answer
1k views

Sharepoint Online REST api CAML query not returning file related columns

I'm trying to query a document list from a SharePoint Online server using REST API. I have to use CAML, otherwise filtering is not possible on the taxonomy field as far as I know. Below is the ...
bitwise's user avatar
  • 21
2 votes
1 answer
846 views

CAML OrderBy on Choice Field

I'm trying to return a list and order it by a choice field. My choice field currently is just set to Yes or No. The XML I'm using: <View><Query><OrderBy><FieldRef Name="...
MPJ's user avatar
  • 23
1 vote
1 answer
397 views

Query for spaces in values

I'm trying to filter a large list to pull out any values that have trailing or leading spaces using a powershell script. I can do it using a where-object command ($items| ? {$_["field"].StartsWith(' ')...
steam23's user avatar
  • 72
1 vote
3 answers
471 views

SharePoint - CAML query where check TextBox for existing "User Name"

I need to make query in SharePoint WebPart with VisualStudio. I have list "Employees" and need to check this list for existing UserName! <tr> <td class="auto-style1">...
Goshky's user avatar
  • 2,058
1 vote
3 answers
1k views

CAML Query with AND OR

I'm struggling to get a simple query working and would appreciate any assistance in pointing out my error/s. I need to return all "Chart Type" that equal "Jacket" for "2016" in both "Mar" and "Feb". ...
uint32's user avatar
  • 94
0 votes
2 answers
144 views

CSOM not retreiving count of items in a list

I'm trying to get a count of specific items in a SharePoint 2010 list but I keep getting a count of ALL the items in the list. Here is my code: var clientContext = null; var web = null; ...
JimShelley's user avatar
0 votes
1 answer
528 views

List join via CAML with SharePoint Designer for HTML View

is it possible to make a Join over multiple Lists with a CAML query like in C# oder JSOM and show that view on a SharePoint page? I'm using Sharepoint Designer 2013 and Sharepoint 2013. I have the ...
benge's user avatar
  • 43
0 votes
1 answer
629 views

How to join two sharepoint list data using CAML or LINQ?

I have two lists: Doctors DoctorDetails In list #2 I have a lookup from list #1 i.e. on Doctor Name. Now I want to fetch data on the basis of doctor name as filter from both lists. How can I ...
Mohammed Faisal Khan's user avatar
3 votes
2 answers
11k views

CAML query for filtering list view

I have a SharePoint list that I need to filter according to this: First of all, the items must be Booked by = Travel and Meeting Support and the Category should never be visible if they are Cancelled....
Jenny Fergéus's user avatar
0 votes
1 answer
573 views

REST getItems with CAML for proper managed metadata labels

I'm using REST to retrieve some information from a document library. There are some managed metadata fields attached to the items I'm returning. I've found that if the managed metadata column is a ...
Rothrock's user avatar
  • 3,010
1 vote
1 answer
635 views

Need CAML query LookupMulti column help, Is it possible?

I am trying to create a CAML query for querying list, here is my problem. There are a list Employees and it has a LookupMulti column for Hobbies. I want to get all Employees who have selected Reading ...
Nikhil Chavan's user avatar
3 votes
3 answers
5k views

CSOM get document by ID

I'm using the following CSOM code to retrieve a document title by id: ClientContext context = new ClientContext("http://sharepoint"); List oList = context.Web.Lists.GetByTitle("Documents"); ...
Citizen SP's user avatar
  • 1,752
1 vote
0 answers
29 views

FeatureUpgrading - Providing an updated schema.xml file possible? [duplicate]

I've read a lot now about the FeatureUpgrading method. But I'm still asking myself, if I could provide an updated list definition (schema.xml) file in the ElementManifests. There are new views in this ...
dns_nx's user avatar
  • 181
0 votes
1 answer
1k views

How can you get results from a SharePoint document library (with folder and child items) in a SSRS report?

I have a SSRS report that uses a SharePoint document library as a data source. The issue is that the list has folder and in those folders are child items. The dataset is only returning items from the ...
mfoy_'s user avatar
  • 124
0 votes
1 answer
264 views

Join 3 lists initiating the join from the middle list

I need to join 3 Lists, but i have no access to the on-prem sharepoint to test my idea right now. So I hope anybody can tell me, if it's possible. I have Lists A, B and C. LookupFields are connected ...
Beh's user avatar
  • 1
0 votes
1 answer
157 views

Executing multiple REST queries without error

I've pulled the following example of a REST Query from the SharePoint 2010 Documentation. It's working well except when I try to run multiple queries at once by renaming the functions: ...
sansSpoon's user avatar
  • 476
1 vote
1 answer
68 views

How can I move ONE document to another library without looping an entire collection?

Currently I'm looping through all the files in a collection, which is every single document in the library. Once I find the unique document name, I move it. I'm trying to getting away from looping ...
jpollar's user avatar
  • 1,107
3 votes
1 answer
1k views

SP2013 use Rest with CAML query and expand lookup column

I'm trying to query a sharepoint list that contains lookup columns and taxonomyfields. When I use the $expand option I can't expand taxonomyfields, but when I use a camlquery i can't expand lookup ...
Marco's user avatar
  • 141
2 votes
2 answers
162 views

CAML Query Where (x AND y) OR Z

I've been struggling with this all day. I've referenced several SO questions/answers but to no avail. Not quite sure what I'm doing wrong. I also cannot use a CAML Builder, unfortunately, due to some ...
mike's user avatar
  • 21
6 votes
3 answers
7k views

Query multiple lists using javascript/CSOM

I'm about to query multiple lists using JavaScript (JSOM, SharePoint 2010). It's working when querying one list in a time, but that's annoying when I'm having lots of lists. Working example: ...
kolback's user avatar
  • 279

1
3 4
5
6 7
11