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
61 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
570 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
106 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
358 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
124 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
194 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
124 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
48 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
55 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
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
97 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
202 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
177 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
66 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
58 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
247 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
193 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
279 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
715 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
544 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
264 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
69 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
294 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
131 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
128 views

How do i get people picker value in list joins in sharepoint 2013 JSOM

I have two lists List 1 and List 2, I have to get people picker value from List 1. But because of some limitations we cannot get 'lookup' type columns in joins for that refer the below link https://...
0
votes
0answers
196 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 ...
0
votes
0answers
59 views

How to use CAML with CSOM for getting users in SP2013?

I want to get all the users in CSOM SP 2013 in javascript, but I don't want all users. I want to filter them by CAML. This is what I have so far which filters by first name is Tom, but the CAML is not ...
0
votes
0answers
319 views

How to query lookup column in list join using caml query JSOM sharepoint 2013

<ProjectedFields> <Field Name="Column" Type="Lookup" List="Employee_Table" ShowField="Column" /> </ProjectedFields <FieldRef Name="Column"/> <Query> <Where> ...
1
vote
1answer
203 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
161 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
312 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
302 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
45 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
661 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
523 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'/>&...
0
votes
2answers
54 views

How can I get my CAML to only return non-hidden (user created) fields without specifing every field?

I can provide the ViewFields but I was wondering if there is a way to return all the user created fields (non-hidden ones) without having to do that. I know this works: <ViewFields> <...
1
vote
1answer
74 views

Iterate all documents and folders in a document library,

We have a document library on our Intranet where documents are stored. The document library also has 2 folders with broken inheritance. I want to loop through all the documents in the document library,...
0
votes
3answers
6k views

SPServices getListItems CAMLQuery Issue

Attempting to retrieve items from a list where field School_id is equal to a school_id javascript variable, and using SPServices GetListItems operation. If I run the script without the CAMLQuery: ...
0
votes
1answer
379 views

“Flat” document set view - filter documents by document set ID

I have a Library which hosts my document sets. As we all know, each document set actually creates a sub-folder, within the Library. So, now I have a structure similar to: Root \___ Doc Set 1 (ID = ...
0
votes
1answer
595 views

Sp Services and calendar list

I have a SP Service call which uses GetListItems from a calendar list in SharePoint. I'm using it with the FullCalendar plugin. The events render fine that is not my question, my question is this: Is ...
0
votes
1answer
62 views

GetFieldByDisplayName error in CAML query

I'm developing a web-part for SharePoint 2010. I've to sort a SPGridView so I use SortExpression. I execute a CAML query in this way and then I bind data to SPGridView: SPQuery query = ...
1
vote
2answers
193 views

CAML query daterange not working

I am trying to retrieve list items using date range based on date column. It implicit both 'Fromdate' and 'Todate'.My CAML query is also querying on two other conditions as well. I am using the below ...