method for querying list data

learn more… | top users | synonyms

0
votes
0answers
37 views

How could I union three list into one view using caml in sharepoint 2013?

I want to create a new view to union the other lists, like SQL query "union all". I have found SPView.Joins but I cannot find syntax like SPView.Unions. How should I write my CAML query in my new ...
9
votes
2answers
11k 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 ...
1
vote
1answer
1k views

Lookup field value in CAML, Client Object Model

I am using the .NET Client Object Model from a website to access data in a SharePoint list. One of the fields I am trying to access is a lookup field. How do I get the text for the lookup field using ...
0
votes
1answer
108 views

CAML query where to get all items

I am going to implement a search query. I have 2 inputs user can give value or leave as empty. If user leave both input as empty and Search,,all items must populated. here I have static SP CAML query ...
0
votes
1answer
67 views

Performance : Caml query taking long time to load or something else

I have a CAML query which provides a result, if a SPfolder exists or not. When i do the item.Count it takes around 2sec for the line to execute . What is going wrong and taking long time to execute ...
1
vote
1answer
1k views

date filter of today in rest api

I have a caml query filter for one of my date-time field. <Leq> <FieldRef Name ='StartDate1' /> <Value Type ='DateTime'> <Today /> </Value> </Leq> Is ...
0
votes
0answers
105 views

Query for recurrent events with combined <And> operator

I can query a calendar for its events including the recurrent ones. But I can't get it work to further filter the result set by applying logical operators. For example the list Calendar has a ...
0
votes
1answer
673 views

Get grouped items by “Group by” and applied pagination

I use "Group by" CAML element to group items and also want to applied pagination(10 first grouped items) to SPQuery. But SPList.GetItems(spquery) returned 10 items without grouping them. My code is as ...
0
votes
1answer
345 views

Join three Lists in CAML

Suppose that we have three tables(Three Lists in SharePoint).The relations between tables are described by the following image. I want to translate the following query to CAML query: select c.* ...
1
vote
2answers
208 views

Why does my console output contain html tags for some field values?

I created a custom list which contains different field values e.g. Text Choice Note Currency Peoplepicker Using the following code I print the field values to console: List mealList = ...
0
votes
3answers
199 views

What does the Author property mean in the query service?

I'm using the query search services of SharePoint and I'm not able to find in the MS documentation if the Author property matches the Created By, Modified By or both (or something else :)). Any ...
0
votes
1answer
334 views

SP2013 - CQWP query override for tasks assigned to me

I'm using a CQWP, and I need to add more than three filters. The filters I want are: Status is not equal to Completed Status is not equal to Deferred Due date is less than Today Assigned To is equal ...
1
vote
5answers
442 views

Translating a SQL query to CAML query

I am new to CAML query and as much as I have expected it to be simple like SQL I have found it quite frustrating to deal with. I have a simple query SQL query I am trying to translate into CAML but do ...
0
votes
2answers
518 views

Filter List for DateTime using CAML against Calculated Field

In WSS 3.0, I have a list with a Calculated Field, 'MaxDate'. It gets the greater of two other dates, Notional Date and Override Date. I am trying (and failing) to build a CAML query to get all items ...
0
votes
1answer
637 views

SQL Not IN equivalent in CAML

I have two list(subject, subjectcategory). subject(ID,Title,CategoryId) subjectcategory(ID,Title) I want to create a CAML query for SharePoint that does something like this SELECT ID, Title ...
3
votes
2answers
2k views

SP 2010 - Client object model (javascript) - How to use get_listItemCollectionPosition for paging?

