method for querying list data

learn more… | top users | synonyms

0
votes
0answers
53 views

Left joins on single list on user picker field

Need to show employee and manager info from a single list. Here is my query: <Joins> <Join Type="LEFT" ListAlias="EMP"> <Eq> <FieldRef ...
0
votes
1answer
100 views

“Flat” document set view - filter documents by document set ID

I have a Library which hosts my document sets. As we all know, each document set actually creates a sub-folder, within the Library. So, now I have a structure similar to: Root \___ Doc Set 1 (ID = ...
2
votes
2answers
1k views

Dynamically adding And to CAML query

I have the following "base" query: <Where> <And> <Eq> <FieldRef Name='Field1' /> <Value Type='Boolean'>1</Value> ...
5
votes
2answers
8k views

How do I query a list using CAML and SPQuery?

I have a SPList but I don't need to go through everything in that list. I need to establish a CAML query so I can limit the list items. Then, go thru each item from the query result and do something. ...
0
votes
1answer
162 views

Sp Services and calendar list

I have a SP Service call which uses GetListItems from a calendar list in SharePoint. I'm using it with the FullCalendar plugin. The events render fine that is not my question, my question is this: Is ...
0
votes
1answer
37 views

GetFieldByDisplayName error in CAML query

I'm developing a web-part for SharePoint 2010. I've to sort a SPGridView so I use SortExpression. I execute a CAML query in this way and then I bind data to SPGridView: SPQuery query = ...
0
votes
1answer
49 views

Caml query for date range not working [duplicate]

HI am trying to use CAML query to pull the data of list based on date range and I am unable to pull the data with the query i am using. I have column name as 'created' and which is for both fromDate ...
1
vote
2answers
70 views

CAML query daterange not working

I am trying to retrieve list items using date range based on date column. It implicit both 'Fromdate' and 'Todate'.My CAML query is also querying on two other conditions as well. I am using the below ...
0
votes
0answers
59 views

Filtered lookup using SPServices

I have 3 lists: Schools, Interactions, Contacts In the new form for a Interaction item I have a lookup field displaying a long list of contacts, however I need to filter this list to only display ...
0
votes
1answer
34 views

CAML Query and using non user credentials

I have 2 sites for 2 different groups. One group has access to site1 and one group has site2. Each group does not have access to the others site. I have a query however that needs to access each ...
1
vote
2answers
395 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 ...
4
votes
3answers
177 views

Change sort order in returned ItemsCollection

I am fetching a collection of items from a list using a CAML query. The returned items are then populated in my custom HMTL table. There is, however, another HTML table for which I need the same ...
1
vote
0answers
52 views

SP2010 - Visual Web Part - Storing metadata in folders in document libraries

I want to store a number to folders to enforce ordering. I noticed these three pages Get Property Set Property Add Property And I want to know if it's possible to use these to add a number to the ...
1
vote
1answer
317 views

sharepoint 2010 - How to get document ID using spservices sql search query?

Using spservices to make search requests, I am building the query like this: var queryText; queryText = "<QueryPacket xmlns='urn:Microsoft.Search.Query' Revision='1000'>"; queryText += ...
0
votes
1answer
132 views

CSOM Join with CAML query raise exception

I am trying to retrieve all Customer Contracts which Customer Master has Procurement Relevant = True I used CSOM to communicate with SharePoint 2010 to retrieve list items and used CAML query to ...
0
votes
0answers
113 views

Sharepoint CAML query to select all items that user have shared with it

I secure my sharepoint list using share with, it is done by sharepoint event receiver that share the current added item with all people who could interact with that item. It works well, but when I use ...
1
vote
2answers
615 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
1answer
76 views

Concatenating a javascript variable into a camlQuery

I have a caml query that I'm concatenating with a javascript variable of type string. It queries the column names 'Audience' and returns the first 3 ordered by the newest. The variable subsite gets ...
2
votes
1answer
117 views

Using where clause in caml query

I want to select all items from a list where Title is equal to logInUser (which is current login user name). In my code I have created : var logInUser = context1.get_web().get_currentUser(); But ...
3
votes
2answers
264 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
51 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
57 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
129 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 ...
11
votes
4answers
16k 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
102 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
76 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
48 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
117 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
1k 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
93 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 ...
0
votes
1answer
23 views

Search from multiple list in caml querry

I want to search data from multiple tables using CAML query.
0
votes
2answers
245 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 ...
1
vote
3answers
364 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
2answers
109 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 : ...
5
votes
4answers
19k 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
116 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
91 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
220 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
39 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
122 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
138 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
420 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
18 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
140 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
48 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
72 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
198 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
888 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 | ...
2
votes
0answers
39 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 ...