An XML-based language that is used to build and customize Web sites based on SharePoint Team Services from Microsoft.

learn more… | top users | synonyms

0
votes
1answer
5 views

CAML Query Validator

Is it possible to validate a CAML query (to check whether it is correctly formed or not) before executing it in SharePoint? Otherwise, while executing the CAML query, it gives weird errors, which ...
0
votes
2answers
17 views

CAML get child folders count

I want to query all folders from a document library and I am using following query <Where> <Eq> <FieldRef Name="ContentType" /> <Value ...
2
votes
5answers
9k views

CAML Query Filtering with OffsetDays

I'd like to set up a CAML query in a Data View Web Part (DVWP) that works like this: If a date is not specified on the Query String, then show me items created in the last 30 days If a date is ...
0
votes
1answer
21 views

caml query pass username dynamically in sharepoint hosted app

In my hosted app I have one text field which contains username. I have write following query in lists schema.xml <View> <Query> <Where> <Contains> ...
1
vote
1answer
28 views

Retrieve the Item ID from the Task List Related Item column

Using JSOM, I getting all the task details which are not started. Using CAML query i got all the column values including related item column from Task list var relateditm = ...
2
votes
2answers
107 views

CAML query to filter Datetime

I have to filter data with respect to a field named CreatedDate having type datetime. In input I'm just giving date (not time), I want to fetch all records with respect to specific date (ignoring ...
1
vote
1answer
26 views

caml query for text field(Title field) contains username in SharePoint hosted app

In my hosted app I have one text field which contains username. I want to apply filter on a view which on filtering gives me data related to current user. <Field ...
1
vote
1answer
30 views

Iterating SPList.GetItems(SPQuery) very slow and times out

I have a SharePoint 2013 Custom List. It has 3 MMS columns, 3 User Columns and 3 or 4 DateTime columns and a Choice Column and 1 or 2 columns of type Text. This list currently has around 2000 items. I ...
2
votes
3answers
848 views

Need a way to identify files which have no checked in version

I wrote a script that traverses a collection, it's document libraries and gets a list of all files. I'm trying to find all the documents which do not have a checked in version and require a user to go ...
1
vote
2answers
2k views

How to get List Item from sharepoint list based on ItemID

Dynamically I am adding RadGrid to the page. I need to retrieve list item from the SharePoint list. Say I have 10000 items in the list using SPQuery, I will get filtered records as 2000 items. Here is ...
5
votes
3answers
3k views

How to get caml query to return list items created by the current user?

I want a caml query that only retrieves items created by the user currently logged in. I tried this specifier = "<Eq><FieldRef Name='AssignedTo'/><Value ...
0
votes
1answer
28 views

Convert CAML queries to OData Filters

Is it possible to convert complex CAML query to OData filters so that I can use them in REST APIs? Some CAML queries have nested condition and multiple values to be passed in IN operator. Also, ...
0
votes
0answers
20 views

Make this code to Asynchronous to Synchronous call in Javascript using for loop [duplicate]

I am having values in result[15452,33616] when using for loop ,The for loop for i=0 it takes the value of result[0]=15452 ,it is not going to async function.The loop continuing ,after loop over only ...
-1
votes
2answers
49 views

executeQueryAsync function calling not working using for loop

I am having values in result[15452,33616] when using for loop ,the async function taking only last array value (e.g-33616) and fetching the data for that pushing to another array and final push into ...
0
votes
1answer
16 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 ...
2
votes
2answers
66 views

Calendar List - CAML Query Next Two Events

I need to create a CAML query to obtain the following two events from a SharePoint 2010 calendar: To consider: There may be recurring events And exceptions to events The purpose is to show in a ...
1
vote
1answer
57 views

Keep the same ID on an item copied from another list

Environment : Foundation 2010 I have two helpdesk lists. In List A, the user create the item and an ID is automatically assigned. My workflow is used to copy that item in the list B. However IDs are ...
0
votes
2answers
1k views

How to change a date format in CAML

I got a wrong date format to a CAML. I have got (yyyy-mm-dd) and must to be understand by CAML to the format(dd-mm-yyyy), how can I do this. I tried by String.Format("{0:yyyy-mm-dd}", dateISO1);, but ...
0
votes
1answer
35 views

Can't get filename of document with REST api/CAML query

Using the rest api to retrieve information about my documents. The documents use managed metadata which isn't expanded correctly when using the stand REST api. So I found this fix which uses REST with ...
0
votes
0answers
13 views

Get Blog Posts By Category (Filter blog post by PostCategoryId)

I Am trying to get filter blog post by category but get an error I suspect its because I am not using the PostCategoryId internal name? but i dont know how to find what this internal name is ...
0
votes
1answer
580 views

ExecuteQueryAsync not following through to the success/failure function, javascript

I've got a function that checks if a list item (setting) is true and then changes the setting which it does correctly but doesn't execute the second ExecuteQueryAsync functions. In debugging it jumps ...
2
votes
1answer
1k views

SPServices Autocomplete and dynamic CAML query

I have two Text filter web parts (Project and Customer Name) with Apply Filters button for one list. There is a SPServices.SPAutocomplete on each and it works great. Now, I want to show the values in ...
9
votes
5answers
36k views

Get Items Under Folder CAML

I am trying to retrive all items that are under a certin folder, in a document library. this is what i have so far List DocumentsList = clientContext.Web.Lists.GetByTitle(list); CamlQuery camlQuery ...
0
votes
1answer
34 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 ...
0
votes
0answers
35 views

How to Get Row Count in CAML Query Paging

I have a SharePoint 2013 multi tenant environment with FBA enabled. Multi Tenancy / FBA may not be relevant in this context, but I just want to make sure I give the complete picture of the scenario. I ...
3
votes
3answers
174 views

