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
0answers
42 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
44 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
64 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....
1
vote
1answer
32 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
68 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
54 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
38 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
32 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
50 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
46 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
40 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 ...
1
vote
1answer
67 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
35 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
48 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 ...
0
votes
0answers
43 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
93 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 ...
0
votes
3answers
183 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 ...
1
vote
1answer
97 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?
1
vote
1answer
61 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 ...
0
votes
1answer
89 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, ...
5
votes
1answer
58 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 ...
2
votes
2answers
67 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
84 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
96 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 ...
1
vote
0answers
55 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
2answers
423 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 ...
0
votes
2answers
43 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"/></...
2
votes
1answer
61 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" type="...
2
votes
0answers
75 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
244 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
33 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 correct,...
1
vote
3answers
102 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
0answers
45 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
38 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
255 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" type="...
1
vote
1answer
257 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 console.log(collListItem....
1
vote
0answers
31 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 console.log(collListItem....
5
votes
1answer
173 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' /&...
0
votes
1answer
315 views

CAML query for 'FileRef' does not return relative path

I'm having trouble retrieving the relative path of a file using CAML: http://[siteURL]/_api/web/lists/GetByTitle('test')/GetItems(query=@v1)?@v1={"ViewXml":"<View><ViewFields><FieldRef%...
0
votes
0answers
39 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", ...
0
votes
1answer
158 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 ...
1
vote
1answer
124 views

Sharepoint List Threshold even when returning less then 5000 records

I work for a company that creates software that interfaces with Sharepoint using Web Services. We have run into an issue at a few clients where we are hitting the threshold limit on document ...
1
vote
1answer
39 views

CAML query with Float is not returning expected results - what am I doing wrong?

I've using SP CAML Query Helper 2013 <Query> <Where> <Geq> <FieldRef Name="Score"></FieldRef> <Value Type="Float">1000</Value> </Geq&...
4
votes
3answers
524 views

How can I get two List Items using one Caml Query?

I need to get data from two customs lists that I created. However only the first list item is queried allowing me to use the data in the Home Page list item only, but I need both. var listItems; var ...
0
votes
1answer
122 views

CSOM CAML query returning every item in the list

I'm trying to retrieve a list of items where some conditions are applied but when I run my web page it returns all records. basically this query checks whether any record with these conditions exist ...
3
votes
0answers
53 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> ...
1
vote
1answer
98 views

Retrieve a list column value only if it has a value with CAML-query [duplicate]

I wonder if someone can help me with a caml-query. I want to retreive list items from different list that has the column name "Link". But it should only retreive if the column has a value. How can I ...
0
votes
1answer
39 views

Cant retreive a list column

I am creating a hosted app in SharePoint. I want to retreive all the custom list from SharePoint and then from the custom lists I want to fetch column values. I got 2 columns with the names title and ...
0
votes
1answer
141 views

How to query current user created items?

I have many lists in SharePoint site. I want to retreive all the items from the list and display on a site. The current user should only see his/her created items not other users items from the lists. ...
0
votes
2answers
83 views

How to get all the list and the items that are in the lists?

Is it possible to retreive all the items from different list in SharePoint? I know how to retreive list items from 1 list but not multiple lists. var mylist = this.web.get_lists().getByTitle('...