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
23 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 ...
1
vote
1answer
52 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
41 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 ...
1
vote
2answers
31 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
0answers
27 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 ...
0
votes
1answer
39 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
44 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
34 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
123 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
36 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" ...
1
vote
1answer
49 views

Parsing a CAML query in C#

I have a SharePoint 2010 solution with a custom web part. I am using C# in Visual Studio 2012. The user has selected a view from a list, which I am storing as an SPView object, mobjView. I want to ...
1
vote
0answers
26 views

Timeout using SPsite object and U2U Caml query

We have 2 collection. 1 is test and other is production environment. In test collection, I'm writing console application which is using SPSite and SPWeb objects. But it takes nearly 40minutes to get ...
1
vote
1answer
47 views

CAML query filter with period (.) not working

I am using SPQuery object and SharePoint list item having period inside its title field value. I tried many ways but no luck. Is it correct that CAML query filter not works with Period? OR I made any ...
1
vote
1answer
58 views

How to build a CAML query with several nested OR's using a loop

I'm new to SharePoint development and I need your help to solve this issue.I've created a CAMLQuery builder class. public class CAMLQueryBuilder { #region Builder part public static string ...
2
votes
1answer
50 views

GroupBy site name inside my CAML query

I wrote the following CAML query to be used inside my Content Query Web part, but i am not sure if i can define to Group the retrieved item by site name :- <property name="QueryOverride" ...
0
votes
0answers
36 views

CAML Query using <In> element breaks after >60 values are placed inside

The following CAML Query works on my list that has over 5,000 items because the Title field is indexed: <View Scope="RecursiveAll"> <ViewFields> <FieldRef Name="Editor" /> ...
2
votes
1answer
66 views

Sharepoint 2010 And Angularjs

I am building an application in AngularJs (Front End). I would like to make it Dynamic using $route etc. The back end consists of a SharePoint 2010 Server with Categories, Look Ups, etc. I have been ...
1
vote
1answer
61 views

Fetch list item if specific column is modified using caml query

I need to fetch item from SharePoint list using CAML query, if specific column is modified. How to achieve this?
9
votes
4answers
6k views

Caml to get today's birthdays

I have a list with birthday field (DateTime). How do I write caml query to retrieve only the records where birthday falls on today (i.e. only comparing day and month value of birthday column to ...
0
votes
1answer
69 views

CAML Query Builder for app web (add-in web)

I am trying to generate a query using U2U CAML Query Builder for a list on an app web (add-in web). When I try to connect using credentials of the current user, which can connect to app web in the UI, ...
2
votes
3answers
805 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 ...
5
votes
1answer
57 views

CAMLQuery Comparison

I'm trying to perform a CAML Query test and display the results. For example I'll be using two columns in a list; one called StartDate another called EndDate. Currently, I've a CAML Query that ...
4
votes
2answers
1k views

How do I get list items' attached files with CAML via REST API?

I'm retrieving items from a list. The list contains entries which have attachments. Can I modify my query to include the attachment URLs? What's the most efficient way of doing this? <View> ...
2
votes
2answers
64 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 ...
2
votes
1answer
69 views

Lookup column value not updated - ListsWebServices and Asp.NET

I am having trouble inserting new record in "Clients" list on our server, I am in learning phase for working with SharePoint Lists Web Services and I am trying to insert a new item in a list which ...
1
vote
0answers
64 views

CAML query results multiple row for people picker field with multiple value in SharePoint webservices

Below is the SharePoint web service I am using to get list items from a SharePoint 2007 calendar list. The calendar list has a people picker field which can have more than one user. Now as I run the ...
3
votes
1answer
6k views

CAML and External List - pass parameter to ReadList (finder) method

I have a Finder method defined on an External Content type (created with Visual Studio). Whan That method receives a parameter. So the method is something like ReadList(string partnerName). I have ...
4
votes
1answer
3k views

Help converting XmlNode to DataSet/DataTable, from SharePoint Web Services, Lists.asmx

This is my first post here, but used this site a lot :) My question is how I can convert an XmlNode, obtained through the Lists.asmx SharePoint web service, to a DataSet / DataTable. The reason I ...
1
vote
3answers
88 views

Item Count using CAML Query in sharepoint

I have retrieved item count for particular field values in my list using CAML Query. But when I try to add up all those counts it's not getting added, infact it is getting appended. For example, my ...
0
votes
2answers
636 views

How to get week birthdays

I have a list called Profile, and this list contains the Birthday field of type DateTime. I created two fields of type calculated, one gets the day, and the other gets the birthday month of field. And ...
2
votes
3answers
15k views

CAML query on Sharepoint List without duplicates

How can I retrieve all elements in a List ignoring duplicate entries So if List A contains: Employee A Employee A Employee B Employee B Employee C Employee D Employee E I want to get ...
1
vote
0answers
52 views

Powershell Query - Columns are missing While selecting Items from List

I am trying to get records from Office 365 SharePoint list using Powershell Script, through "Microsoft.SharePoint.Client.CamlQuery" query. It fetches all the items and the values. However, there are ...
1
vote
5answers
5k views

Filter list data using SPServices, CAML Query, and dropdown list

I'm trying to create a table using SPServices to fetch the data, and filter it using CAML Query and a drop down list. I would like to create three conditions: A. If no item from the list is selected, ...
1
vote
2answers
285 views

Use spservices to run CAML query filter on Single Dropdown

In my page I have two dropdowns, the second one depends on the choice of the first and this works, and the CAML query works, too. How can I use $().SPServices.SPCascadeDropdowns to run a CAML query ...
2
votes
0answers
60 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 ...
0
votes
2answers
183 views

caml query for filtered lookup column

My project uses the 2010 version of the Sharepoint Filtered Lookup Field, which has the option to filter a column using a caml query. So I have three lists: Categories, SubCategories and MainList. ...
0
votes
0answers
29 views

Providing a custom QueryOverride + Group items by <site> is not working together inside my Content Query web part

I am working on a Team site collection inside my SharePoint 2013. And I added a Content Query web part, and I define to Group the items by the Site:- And I got the following result which is ...
0
votes
0answers
43 views

CAML query is returning extra items that are not part of the filters

I am working on a Team site collection inside SharePoint server 2013. now inside the team site collection i have 5 subsites, and i want to return list items from the subsites that have the following ...
2
votes
1answer
36 views

Performance with query that filters on document path

My CAML Query on a large Pages library based on a folder structure takes too long (15-20 seconds), and I wonder how I could optimize this. I currently use a filter where FileRef BeginsWith [specific ...
1
vote
1answer
164 views

How to specify a CAML Query to return items that have any of two site columns?

I want to define a query to return items that satisfy the following :- if any item have a CT & login user = site column so i wrote the following :- <property name="QueryOverride" ...
1
vote
1answer
197 views

Why doesn't CAML Query Get Data from a Column Name?

I have a custom list which I am pulling data from using JavaScript. However for some reason it does not pick up two columns when I call them by their name. I have to use ...
0
votes
1answer
61 views

FieldLookupValue fails conversion

Setup 2 lists, linked by a lookup in one of the lists CamlQuery to get items together with fields from other list (projectedfields) Problem When I retreive the listitems with the CAMLQuery, it ...
1
vote
0answers
28 views

Why isn't CAML Query Getting Data from a Column?

I have a custom list which I am pulling data from using JavaScript. However for some reason it does not pick up two columns when I call them by their name. I have to use ...
5
votes
1answer
150 views

Ignore Null Values in OrderBy Asc While creating CAML Query

I have 3 Columns in my List Id Name SortBy 1 A 1 2 B 3 C 2 4 D 3 and my CAML query is : Query = @"<OrderBy><FieldRef Name='SortOrder' Ascending='False' ...
2
votes
1answer
1k views

How to query the list using CAML Query to List's multi allow user field?

I have a list in which there is one column which is of type People or Group with multi allow. I have created Item Adding event receiver in which I am checking the entered people value is already ...
0
votes
1answer
232 views

CAML query for 'FileRef' does not return relative path

I'm having trouble retrieving the relative path of a file using CAML: ...
0
votes
0answers
32 views

Folders first in paged results using CamlQuery and ListItemCollectionPosition

I'm implementing paging using CamlQuery and ListItemCollection, sorting results by the name field. I would like folders to come first, as they do in UI, e.g. "folder A2, folder B2, file A1, file B1", ...
3
votes
2answers
147 views

search on (google like) SharePoint document library

I have been making a CAML query search webpart, which already provides the cascaded search on the documents through out the directory using CAML on Columns as metadata to search. For now I have the ...
0
votes
1answer
106 views

JSOM caml query always returns undefined

As the title says, I have a caml query that is invoked through JSOM code which always returns an empty collection. I am querying the list based on two columns: One being of type User and the other of ...