method for querying list data

learn more… | top users | synonyms

0
votes
1answer
23 views

Is it possible to write a CAML query that will update or insert an entry based on its existence?

I'm working with Sharepoint using CSOM and Javascript. I need to cache usage statistics in a List with one entry per user, updating values in a user's list entry when they interact with the site in a ...
0
votes
1answer
24 views

SharePoint 2013: JavaScript Object Model - Caml Query where list item is selected

How could I use a caml query to only get the list items that are selected using the JavaScript Object Model? <Where> <Eq> <FieldRef Name= ??? /> <Value ...
0
votes
1answer
50 views

How to consolidate JS for CAML queries with multiple filters?

I'm very new at the entire JS/SPServices concept (and JS as a whole) and I'm trying to slim down the amount of JS needed for a few HTML pages. I have several unordered lists on the HTML page that I ...
2
votes
0answers
12 views

Why a pair of FieldRef must be specified for a Join?

I'm writing a small js library to abstract away the annoyance and complexity of creating a CAML query. In that regard, can you explain the significance of both FieldRef elements within a Join, when ...
1
vote
2answers
21 views

GetListItems not returning empty fields even when using ViewFields

I am using the GetListItems web service to query a list. I am passing the viewFields property to return certain fields: var viewFields = XElement.Parse(@" <ViewFields> <FieldRef ...
0
votes
1answer
35 views

JSOM function not getting called

I have two functions in my js file. Each function is used to fetch data from list. The first function is called as: jQuery(document).ready(function () { SP.SOD.executeFunc('sp.js', ...
1
vote
1answer
21 views

Query the Author column using login “domain\user”

I need to query a SharePoint list and specifically the Author column with a given login in the form "domain\username". I read that I must switch the column's "Show Field" property to "Account", but ...
1
vote
0answers
22 views

How to make CQWP retrieve 4 most recent Items in the whole site collection?

I'm a little stuck with one of m Content Query Web Part: On my homepage, i would like to display the 4 most recent items added to my site collection in a Content Query Webpart called "What's new?" So ...
2
votes
2answers
61 views

JSOM Anonymously CAML query list items

I am attempting to query a list using CAML via JSOM and am getting the error message The method "GetItems" of the type "List" with id "{GUID}" is blocked by the administrator on the server. I have set ...
0
votes
1answer
33 views

How to write Join 4 lists using CAML Query (CSOM)

I have four lists in my site. I need to get data from all these lists in CSOM (Provider hosted app). All these lists are connected linearly (one to one). List 1 -> List 2 -> List 3 -> List 4. for eg ...
0
votes
2answers
32 views

CAML Query to Return all rows

I am having Sql Query like // sTitle is my input string string sTitle='something'; Select Title From EmployeeList WHERE Title like '%sTitle%' or 0=sTitle OrderBy Title Desc; How do i Build it in ...
0
votes
1answer
26 views

CAML query datetime - publishingstartdate

I'm trying to get a CAML query working with dates - specifically PublishingStartDate and PublishingExpirationDate. When scheduling an item, there is the option to select 'immediately' and 'never' ...
0
votes
3answers
50 views

Caml Query to find items with different values in two fields?

In a list, I have two managed metadata columns (let's say Tax1 and Tax2). I'm trying to find all items where values in Tax1 and Tax2 are different. I'm using this query: <Where> ...
1
vote
1answer
41 views

Caml query when Title field contains Plus (+) sign

This CAML query is not working if Title field contains Plus (+) Sign. My query is : function createSACQuery(Title) { var qry = new SP.CamlQuery(); qry.set_viewXml('<View ...
0
votes
1answer
18 views

Why using Decimal in this CAML Query is not returning correct records?

I have the following table: DoubleNumber ------------- 10.50 44.77 88.90 I am using the following CAML Query: query.Query = "<Where><Contains><FieldRef ...
0
votes
2answers
34 views

What is wrong with the following Caml query

I have the following table with columns: Editor | _UIVersionString | Title | LookupNumber | Author a | b | Title1| 100;800 | admin I use the following query caml ...
2
votes
1answer
32 views

Caml Query for exclude those ListItems from a ListItemCollection whose LookUp columns contains text “Full Access”

I am facing some problem with SharePoint 2013 CAML Query. I have a list and there is a look up column on it. There are some values on the lookup column.For example, I have Full Access and Limited ...
-1
votes
1answer
39 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
24 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
0answers
32 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
0answers
50 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
111 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
36 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 ...
1
vote
1answer
76 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
13 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
42 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
33 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
158 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
17 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
111 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
80 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
41 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
86 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
32 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
235 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
265 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
56 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
204 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
256 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
59 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
41 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
245 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
45 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 ...
3
votes
1answer
252 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
38 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
37 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
63 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
106 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
210 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
637 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 ...