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

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 ...
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
67 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
63 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
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
2answers
277 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
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" ...
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" ...
2
votes
0answers
54 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
178 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 ...
1
vote
3answers
87 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
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
159 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
194 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 ...
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
149 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
225 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
31 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
102 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
105 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
33 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> ...
4
votes
3answers
416 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
105 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
47 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
81 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
37 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
107 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
79 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 = ...
0
votes
1answer
52 views

How to query only custom list?

Is it posible to query only custom list? In SharePoint you can add different type of list i.e tasks, contacts etc. I want to retrieve all items that the current user has created only if the items are ...
4
votes
3answers
371 views

How to retrieve list hyperlink field values?

I know how to retrieve items like Title etc. I can query the columns and fetch data. But it doesnt show the hyperlinks. Appreciate if someone can help me out! getListItem.get_item('Link').get_url(); ...
1
vote
0answers
93 views

Custom Workflow History page

I'm building a custom workflow history page which shows the history of workflow steps that we're executed (much the same like the original wrkstat.aspx page). The reason why I'm building it, is ...
1
vote
1answer
287 views

Javascript running before SPServices call is complete

Note: I am a beginner and new to SharePoint and not a regular with SharePoint based projects. Kindly refer commented out code only if needed. I am building a sample page and displaying it on ...
-2
votes
1answer
108 views

camlquery to get all link to document in library

As explian in the title i need a camlquery to retrieve all "link to document" inside a library. Are there a way to do this? For know in my camlquery i'm looking in fileleafref field if contains ...
0
votes
1answer
153 views

Run CAML Query on DataTable SharePoint

I have a DataTable having Some rows. Is there any way to execute CAML Query on it. Or Alternatively, How can I convert this DataTable into a SPList so tha CAML can be executed on SPList. private ...
0
votes
4answers
106 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); ...
1
vote
0answers
40 views

CAML, how to get Fields which are having Unique condition

I am trying to get the field info of a list and I need to also know whether the field has Enforce unique values: as true. IEnumerable<List> lists = clientContext.LoadQuery( lists.Include(list ...
2
votes
1answer
51 views

Query by contenttype with inheritance

Lets say we have 2 contenttypes: LanguageItem (inherits from item) News (inherits from LanguageItem) I have a list with contenttype set to "News", including some items. Is it possible to create a ...
1
vote
2answers
89 views

Do anyone know how to get item with most characters from a SP list using CAML query?

Do anyone know how to get item with most characters from a SP list using CAML query?
0
votes
1answer
81 views

CAML Query Helper to retrieve Announcements List

Consider this as my code to retrieve an Announcements List from SharePoint 2010 site: <Query> <Where> <Or> <Or> <Eq> <FieldRef ...
3
votes
2answers
163 views

Character escaping in CAML query (REST call)

I use JS to create a CAML query. When it is generated, it looks like this: @v1 = {"ViewXml":"<View Scope='RecursiveAll'><ViewFields><FieldRef Name='ID'/><FieldRef ...
3
votes
2answers
145 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
51 views

Duplicate records while sorting list descending

I have implemeted a button which loads more data from list. The page size is 12. Everytime I click button I get 12 records. The query works fine if I use Ascending = True but when I change to ...
0
votes
1answer
60 views

CAML query with In operator

I'm trying to use CAML query with In operator since it's easyer to build then Or conditions. Here is my CAML <View Scope="RecursiveAll"> <Query> <Where> <In> <FieldRef ...
0
votes
1answer
54 views

CAML Query for item where one value is the maximum and another is not null

What I am trying to do is fetch a single list item that has the highest ID, but also has a value in the Shelf field. Below is my query, which I am pretty sure I formatted correctly. <View> ...
1
vote
1answer
728 views

How to paging with caml query

I have 10 items with ID from 1 to 10 and set order by on Created field Ascending='FALSE'. Row Limit is 3. I use SPListItemCollectionPosition for pagination to limit the number of returned items. First ...
0
votes
1answer
205 views

CAML Query for DateTime field with “In” element

I have a dynamic CAML builder which I built to generate queries like the following: <View Scope="RecursiveAll"> <ViewFields> <FieldRef Name="Editor" /> <FieldRef ...
0
votes
1answer
35 views

Document Library Attachment Retrieval. LINQ vs CAML

In a particular project I am required to retrieve corresponding attachments to a request submitted by a user. On one page the live requests are displayed with links to the attachments. The project ...
1
vote
1answer
155 views

GetListItems returns no items when filtering by lookup columns

I am using the SP Lists service, the GetListItems method as follows (guidView is set to the "All Items" view): listasSoap.getListItems( guidList, guidView, null, viewFields, "0", null, ...