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
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
37 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
191 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
230 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
64 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
29 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
163 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
273 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
34 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
161 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
134 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
112 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
37 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
460 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
112 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 ...
9
votes
5answers
35k views

How to get current user with javascript?

I have a list . I want select items of list with a special quary.(get items that created with current user). Then get count of items. I use this code for get current user : function Initialize() { ...
0
votes
2answers
3k views

How to get Highest ID using CAML and JQuery

I am using a web service and am trying to return the highest ID number from the Posts list with viewname {B9212691-1AF1-41AF-9DA7-6073ADDB091B}. So far I have the following. <script ...
0
votes
2answers
4k views

SPServices: How would I add Ascending=False to CAML in GetListItems

How would I use SPServices GetListItems and still be able to add Ascending=False to the CAMLViewFields? I haven't used this for long and I am just wondering if this is possible? Thanks as always!
3
votes
0answers
52 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
92 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
38 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 ...
4
votes
2answers
442 views

Adding 2 Caml queries in same executeQueryAsync

Is it possible to use two different queries to get to different lists and use them in the same executeQueryAsync() Something like this : var camlQuery = new SP.CamlQuery(); ...
0
votes
1answer
130 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
82 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
53 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
449 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
100 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 ...
0
votes
3answers
4k views

Current User Task using CAML Qurey

Here's my query to get current user task using CAML but it's not working SPUser me = web.CurrentUser; SPList list = web.Lists["Tasks"]; SPQuery qurey = new SPQuery(); qurey.Query = ...
0
votes
1answer
178 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 ...
1
vote
1answer
329 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
118 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 ...
2
votes
2answers
6k views

Sharepoint REST API - Using caml query and select/expand to get lookup data

I have a Sharepoint app and I use a caml query to filter the data I get back: var caml = "<View><Query><Where><And><Contains><FieldRef Name='PublishingPageLayout' ...
1
vote
1answer
12k views

SPServices - GetListItems - formatting results

I am using SPServices in Sharepoint 2013 to get some results from cutom list named "navigator" presented here: and for this purpose I am using code: <script type="text/javascript" ...
2
votes
1answer
52 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
0answers
42 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 ...
1
vote
3answers
6k views

CAML query retrieve all items from a SharePoint list

I have a JavaScript piece of code that I use to retrieve list item from SharePoint by selected options from drop-down list. Depending the selection it would assign a value to a CAMLQuery variable. ...
1
vote
2answers
90 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
90 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
184 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 ...
0
votes
1answer
53 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
64 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
56 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> ...
3
votes
3answers
1k views

CAML query for sharepoint list not working

I have a CAML query where I am getting records between a date range for a sharepoint 2010 list through an asmx web method call. It looks like this ...
1
vote
1answer
856 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
226 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
37 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
650 views

How to get all checked out files in SharePoint client object model c#?

I need to get all checked out files from a document library. I am trying by following query. CamlQuery camlQuery = new CamlQuery(); camlQuery.ViewXml = @ "<View> <Query> ...
1
vote
1answer
176 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, ...
0
votes
0answers
254 views

Error : “Value does not fall within the expected range.” while using JOIN in CAML query

Here is my code: SPList list = web.Lists["List1"]; SPQuery query = new SPQuery(); query.Query = @"<Where>" + "<And>" + "<Eq>" + ...