method for querying list data

learn more… | top users | synonyms

1
vote
1answer
943 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
1answer
155 views

Need help using powershell to create list items

I based my code from this example it stated it had the ability to create list items with attachments from existing list items in a new list. I liked this example because I would like to archive old ...
0
votes
0answers
27 views

Caml LookupId and LookupValue

I need to get the LookupId value and the lookup text value by CAML. With this query I get the ID but I can not get the value text anymore. <RSSharePointList ...
1
vote
1answer
791 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 ...
1
vote
1answer
414 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
0answers
23 views

How to iterate list items from two list using where in powershell script

I have two list from where i want to collect common items. I am not able to make use of $caml in my script. My script: Add-PSSnapin Microsoft.SharePoint.PowerShell -erroraction SilentlyContinue ...
0
votes
1answer
19 views

Ajax CAML Query 400 Bad Request

I get a 400 bad request with this ajax call, i tryied the caml query with caml designer and it should work. What is the problem? var soapEnv = "<soapenv:Envelope ...
0
votes
3answers
162 views

Unable to fetch tasks from all the task lists in SharePoint 2013 using CAML

following is my Query:- SPSiteDataQuery oQuery = new SPSiteDataQuery(); oQuery.Lists = "<Lists ServerTemplate=\"171\" />"; oQuery.Query = ...
0
votes
1answer
25 views

Client object model: orderby in camlquery doesn't work

I have a list on SharePoint 2010: (only showing the first item) How can i get that list alphabeticly? I use a camlquery to try this but it doesn't work. I do get the list but it is in a random ...
1
vote
2answers
355 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 ...
0
votes
0answers
10 views

How to query Range

Right now my code is is Equals in the query how can i prevent for example that if i book 2014-12-01 01:00 to 2014-12-02 01:00 This is a hole day, that no one else can for example book the same time ...
0
votes
1answer
22 views

How can I use CAML query with List WebService

var soapEnv = "<soapenv:Envelope xmlns:soapenv='http://schemas.xmlsoap.org/soap/envelope/'> \ <soapenv:Body> \ <GetListItems ...
0
votes
0answers
14 views

How to retrieve the ISO/original value of a DateTime column in a list using CAML?

I'm using SharePoint Foundation 2013 and I want to retrieve the data in my DateTime column. Is there a way to retrieve the original/raw values or ISO values of a DateTime column using CAML query? ...
1
vote
2answers
60 views

How do I get list items' attached files with CAML?

I'm retrieving items from a list. The list contains entries which have attachments. Can I modify my query to include the attachment URLs? What's the most efficient way of doing this? <View> ...
0
votes
1answer
710 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
0answers
12 views

Child node alphabetical order caml query sharepoint

qry.Query = "" + ParentNode.Text + "" + ""; I am using above caml for sorting child node. But not working . please let me know where i am doing wrong. ...
0
votes
1answer
24 views

ExecuteQueryAsync not following through to the success/failure function, javascript

I've got a function that checks if a list item (setting) is true and then changes the setting which it does correctly but doesn't execute the second ExecuteQueryAsync functions. In debugging it jumps ...
0
votes
1answer
50 views

Continous loop to check if a list item has changed, javascript

I'm trying to create a function that runs every 5 seconds to check if a list item (setting) has changed. This will then reload the page (if setting is true) and sets the setting to false. Here's what ...
0
votes
1answer
34 views

SharePoint-hosted app Query

I am trying to Query were the eventdate and eventend are. var result = listItemCustom + " " + listItemFromTime; newItem.set_item('EventDate', result); var result2 = listItemtoDate + " " + ...
0
votes
2answers
3k views

Getting items from rows 4-8 in a Sharepoint list using CAML query?

Here is the code Im using to retrieve the first 4 most upcoming announcements from the OOTB announcements list in sharepoint: How do I modify this to retrieve the next 4 (5,6,7 and 8) most upcoming ...
1
vote
2answers
83 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
2answers
62 views

CAML Query - Best practice

I want to make sure the following CAML is best way to get a single record out of 100,000 items from a list. I know there are other versions where CAML goes through each record thus takes really long ...
1
vote
1answer
2k views

Is it required to specify the value type in a CAML query?

I was wondering if CAML query Value Types are strongly typed or not. It would save me some time if I didn't have to specify "text" or "date" every time I made a query. Here is the code I am using, ...
1
vote
1answer
24 views

CAML Query with both and & or logics

How do I build a CAML query for this condition, Status = "Current" (or) Status = "Outgoing" (and) Log Status = "Not Submitted" ...
2
votes
2answers
3k views

COM exception while querying document library

I have a need to get collection of SPLitsItem currently viewed to user. My solution is a ribbon button which calls custom application page in LAYOUTS via javascript in custom action. Application page ...
1
vote
1answer
95 views

update sharepoint list item based on title field