This is my code: When I call the function to get the items, it fails (doesn't go to the fail function, it goes into the success function but crashes when I try to get the position object), and I get ...
0
votes
2answers
526 views

How to use XmlDefinitionLink & CAML to reuse View definitions in multiple XsltListViewWebPart controls?

This is what I want to achieve (in SharePoint 2010): A custom page containing 2 XsltListViewWebPart Both of them rendering the same list data, but with different XSLT definition for display I ...
1
vote
2answers
188 views

Timer Job throws Field types not installed correctly Exception when querying a list

Hi Guys I have this situation: A timer job queries a list and gets items from it. The 2 queries are: <Where> <And> <And> <Leq> ...
0
votes
3answers
2k views

Use CAML query based on ID to retrieve a file name?

With jquery and spservices, I use getSelectedItems to retrieve the IDs of a few documents. Can I have a loop which goes through a caml query for each of those IDs to retrieve the file name ...
0
votes
2answers
569 views

CAML Query returning null

I'm very new to sharepoint and have the following query on my Shared Documents. It is returning null for all three documents I have. I'm wondering where to check in database to see if values are null ...
1
vote
1answer
10k views

How to reterive list item values using CAML query?

I have one Date and time column and text colum. I need to retrieve list item value based on this both column using CAML query.. For ex: Columname---> Date value for date would be-6/1/2013 and ...
1
vote
0answers
70 views

Manage files with no checked in version - CAML query

I am using Office 365. We have a document library containing more than 12000+ documents, with a number of folders and subfolders. I need to find a way to get all document which have no checked in ...
2
votes
3answers
260 views

Need a way to identify files which have no checked in version

I wrote a script that traverses a collection, it's document libraries and gets a list of all files. I'm trying to find all the documents which do not have a checked in version and require a user to go ...
4
votes
3answers
12k views

How to build a CAML query with where clause

I have this CAML below and i'm tring to do something like this. Where username ='username' and id = 'id' <Query> <Where> <And> <Eq> ...
0
votes
1answer
151 views

CSOM query certain date

I have a list that has an end date in. Is there anyway to filter out the dates that are passed todays date? function retrieveCurrentListProperties() { clientContext = new ...
1
vote
2answers
1k views

CAML query not filtering results

Can someone tell me why the following CAML query is not filtering results? It's returning files that do not contain "/Internal/Bug 594" in their FileRef value. Thanks. <View ...
2
votes
2answers
133 views

2010: How to query user profiles for custom properties?

Our sharepoint user profiles are configured to have two additional AD synchronized, public custom properties, EmployeeID and CostCenter. I need to read a list of users with the same CostCenter as the ...
4
votes
3answers
1k views

Is there a way to get Folder object from ListItem one?

This is my first post, so I'd like to say hello to everyone. I'm trying to get Folder object by its path in SharePoint 2010 client application using Client Side Object Model (.Net 4.0). I need to ...
1
vote
1answer
133 views

Problem with Caml Query

I need to put this code: <View>"; <Query>"; <Where>"; <Eq>"; <FieldRef Name='PublicY' />"; ...
4
votes
2answers
152 views

Get field values from SiteMapNode when getting Items from PortalSiteMapProvider

I'm trying to query my list using PortalSiteMapProvider. Here is my Code: public List<string> GetChachedItems(string webUrl, SPQuery query) { SiteMapNodeCollection nodeCollection = ...
2
votes
1answer
3k views

Content query web part filtering on multiple content types

Is it possible to use the Content Query web part to filter on multiple specific content types that do not have a parent/child relationship? I have a requirement to show Events (from a calendar) and ...
0
votes
1answer
202 views

Caml Query Filter SharePoint 2013 Online

Hi I'm in need of some help with a caml query. I have 1 column in my list, that have 3 different choice. I want to query out items if the choice is equal to YES This is my code: var context = new ...
0
votes
3answers
69 views

CAML-Query with Lookups

From those two lists: AVAILABLEDATES -date (DateTime) -maxBookings (Number) BOOKINGS -availableDate (Lookup to AVAILABLEDATES:Id) -User (Person) I need to get all dates that their bookings don't ...
1
vote
0answers
52 views

Is there a setting on SPField that would prevent it from being included in a CAML query?

I'm trying to build a CAML query for a managed metadata column. I'm following the guidelines provided here by Microsoft. Essentially they say to query for the term's Wssid. No problem, I can do ...
1
vote
1answer
172 views

CAML Query to sort a blog Posts list by published date

I have successfully created a CAML query to sort my list by modified date but I want published date instead. Why does replacing "Modified" with "Published" not work? They are both "Date and Time" ...
0
votes
2answers
482 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
1answer
558 views

caml query to filter by year not working

I would like to filter a list based on the year as parameter. For e.x. if i use 2014, all items from 1/1/2014 to 31/12/2014 should appear and also i am filtering on region. For the caml query below, ...
3
votes
1answer
1k views

Syntax for including fields dynamically in CSOM query?

What is the proper syntax for including fields dynamically in a CSOM listitems query? For example, this would apparently work: foreach (string field in fields) { clientContext.Load(items, includes ...
0
votes
2answers
69 views

CAML : filter items based on FieldType regardless of the Column name

In a CAML query, can you filter items which has values in the column (Not Null), based on the FieldType of the column. regardless of the Column name ?
2
votes
2answers
3k views

CAML query to filter items by Content Type, independent of column name

In a SharePoint list I have a column, created using a custom content type. Let's say, the content types is "MyContentType". I used in a column "My Custom Column". Need to filter out items if the "My ...
0
votes
0answers
23 views

CAML Query file Major and Minor Versions [duplicate]

CAML Query with Five Conditions, I have specified three conditions and two more needs to be added. Both of them should be And. How do I specify file Major and Minor History in the below query ...
3
votes
2answers
597 views

CAML query for sharepoint list not working

I have a CAML query where I am getting records between a date range for a sharepoint 2010 list through an asmx web method call. It looks like this ...
0
votes
0answers
283 views

The SharePoint list query is not valid: The required root XML element <RSSharePointList> is missing from the query

I'm trying to query Sharepoint Lists from Lists.asmx. But when inject my CAML query into Query designer it returns me the following error: The SharePoint list query is not valid: The required ...
3
votes
1answer
735 views

CAML Query on a Lookup Field that points to a Calculated Field throws Exception

I wrote some CAML Queries to get data from a List that has lookups on another List. All is working fine as long as I do not reference a Lookup Field which points to a Calculated Field. I tried ...
1
vote
2answers
607 views

Error in my CAML Query? COMException (0x80004005)

I was wondering if anyone could verify or see an error in this CAML query: SPQuery query = new SPQuery(); query.Query = string.Format( ...
1
vote
2answers
368 views

how to populate a cascading dropdownlist using caml query in asp.net using sharepoint list

I want to populate a cascading dropdownlist from a the same SharePoint list using CAML query.
2
votes
2answers
151 views

Query list types using CAML in CQWP query override?

When you export a Content by Query web part and open it up there is the <property name="QueryOverride" type="String" /> tag which allows you to put in your own CAML query to specify further ...
2
votes
5answers
972 views

How to get the nth record using CAML from list

How to get the nth record (lets say 133rd) from the 1000 records (or unknown number of records) by using CAML query.
3
votes
4answers
3k 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
195 views

Event Receiver on SharePoint 2010 - How to query DB and display an error message

I'm an absolute beginner of SharePoint development. I would like to create my first Event Receiver and I'm doing with VS2010 (because I'm on SP 2010). I would like to check if adding a new event in ...