method for querying list data

learn more… | top users | synonyms

1
vote
1answer
1k views

ProjectedFields working in SPQuery but not in the View

I've three lists: Competitions, Works and WorksVotes, linked to each other through Lookup fields. WorksVotes list has Lookup field to Works list, and Works list has Lookup field to Competitions list. ...
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
2answers
867 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
46 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
24 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
14 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
40 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
2answers
980 views

How to change a date format in CAML

I got a wrong date format to a CAML. I have got (yyyy-mm-dd) and must to be understand by CAML to the format(dd-mm-yyyy), how can I do this. I tried by String.Format("{0:yyyy-mm-dd}", dateISO1);, but ...
0
votes
1answer
695 views

Retrieve List items using CAML Query

I have a list which contains 3 columns -ID, TicketState and EndDate ID TicketState EndDate(DD-MM-YYYY) 1 Open 10/10/2012 2 Closed ...
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 ...
2
votes
3answers
9k views

Using Date offset in CAML query

In SharePoint 2010, Inned to get items from a list based on a condition. Considering one of the fields to be 'EventDate' of type DateTime, the condition is: (EventDate - 60 Days) <= Today <= ...
0
votes
1answer
508 views

How to get week birtdays

I have a list called profile, and this list contains the Birthday field, is a field of type DateTime. I created two fields of type calculated, one gets the day, and the other gets the birthday month ...
4
votes
3answers
136 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: ...
0
votes
0answers
41 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
49 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" ...
1
vote
1answer
491 views

CAML query - examine Contents column used in freetext predicate

In my query I use the freetext predicate: and freetext(Contents, 'my search string') I'm getting some unexpected results from this search, namely the documents contain no relevant content, yet are ...
0
votes
3answers
3k 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 = ...
1
vote
1answer
998 views

SPServices Autocomplete and dynamic CAML query

I have two Text filter web parts (Project and Customer Name) with Apply Filters button for one list. There is a SPServices.SPAutocomplete on each and it works great. Now, I want to show the values in ...
2
votes
1answer
2k views

Help converting XmlNode to DataSet/DataTable, from SharePoint Web Services, Lists.asmx

This is my first post here, but used this site a lot :) My question is how I can convert an XmlNode, obtained through the Lists.asmx SharePoint web service, to a DataSet / DataTable. The reason I ...
0
votes
3answers
132 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; ...
1
vote
0answers
33 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
1k 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
114 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. ...
2
votes
2answers
208 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 ...
1
vote
0answers
25 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 ...
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
27 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
75 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
30 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 ...
2
votes
2answers
600 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
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
34 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 ...
3
votes
3answers
70 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
193 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
72 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
1k views

Dynamically adding And to CAML query

I have the following "base" query: <Where> <And> <Eq> <FieldRef Name='Field1' /> <Value Type='Boolean'>1</Value> ...
4
votes
2answers
8k 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. ...
0
votes
1answer
100 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
29 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 = ...
0
votes
1answer
44 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 ...
1
vote
2answers
64 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
49 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
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 ...
1
vote
2answers
391 views

Multiple CAML query to filter Data list view

My Custom list have four columns(Doc ID, Created by, Assigned To, Assigned date). I want to filter the data in Data list view. In my page there are 4 text boxes and a Button is there for the user ...
4
votes
3answers
131 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 ...
1
vote
0answers
52 views

SP2010 - Visual Web Part - Storing metadata in folders in document libraries

I want to store a number to folders to enforce ordering. I noticed these three pages Get Property Set Property Add Property And I want to know if it's possible to use these to add a number to the ...
1
vote
1answer
303 views

sharepoint 2010 - How to get document ID using spservices sql search query?

Using spservices to make search requests, I am building the query like this: var queryText; queryText = "<QueryPacket xmlns='urn:Microsoft.Search.Query' Revision='1000'>"; queryText += ...
0
votes
1answer
104 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
81 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 ...