How to query list with >5000 items in SharePoint Online?

I want to query a list in SharePoint Online which has >5000 items. How can I do it? Right now it is showing me thresh hold limit error when I am trying to query the list.
2
votes
3answers
2k views

Caml query to get the next event from calendar

I'm facing a problem building a caml query for the calendar list. Here is my caml query SPQuery query = new SPQuery(); StringBuilder sb = new StringBuilder(); ...
2
votes
1answer
2k views

ProjectedFields working in SPQuery but not in the View

I've three lists: Competitions, Works and WorksVotes, linked to each other through Lookup fields. WorksVotes list has Lookup field to Works list, and Works list has Lookup field to Competitions list. ...
1
vote
1answer
73 views

CAML query format filter in DateTime column

I need to get the list item created on a particular date. The below caml query doesn't seem to work. It always retuns 0 query.ViewXml = @"<View><Query><Where><Eq><FieldRef ...
0
votes
2answers
65 views

I want to display only Upcoming recurrence events from calendar list

here I tried something but that's not up to the mark objQuery.Query = @"<Where><DateRangesOverlap><FieldRef Name='EventDate' /><FieldRef Name='EndDate' /><FieldRef ...
0
votes
1answer
49 views

SharePoint Online list view threshold

I need to access a list with 40,000 items and populate that data into a csv. How can I do this using caml?
1
vote
2answers
3k views

Using the Now() function in CAML Query?

i am trying to get the 3 most upcoming events from the current date and time (The current data and time refers the time everytime my web part loads. Basically it is not a fixed date and picks up the ...
2
votes
1answer
41 views

Sharepoint CAML IN operator not working with FileDirRef

I want to retrieve a list of file from two folders. When I combine two <Eq><FieldRef Name="FileDirRef" />... with <Or> it works fine. When I want to use the <In> operator it ...
0
votes
2answers
36 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 ...
1
vote
2answers
32 views

Caml String : How to search list by variable (string)

I have been trying to work on this for a few hours and a lot of googling. New to caml queries I simply want to search my list where the variable matches in the column. In sql I would write: sql= ...
1
vote
2answers
70 views

GetItems with CAML against lookup on online throws “list view threshold”-error

I want to query for items where a lookup has a title which contains some text. The list has over 5000 items, but the query result will return fewer, so it should work. This query works, querying for ...
0
votes
0answers
50 views

Multi-conditional CAML Query isn't working with OrderBy tag in SP2013

I have the following CAML query, but when I add an tag, the list breaks. The list is named Requests which contains the following columns: DueDate is a Date/Time column Lifespan is a Calculated ...
0
votes
1answer
35 views

Show top 10 distinct users in Sharepoint 2010 list based on another list

I am having a Sharepoint 2010 site where I'm having a List named UserRank which has columns User of type people & group and Datetime. After each custom email webpart an entry to this list is ...
1
vote
2answers
57 views

CAML Query search exact word in comma separated

I have 2 list items that contains a title field with following string value Item 1 Title : apple,blackgreen Item 2 Title : apple,black I want to query the list item if comma separated word in the ...
2
votes
3answers
152 views

CSOM - CAML : Get document icon

I was using JSLink to change the display of a documents webpart. I was retrieving the document icon url set by Sharepoint for a document library item like this: (it can be shortcut icon ...
0
votes
1answer
36 views

Retrieve all Comments by UserId in Discussion Board

It try retrieving all Comments from a single person inside a discussion board. This is the CAML: <View> <QueryOptions><ViewAttributes Scope='RecursiveAll' /></QueryOptions> ...
0
votes
0answers
34 views

CAML Query Help - Sorting By Month within a UTC Date Field

Current Query: <Query> <Where> <Eq> <FieldRef Name='Active'/><Value Type='Integer'>1</Value> <Eq> </Where> ...
0
votes
0answers
21 views

Joining 3 lists does not returns any values. If one List is empty

I am using the following article to join 3 lists https://edanan.wordpress.com/2012/04/28/sample-caml-joins-for-more-than-2-lists/ Here I have got 3 lists(Country,city,client) City is having a ...
1
vote
1answer
46 views

Export CAML query data into Excel

I am using JSOM to fetch the data from sharepoint list and binding into html table from JS file .And I would like to export the query(CAML Query) data into Excel,Can anyone help me how can I do ...
1
vote
3answers
35 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". ...
1
vote
4answers
163 views

How to pass a string(date) in a caml query to get listitem based on datetime type of field

I want to pass a string(date) in a caml query to get listitem based on datetime type of field. I am not getting any value in return. Please suggest. Below is my code: ` private SP.ListItem ...
0
votes
0answers
88 views

How to pass multi choice(checkbox) values in a caml query to fetch item from sharepoint list in o365

Below is my code: SP.ListItem listItem = null; CamlQuery camlQuery = new CamlQuery(); camlQuery.ViewXml = @"<View><Query><Where><BeginsWith><FieldRef Name=" + ...
0
votes
0answers
26 views

Caml query on large list fails filtering on indexed column

I've got a large list that has the TicketId field indexed. Using JSOM, I do this: var cntx = SP.ClientContext.get_current(); var camlQuery = new SP.CamlQuery(); ...
2
votes
1answer
46 views

SharePoint 2013 SOAP Request with GetItems fails with NullReferenceException

I'm pretty lost here. I've inherited legacy code which uses SOAP to fetch SharePoint content. One method posts a SOAP request against SharePoint to get the HasUniqueRoleAssignments property of list ...
0
votes
1answer
29 views

Fetch the data from Date and Time Calculated column

I am trying to fetch the result from list based on 3 conditions( Month Name,Employee,Department). In my SharePoint List(Month Name is calculated column fetching month from column "Joining Date") . ...