method for querying list data

learn more… | top users | synonyms

0
votes
1answer
12 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
4 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
43 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
0answers
9 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
11 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
41 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
30 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 + " " + ...
1
vote
2answers
54 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
22 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" ...
1
vote
2answers
59 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
1answer
69 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 ...
1
vote
2answers
40 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
68 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
87 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
33 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
0answers
29 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
54 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 ...
2
votes
1answer
114 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
33 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 = ...
1
vote
1answer
28 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
29 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.
0
votes
0answers
66 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, ...
1
vote
2answers
53 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
2answers
204 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
2answers
22 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
3answers
58 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
1answer
64 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
31 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
89 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 ...
1
vote
2answers
301 views

Caml Query Datetime

How can I query my custom list and only show items if the field dateField, is in today's month? Here is my query so far: <Query> <Where> <Or> <Eq> <FieldRef ...
0
votes
0answers
20 views

Convert LINQ query to CAML

Please anybody help to convert below LINQ code to CAML:- var objPendingRequest = from reqHeader in objResourceAllocation.RequestHeader.ScopeToFolder("", true).ToList() join reqDetail in ...
0
votes
1answer
24 views

Create Custom ListView

Hi guys i have a unique requirement, i have a list of tickets with few columns like Creator name, approver name and signoff names, all are of type "Text" approver name and signoff names can have names ...
0
votes
0answers
85 views

CAML query on site to get all items modified after a date

I'd like to know a way or if it's possible to get all items modified from a date in a site. Now for having this, I've a client script because i'm in sandbox solution, I've to loop on each list of the ...
0
votes
0answers
81 views

SP2010: Displaying CAML query results in XsltListViewWebPart

How can I get my CAML query to call the results on a XsltListViewWebPart in SP2010? Before I continue, 3rd party codes are not supported in the environment I'm working with and this particular page of ...
0
votes
1answer
84 views

Document Library File GUID

I used a CAML query to get file information in a document library. In the CAML query I get the GUID in order to get the unique id of the document. <FieldRef Name='GUID'/> In a different ...
1
vote
2answers
46 views

How to write a CAML Query that returns folders (recursively) beneath a starting folder?

I am looking to write a CAML query that returns all folders recursively starting at a certain folder. CAML Designer has helped me to get this far: <ViewFields> <FieldRef ...
0
votes
1answer
80 views

Show Document Icon in a SPGridView

I'm using SharePoint 2013 foundation.I have created a CAML query to get fields. I capture the results coming from the CAML query in a SPListItemCollection and then bind to a SPGridView. <FieldRef ...
0
votes
1answer
519 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" ...
0
votes
1answer
310 views

SPServices GetListItems GroupBy

I am using the SPService, the method GetListItems. I need to groupBy the result (distinct). This is my code: var CamlQuery = '<Query><GroupBy Collapse="TRUE"><FieldRef Name="nameA" ...
0
votes
1answer
126 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
1answer
79 views

Need help with CAML Query

This is my first time using CAML Query. I have a query builder which I can test with. I'm trying to create a query that will look for a specific string of text in the "Title" column, and find the ...
0
votes
0answers
20 views

Requete CamlQuery

My question is to check if my CAML query query is good or not. I want to get items from a list by the email of the current user.
0
votes
2answers
374 views

CAML query returns all items instead of one

I am querying a list to return only items matching a certain title, but the query returns all items. It seems I built or execute the query the wrong way: /* SP is an alias for ...
0
votes
1answer
52 views

SPQUERY returns null value

Hi im using sp query to retrieve the items and using projectproperty.Title to get the web name dynamically ,but I got empty value in this data table. q.ViewFields = "<FieldRef ...
0
votes
2answers
35 views

Like 'String*' in CAML

How can I write LIKE 'String*' in CAML? I must create a query to display the folder structure.
0
votes
1answer
56 views

SP Caml Query Date Range

I Have a List Called Alerts with two columns as Start Date and End Date I am Trying to generate a CAML Query that retrives only cloumns for which alerts should display within that DATE range compare ...
1
vote
3answers
194 views

CAML query rertieve 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. ...
0
votes
1answer
223 views

CAML query where date field is greater than another date field

Is it possible to write a CAML query that uses another field as the Value part of the filter? For example in SQL it would look like this: WHERE Field1 > Field2 This was by best guess but it is not ...
0
votes
0answers
44 views

Order all day events on a calendar

I have a calendar list with a choice called "Category" with items A,B,C,D. I want to sort the all day events that are shown based on the selected category. I tried to set the Orderby using the below ...