Tagged Questions

method for querying list data

learn more… | top users | synonyms

0
votes
0answers
4 views

How to check is date interval free or busy in calendar list?

I have a reservation calendar list where I'm booking some events. Before putting the new one I need to check if it is free or not, in case of free the new event created, otherwise it shows the error ...
1
vote
1answer
17 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
30 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
48 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
32 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
50 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
48 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
26 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
21 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
32 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
41 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
95 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
29 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
26 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
28 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
43 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
37 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
109 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
53 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
33 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
26 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
73 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
110 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
18 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
21 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
67 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
53 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
68 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
27 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
47 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
239 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
223 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
84 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
56 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
174 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
49 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
34 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
49 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
168 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
160 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
39 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 ...
0
votes
1answer
26 views

element for tomorrow CAML

I have a calendar and am wanting to find all the events that have been put into calendar for tomorrow. Is there an element like <today/> for tomorrow? Basically how can I get it so it only ...
0
votes
1answer
59 views

Create CAML query with have a value field with SharePoint column-SharePoint 2010

I have a SharePoint list. It has two columns Start date and End date. I need to query and get data if (start date + 7 days> End date). Through CAML builder its not possible to have a SharePoint column ...
0
votes
1answer
138 views

get last item in caml query

I've an issue with caml query. I'm trying to get the last item created this year but still have only one item while i'm having 4 in my list and remover I execute this in an event receiver itemAdding ...
0
votes
1answer
309 views

CAML query managed metadata field using the TermGuid

I have a dropdownlist which I populate with the names and IDs of a bunch of terms from my term store. When I then select a term in the dropdownlist an autopostback happens. When this postback happens ...
0
votes
1answer
77 views

Retrieve all lists and libraries Sharepoint Online

I'm trying to retrieve all lists from my online tenant from Visual Studio. After much fumbling and unsuccessful attempts with: ListItemCollection listItemCollection = oList.GetItems(query); and ...
1
vote
0answers
25 views

AllItems customization

I have a custom list definition where I have defined a view with BaseViewID = 1 (AllItems.aspx) <View BaseViewID="1" Type="HTML" WebPartZoneID="Main" ...
2
votes
1answer
117 views

Adding 2 Caml queries in same executeQueryAsync

Is it possible to use two different queries to get to different lists and use them in the same executeQueryAsync() Something like this : var camlQuery = new SP.CamlQuery(); ...