method for querying list data

learn more… | top users | synonyms

-1
votes
1answer
80 views

Retrieving SP Calendar Items

Using CAML query, I have this requirement to retrieve items from calendar list where date is neither an Event Date nor an End Date but exists in a span of {Event & End} time like so: I have ...
0
votes
1answer
36 views

Show Live Document Library by QueryString

I am trying to build a page in which I can then add a Query String to pull the specific document library, showing all of the folder and files in it. Then from there I am going to create a webpart ...
0
votes
2answers
802 views

How to get display name from created by field in sharepoint client object model?

In my SharePoint JavaScript code, I am retrieving items from a list in my SP 2010 environment. I used a camel query to download specific fields. One of the fields was created by (person who created ...
0
votes
0answers
48 views

CAML query reporting services, date field

I am using reporting service to query (with CAML) a list on SharePoint. The list has an external content type, my problem is that just the Date field is not rendered fine. This is my result: ...
0
votes
1answer
240 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
138 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 ...
0
votes
0answers
215 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
153 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
283 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 = ...
1
vote
1answer
293 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
0answers
17 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
105 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
80 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? ...
0
votes
0answers
18 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
269 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
135 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
57 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
4k 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
128 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
40 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
669 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
4k 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
112 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
559 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
282 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
105 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
83 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
53 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
828 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
53 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
275 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 ...
3
votes
1answer
477 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
45 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
614 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
45 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
114 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
167 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, ...
0
votes
2answers
2k 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
30 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
524 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
171 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 ...
2
votes
2answers
3k 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
47 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
36 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
121 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
135 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
157 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
4answers
18k views

CAML Query to retrieve announcement items in descending order based on ID # - Not Working

spQuery.Query = " <OrderBy> <FieldRef Name='ID' Descending='True'/> </OrderBy> <Where> <Eq> <FieldRef Name='Title' /> <Value ...