method for querying list data

learn more… | top users | synonyms

1
vote
1answer
16 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
26 views

Camlquery with date comparison

Cannot get this to Work, it returns all rows. Anyone? <Query> <Where> <Geq> <FieldRef Name='Modified'/> <Value Type='DateTime' ...
0
votes
0answers
16 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
22 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
49 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
25 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
17 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 ...
0
votes
0answers
46 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
27 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
49 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> ...
1
vote
1answer
60 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" ...
4
votes
3answers
137 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: ...
1
vote
0answers
48 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
126 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. ...
1
vote
0answers
28 views

How to include time interval in CAML query? [closed]

I have CAML query in NINTEX workflow. It is fetching records from last days i,e last 24 hours. Now, i need to include time to that condition. i,e I need to fetch records from 6 AM- 12 Noon only. My ...
2
votes
2answers
251 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
24 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 ...
0
votes
1answer
29 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
83 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
38 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 ...
0
votes
2answers
30 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
37 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 ...
0
votes
3answers
253 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
0answers
52 views

Left joins on single list on user picker field

Need to show employee and manager info from a single list. Here is my query: <Joins> <Join Type="LEFT" ListAlias="EMP"> <Eq> <FieldRef ...
0
votes
1answer
76 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
113 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
32 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
66 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 ...
0
votes
0answers
52 views

Filtered lookup using SPServices

I have 3 lists: Schools, Interactions, Contacts In the new form for a Interaction item I have a lookup field displaying a long list of contacts, however I need to filter this list to only display ...
0
votes
1answer
46 views

Caml query for date range not working [duplicate]

HI am trying to use CAML query to pull the data of list based on date range and I am unable to pull the data with the query i am using. I have column name as 'created' and which is for both fromDate ...
0
votes
1answer
30 views

CAML Query and using non user credentials

I have 2 sites for 2 different groups. One group has access to site1 and one group has site2. Each group does not have access to the others site. I have a query however that needs to access each ...
4
votes
3answers
137 views

Change sort order in returned ItemsCollection

I am fetching a collection of items from a list using a CAML query. The returned items are then populated in my custom HMTL table. There is, however, another HTML table for which I need the same ...
3
votes
3answers
71 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
1answer
111 views

CSOM Join with CAML query raise exception

I am trying to retrieve all Customer Contracts which Customer Master has Procurement Relevant = True I used CSOM to communicate with SharePoint 2010 to retrieve list items and used CAML query to ...
0
votes
0answers
93 views

Sharepoint CAML query to select all items that user have shared with it

I secure my sharepoint list using share with, it is done by sharepoint event receiver that share the current added item with all people who could interact with that item. It works well, but when I use ...
0
votes
1answer
60 views

Concatenating a javascript variable into a camlQuery

I have a caml query that I'm concatenating with a javascript variable of type string. It queries the column names 'Audience' and returns the first 3 ordered by the newest. The variable subsite gets ...
2
votes
1answer
93 views

Using where clause in caml query

I want to select all items from a list where Title is equal to logInUser (which is current login user name). In my code I have created : var logInUser = context1.get_web().get_currentUser(); But ...
3
votes
2answers
195 views

Camlquery: Getting items from top root folder of list

I know how to get items from a folder inside a list (example below) CamlQuery caml = new CamlQuery(); caml.FolderServerRelativeUrl = "/folder/path"; But how do you get the items from just the top ...
0
votes
0answers
46 views

retrieving user name in Jquery datatable and caml query

Hi I am on SharePoint 2010 version , I have created a list with createdby, createdDate and Employee name as columns in it. I am having a text box and a button when I enter employee name and click ...
-1
votes
2answers
52 views

CAML query to show _moderationstatus

I am trying to show list items in a publishing page and I am getting all column values except for Approval Status column which should show text as values is showing integers like 0 for Approved ...
1
vote
2answers
108 views

Element “Query” is invalid (GetListItems)

I'm calling GetListItems via spservices, and specifying the CAMLQuery field to be the following value: <Where> <Or> <Contains><FieldRef Name='ows_Title'/><Value ...
0
votes
1answer
88 views

Get SPListItem Managed Metadata Field Value

I'm having trouble getting the values of a Managed Metadata Field in a SharePoint List. Basically, what I want to do is given a string (ex. "Category"), it will find all the list items that match ...
0
votes
1answer
64 views

how to write caml query to count item created in each month

I need to write CAML query to count items created in each month.It should give me a count of items created in particular month.
0
votes
2answers
45 views

Update filed values based on conditions

i have document library in sharepoint 2010 and i want to update a field values based on some conditions . I need that every parentid has some documents and i want to update those prosessnos which ...
0
votes
1answer
96 views

CAML query to get data for SSRS from SharePoint list

I am writing CAML query to get data from sharepoint list <RSSharePointList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> ...
1
vote
1answer
1k 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' ...
0
votes
1answer
23 views

Search from multiple list in caml querry

I want to search data from multiple tables using CAML query.
0
votes
2answers
198 views

Limit data returned by GetListItems of Lists.asmx service with CAML

I want to limit data returned by GetListItems of Lists.asmx service. Does anyone know why despite the query options below I get all items? "<GetListItems ...
0
votes
0answers
86 views

CAML Query for getting folder contents based on folder parameters

I have the following folder structure. Folder1 attr1="cat1" >> file1 attr2="subcat1" >> file2 attr2="subcat2" Folder2 attr1="cat2" >> file3 attr2="subcat1" >> file4 ...
1
vote
3answers
288 views

How to get a old version of list item?

I need to get all field values of an specific version. It is possible by sharepoint hosted app (javascript)? I need to create a custom version history page of itens. If there is a caml query ...