method for querying list data

learn more… | top users | synonyms

1
vote
2answers
15 views

Camlquery: Getting items from top root folder of list

I know how to get items from a folder inside a list (example below) CamlQuery caml = new CamlQuery(); caml.FolderServerRelativeUrl = "/folder/path"; But how do you get the items from just the top ...
0
votes
0answers
11 views

retrieving user name in Jquery datatable and caml query

Hi I am on SharePoint 2010 version , I have created a list with createdby, createdDate and Employee name as columns in it. I am having a text box and a button when I enter employee name and click ...
-1
votes
2answers
23 views

CAML query to show _moderationstatus

I am trying to show list items in a publishing page and I am getting all column values except for Approval Status column which should show text as values is showing integers like 0 for Approved ...
1
vote
2answers
24 views

Element “Query” is invalid (GetListItems)

I'm calling GetListItems via spservices, and specifying the CAMLQuery field to be the following value: <Where> <Or> <Contains><FieldRef Name='ows_Title'/><Value ...
1
vote
2answers
407 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. ...
10
votes
4answers
14k views

Where can i download the U2U CAML query Builder for Sharepoint 2010?

I have try to download form below links. But the site is not opening. http://www.u2u.be/res/Tools/files/CamlBuilderSetupv4.0.0.0.zip . http://www.u2u.be/res/tools/camlquerybuilder.aspx ...
0
votes
1answer
22 views

Get SPListItem Managed Metadata Field Value

I'm having trouble getting the values of a Managed Metadata Field in a SharePoint List. Basically, what I want to do is given a string (ex. "Category"), it will find all the list items that match ...
0
votes
1answer
18 views

how to write caml query to count item created in each month

I need to write CAML query to count items created in each month.It should give me a count of items created in particular month.
0
votes
2answers
17 views

Update filed values based on conditions

i have document library in sharepoint 2010 and i want to update a field values based on some conditions . I need that every parentid has some documents and i want to update those prosessnos which ...
0
votes
1answer
36 views

CAML query to get data for SSRS from SharePoint list

I am writing CAML query to get data from sharepoint list <RSSharePointList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> ...
1
vote
1answer
125 views

Sharepoint REST API - Using caml query and select/expand to get lookup data

I have a Sharepoint app and I use a caml query to filter the data I get back: var caml = "<View><Query><Where><And><Contains><FieldRef Name='PublishingPageLayout' ...
0
votes
0answers
36 views

CAML Query for getting folder contents based on folder parameters

I have the following folder structure. Folder1 attr1="cat1" >> file1 attr2="subcat1" >> file2 attr2="subcat2" Folder2 attr1="cat2" >> file3 attr2="subcat1" >> file4 ...
1
vote
1answer
863 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 ...
0
votes
1answer
22 views

Search from multiple list in caml querry

I want to search data from multiple tables using CAML query.
0
votes
2answers
48 views

Limit data returned by GetListItems of Lists.asmx service with CAML

I want to limit data returned by GetListItems of Lists.asmx service. Does anyone know why despite the query options below I get all items? "<GetListItems ...
0
votes
2answers
835 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 ...
1
vote
3answers
103 views

How to get a old version of list item?

I need to get all field values of an specific version. It is possible by sharepoint hosted app (javascript)? I need to create a custom version history page of itens. If there is a caml query ...
0
votes
1answer
426 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
1answer
1k 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 ...
1
vote
1answer
456 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 ...
1
vote
2answers
377 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
2answers
23 views

Escaping the ampersand '&' in camlQueryOptions using SPServices when getting items from a folder

I've tried escaping the ampersand using <![CDATA[]], html encoded characters but it doesn't return any results. My query looks like CAMLQueryOptions : ...
4
votes
4answers
12k 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
1answer
25 views

Add filter and pagination to CAML query

I'm developing a visual web part for Sharepoint 2010. I would display all documents from a specific DL, but this DL contains more than 7000 items. So I would like to add a pagination (show only 20 ...
0
votes
1answer
23 views

Using In Operator in SharePoint 2010 Caml Query

I am using the IN Operator in SharePoint 2010 CAML query to get my desired set of results, however, the filter criteria doesn't seem to work and returns all records instead of the filtered set. ...
0
votes
5answers
76 views

How to perform/retrieve a CAML Query in SharePoint Designer

I have a standard CAML query (see below) that I would like to perform in SharePoint designer. How do I take this CAML query and retrieve it's data. Also where do I declare the list to run it against ...
1
vote
1answer
22 views

CAML - Understanding when to use Eq, Geg and Value

With the following CAML query: camlQuery.set_viewXml('<View><Query><Where><Geq><FieldRef Name=\'ID\'/>' + '<Value ...
0
votes
1answer
41 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
82 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
98 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
13 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
49 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
3answers
2k views

Is it possible to have CAML Join without Lookup Columns?

I am new to SharePoint. I am developing a web-part in that I am trying to join two list. I have a same web-part in that lists were join using LINQ query. But it takes more time to fetch the data. So ...
0
votes
1answer
37 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
32 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 ...
2
votes
2answers
93 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
3answers
667 views

Filter by projected field in CAML - is it possible?

I have a Dealers list with the following structure: ID | Title | DealerCode and DealerLetters list with lookup column (referencing to the Title field): ID | Title | RegistrationNumber | ...
3
votes
1answer
1k views

IsNull not working in CAML query for indexed fields

So for example I have field 'TestField' which is indexed. How can I caml for items where 'TestField' value is null? My example down here will fail and won't find what I am querying for. <Where> ...
1
vote
0answers
27 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 ...
0
votes
1answer
55 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
39 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
49 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
89 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
49 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
28 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
55 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 ...
3
votes
2answers
6k views

CAML query limitation of values in IN operator

I have less than 5000 items in my library. I want to get 530 items by ids. So I am using following query. <Where> <In> <FieldRef Name="ID" /> <Values> ...
5
votes
4answers
4k views

Caml query builder Office 365 Sharepoint Online

Does anyone knows where to find a CAML query builder that I can use for Office 365, Sharepoint Online? (if there exists one)
2
votes
1answer
246 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(); ...
1
vote
3answers
944 views

Hard code group name into CAML query

I am trying to hard code a user group into a CAML query's where clause. The reason is so that I can apply additional criteria when the user is in one group, and something else if they are in another ...