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

1
vote
1answer
107 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
1answer
63 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
30 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 ...
9
votes
5answers
39k 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
69 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
77 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
316 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.
3
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(); ...
1
vote
1answer
202 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 ...
1
vote
2answers
93 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 Name='...
0
votes
1answer
55 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
74 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
38 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
39 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
95 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
55 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
39 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
93 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
274 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 (DOCLINK.GIF),...
0
votes
1answer
75 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
38 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
75 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
41 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
392 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
160 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=" + field....
0
votes
0answers
58 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(); camlQuery.set_viewXml("<Query>...
2
votes
1answer
68 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
31 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") . ...
1
vote
1answer
551 views

CAML query - examine Contents column used in freetext predicate

In my query I use the freetext predicate: and freetext(Contents, 'my search string') I'm getting some unexpected results from this search, namely the documents contain no relevant content, yet are ...
0
votes
1answer
60 views

SharePoint notification

I am trying to make a dynamic notification field which shows the number of for example not approved items in a list. But this needs to be shown always, wherever I am in SP. It should look like: ...
1
vote
1answer
96 views

Filter out hidden folder using client object model in SharePoint 2010 / 2013

I need to do the same thing as on this thread: Filter out hidden folder using client object model in sharepoint 2013 However my code needs to run on SharePoint 2010 and Sharepoint 2013. I'm using the ...
3
votes
2answers
18k views

How to use GroupBy in CAML query

I have simple list, consisting of 2 columns - Date, Order. Now what I want to do, is to GroupBy Date and count orders. So, for example if I have following items Date Order 08/10/2012 5 08/...
0
votes
4answers
136 views

User-type fields in CamlQuery ViewFields return null

I am trying to return several User-type fields from SharePoint 2013 like this: using (var clientContext = new ClientContext(myUrl)) { var list = clientContext.Web.Lists.GetByTitle(listName); ...
0
votes
0answers
42 views

SharePoint 2013 Filtering with CAML Query in a Knockout List

Thanks in advance; having some trouble here. I have a List Called 'Projects' that uses binding via Knockout View and View Modal based on SP Services. I am new to Knockout, and I'm having difficulty ...
0
votes
0answers
52 views

Caml Query for dynamic SP custom list filter

Good day, I need to make a custom dropdown for filtering a list view. I made a dropdown by adding a content editor in the view and just added a <select> dropdown. Now when I open SPD and edit ...
0
votes
1answer
55 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 ...
2
votes
2answers
82 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....
0
votes
2answers
1k views

Limit data returned by GetListItems of Lists.asmx service with CAML

I want to limit data returned by GetListItems of Lists.asmx service. Does anyone know why despite the query options below I get all items? "<GetListItems xmlns=\"http://schemas.microsoft.com/...
1
vote
1answer
44 views

Get the items in descending order using caml query

i am trying to get the comments from Comment List in a 'Descending' order , the query that i am using is : "<Where>" + "<Eq>" + "<FieldRef Name='TopicID' /><Value Type='...
1
vote
1answer
81 views

CAML query with OR returns no result, where single part of it returns results

I have a CAML query which queries 2 multi taxonomy (managed metadata) fields. I use the IN operator for this. The query should return items where in one of the fields a match was found, so either in ...
1
vote
1answer
61 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 is a list Employees and it has a LookupMulti column for Hobbies. I want to get all Employees who have selected Reading ...
1
vote
2answers
1k views

Retrieve List items using CAML Query

I have a list which contains 3 columns -ID, TicketState and EndDate ID TicketState EndDate(DD-MM-YYYY) 1 Open 10/10/2012 2 Closed 01/12/...
1
vote
2answers
41 views

Better logic to create CAML queries

Assume i have 3 checkboxes in my webpart Properties. Checkboxes are for selecting categories. In my SharePoint list i have multichoice column called category and values in it are CAT1,CAT2 and CAT3 ...
0
votes
1answer
57 views

Access Denied when executing a CAML query

I am running a SharePoint Online provider-hosted app, and via CSOM, I am loading the contents of a list with the following code: var items = List.GetItems(CamlQuery.CreateAllItemsQuery()); ...
3
votes
0answers
48 views

Efficient way to Query Large lists to get little data

I am querying a large list with around 25000 items but the data returned is quite small, like 20 items top. Can you please let me know the best practices to do so, for e.g. orderby Indexed column. I ...
0
votes
1answer
43 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 ...
0
votes
3answers
214 views

Use REST API with CAML query to fetch the files inside multiple folders in single REST Call

I have a scenario where i would like to fetch all the files from multiple folders using REST API. I would like to filter the data in such a way so i can ignore the folders and fetch only the files ...
0
votes
2answers
44 views

Nested AND OR inside my Content Query web part's CAML query is not working well

I added a content query web part to my team site collection, then i export it , and i modified the QueryOverride tag as follow:- <OrderBy><FieldRef Name="Created" Ascending="FALSE"/></...