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
1answer
183 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
135 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
45 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
601 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
130 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
54 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
111 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
42 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
153 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
88 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('...
0
votes
1answer
64 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
699 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
113 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
397 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
139 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
213 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
135 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
50 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
57 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
93 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
104 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 Name="Title"></...
3
votes
2answers
240 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 Name='Title'/&...
3
votes
2answers
184 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
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
70 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
64 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
1k 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
272 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 Name="...
0
votes
1answer
38 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
215 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
316 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>" + ...
1
vote
1answer
803 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> ...
0
votes
0answers
46 views

CAMLquery nested AND

I want to get all the items from my list, like this (A&B) AND (C&D), but my CAMLquery doesn't seem to work, here is what I've tried so far: var camlQuery = new SP.CamlQuery(); camlQuery....
2
votes
4answers
3k views

Caml Query to return items created by logged in user

Using Javascript CSOM and want to return items created by logged in user, but the code below returns all items. Could someone advise? var camlQuery = new SP.CamlQuery(); var specifier = "<Eq>&...
2
votes
2answers
581 views

Get document from document set by caml query

I have a requirement to fetch a single document from a document set. I have 5 different custom content types that have document set as the base type. Each document set has numerous documents. I want ...
2
votes
0answers
285 views

Camlquery with date comparison

Cannot get this to Work, it returns all rows. Anyone? <Query> <Where> <Geq> <FieldRef Name='Modified'/> <Value Type='DateTime' IncludeTimeValue='TRUE'>...
0
votes
1answer
71 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 ...
0
votes
1answer
29 views

SPQuery needs initialization?

i stumbled upon a curious line here it looks like: foreach(var item in someList.GetItems(new SPQuery {Query = "<Where />"}){...}; and i wonder if i could just omit the initialization of the ...
1
vote
3answers
302 views

CAML retrieve only the latest of each value in a column

(Sorry if the title isn't clear I'm not really sure how to phrase it in one question) Situation: I have a list in sharepoint containing some evaluation of different teams in a company with at least ...
0
votes
1answer
145 views

Get Item ID not working

I'm trying to get the ID from a SharePoint list, however I cannot obtain it. ctx_load(Include(ID)) does not seem to work. When I call items.get_id(); it returns undefined. Also, the items object is ...
0
votes
0answers
216 views

GetListItem SPServices don't retrieve data

i'm trying to retrieve data from Sharepoint using SPServices. I created a list called "values" with two field: "Title" (text field) and "values" (numeric field). I created a js file linked to a ...
1
vote
1answer
221 views

CAML query in JSOM for SharePoint 2013 results in “value does not fall in the expected range”

While querying yes/no column using caml query JSOM sharepoint 2013 getting "value doesnot fall in the excpeted range". <ProjectedFields> <Field Name="DateColumn" Type="Lookup" List="...
5
votes
3answers
162 views

<Eq>-CAML delivers wrong result

I have a strange problem, maybe someone here may have a helpful suggestion. I have a list, with a Note-Field, containing a Url: http://dev-wilma/results.aspx?r=owstaxIdGeschaeftsfallart:|fa543359-...
2
votes
0answers
331 views

Expanding user field for LikedBy in CAML query

I'm retrieving like ratings from a list. That is working. But I want to know if the current user has liked an item. I've added the LikedBy column to my include list. Here is the code that is working: ...
2
votes
1answer
318 views

CAML query filtering is not working

I've googled that it can be in case when query is not well-formed. But I'm verifying it for several hours and didn't find any mistake. Problem is common: query doesn't filters and returns all data. ...
3
votes
2answers
2k views

Retrieving list Items programmatically from CAML via Client Side object Model when a Document Library has more than 5000 items

I have a SharePoint provider hosted app that stores documents with metadata in a Single Document Libraray programmatically via CSOM. I have a requirement to display the list items in a MVC web app ...
0
votes
1answer
47 views

How to check if managed metadata has a keyword in CAML query?

I want to make a caml query that checks if a managed metadata column (which is a list of phrases) contains a certain phrase. I have this which seems to work, but the problem is it does a substring ...
1
vote
1answer
1k views

CAML query to get a list of item IDs from an item list

I'm using SharePoint 2013 and want to use CSOM/CAMLquery to retrieve some related information in another list. The related list may have 500+ items in it and I want to return information about maybe ...
0
votes
2answers
744 views

Javascript CAML Query using DateTime

I have the following CAML: <Where> <And> <Eq> <FieldRef Name='Author' LookupId='TRUE' /> <Value Type='User'>473</Value> ...
0
votes
1answer
564 views

How to create CAML query in powershell to compare dates?

I want to compare dates, but my code isn't working. $spQuery = New-Object Microsoft.SharePoint.SPQuery; $camlQuery = "<Query><Where><Lt><FieldRef Name='DocumentDate'/>&...