I have used server object model to update list item based on title field and used below code SPList list = web.Lists["ListName"]; SPListItemCollection items = list.GetItems(new SPQuery() { Query ...
4
votes
1answer
3k views

CAML query recurrent events problem

Here is the code I use: SPQuery query = new SPQuery(); query.ExpandRecurrence = true; query.CalendarDate = new DateTime(2013, 1, 1); query.Query = @" <Where> <DateRangesOverlap> ...
1
vote
2answers
41 views

How to retrieve a file by UniqueId in any List subfolder

I would like to get a file by UniqueId inside of a List. I am not guaranteed which folder the file will be in so I'm using the List.GetItems call and using a CAML query to only pick the file that ...
0
votes
1answer
82 views

CAML query to ignore folders

I am searching my list but the list is in folders. How can I use a query to ignore the folders and get the whole list so I can search it. I am using sharepoint 2013 and javascript. I want to get all ...
0
votes
1answer
147 views

How to get Single Record from Sharepoint Library when Items in library are more than List Threshold value?

I am trying to get single record from Large Sharepoint library using SPQuery/CamlQuery. The List View Threshold value and List View Threshold for auditors and administrators value is set to 2000. When ...
0
votes
0answers
35 views

Caml Query to retive the List items based on the category

List Name Social Column name Category(Choice Field),Values(Text ) Category values modified ................................................ Facebook sameple update ...
0
votes
1answer
81 views

CAML search ignoring diacritics

A rather strange request has appeared from our client, who wants to be able to search a SharePoint 2010 list for items (based on a string column) while ignoring diacritics. A quick example, assuming ...
0
votes
0answers
34 views

Issue with CAML where clause in predefined elements view

I have the following CAML query in a view elements.xml file: <Query> <Where> <And> <DateRangesOverlap> <FieldRef ...
0
votes
2answers
75 views

Retrieve SharePoint list in DataTable with Condition

** I have a Sharepoint List called "Resources" and have various Fields as shown below and same returns as DataTable: ID Title Role LoginName Enable[Yes/No] 1 Pranav Developer ...
0
votes
1answer
43 views

SharePoint Caml Query

I have a SharePoint caml query that checks a SharePoint list if ReviewDate < Var_Tomorrow AND ReviewDate >= Var_Today AND ContractDuration not = to Ad Hoc AND ContractStatus = open OR ...
0
votes
1answer
231 views

How to create charts with custom filters about sensitive data using JS without using external APIs?

I need to create charts out of business data which comes out of SharePoint lists in SharePoint 2010. The solution needs the ability to easily filter the data by custom queries, just like the SPJS ...
2
votes
1answer
133 views

Find item where a group the current user is part of is in user column

I have multiple lists with the same custom Person or Group column CurrentReviewer (single selection) which will always contain a SPGroup. I have set up a SPSiteDataQuery but I'm missing the last ...
0
votes
0answers
34 views

camlquery to get only the items

I've a large document library with folders, i'd like having all the items except the folders. for now i use this where columns is a list of all internal name from the list CamlQuery q = ...
3
votes
2answers
529 views

Using part of date in CAML query

I want to create new view for my list. The list contains a column called Year, which is a number and contains, as name suggests, year. Eg.: 2012 2011 2010 2009 I would like create a view, where I ...
1
vote
1answer
32 views

Nested CAML operators

Is it possible to nest query operators other than Or/And, for example, In and Contains operators, so that the query would look for items which would contain any string from my given string collection? ...
0
votes
1answer
45 views

How to get Month Name from DateTime vlaue in CAML

I have a requirement to show user Month name of the date on which user uploaded the file. My date time value is coming in dd/mm/yyyy 00:00 AM. Someone please help me how to move forward on this.
1
vote
2answers
83 views

DateRangesOverlap always returns all results

I have a problem with SPQuery and DataRangesOverlap. In my calendar there are three events that don't happen today. In SPQuery.query I want to exclude these events. Unfortunately all events are ...
0
votes
0answers
78 views

Bind GridView using CAML query JOIN

I want to show data from 3 lists in gridview, using CAML query join. I have multiline fields in 2 of these lists. As per my knowledge these multiline fields cant be included in CAML Query JOIN. FYI, ...
2
votes
3answers
7k views

Building CAML query with AND and Order by Clause

Hi I am trying to build a query using caml query builder - Below is the query (The query = get the values only whose address = 1234st AND LastName = Doe) - I believe the placement of AND operator is ...
0
votes
2answers
264 views

Retrieve single field using CAML Query in Sharepoint using Javascript

I have a List called ProjectInformation and contains following Fields.. ID ProjectName1 ProjectManager ProjectExecution 1 EDS PPB Time and Material 2 CS ...
0
votes
3answers
64 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; ...
0
votes
2answers
23 views

How can i do a like kind CAML queries - SharePoint 2013

I have a text e.g AOCup and i need it to match AO Cup Where currentsite variable below is = AOCup but what im querying is AO Cup Thanks in Advance ** I also used Contain with no luck ...
0
votes
1answer
102 views

Using PowerShell variables in CAML Queries?

I'm trying to reconfigure scripts I made to move list items from one list to another. At the time the list were not going to change so all the variables were hard coded. Is it possible to use a ...
0
votes
1answer
44 views

CAML query regex

is there a way to perform regex query with CAML? I have a string field (Display) composed by Name and Surname. I have a single search input. I wish to have these results *Display* match UserInput ...
0
votes
1answer
150 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 ...