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
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
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 ...
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 ....
2
votes
2answers
7k 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' ...
2
votes
1answer
13k 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" src="../js/...
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
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 =&...
1
vote
3answers
7k 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
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'/&...
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> &...
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 <Query><Where><And><Geq><...
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
273 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
806 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
216 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>" + ...
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
583 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
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
2answers
2k views

CSOM CamlQuery won't return any file

I have a folder (Myfolder) that includes two subfolder2. Myfolder -----Subfolder1 --------file1.zip --------file2.zip -----Subfolder2 Inside the subfolders there are zip files. ...
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 ...
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-...
1
vote
1answer
222 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="...
0
votes
3answers
227 views

retrieving custom list javascript

This is my first attempt at this software and I'm having problems pulling data from a custom list I've created in sharePoint. Here's what I have <script> var items; $(document).ready(...
2
votes
0answers
333 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: ...
4
votes
2answers
2k views

IsNull not working in CAML query for indexed fields

So for example I have field 'TestField' which is indexed. How can I caml for items where 'TestField' value is null? My example down here will fail and won't find what I am querying for. <Where> ...
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'/>&...
2
votes
2answers
886 views

Looping retrieved Items throws an InvalidCastException

I have some very simple code using the client object model to retrieve a list and all items from that list from a SharePoint 2013 Online site. When the ExecuteQuery() fires, I use Fiddler to view the ...
0
votes
2answers
59 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
78 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,...
3
votes
3answers
159 views

Why is this CAML Query returning all items regardless of the <Where> element

I'm trying to retrieve a list of items where a specific field matches a specific value. Here's what my CAML query: Query query = new SPQuery(); SPQuery ...
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
393 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 = ...
2
votes
2answers
2k views

Dynamically adding And to CAML query

I have the following "base" query: <Where> <And> <Eq> <FieldRef Name='Field1' /> <Value Type='Boolean'>1</Value> ...
5
votes
2answers
14k views

How do I query a list using CAML and SPQuery?

I have a SPList but I don't need to go through everything in that list. I need to establish a CAML query so I can limit the list items. Then, go thru each item from the query result and do something. ...