method for querying list data

learn more… | top users | synonyms

1
vote
4answers
71 views

whats wrong with my query CAML

$caml = '<Where><AND><Neq><FieldRef Name="marking" /> <Value Type="Text">Off-S</Value></Neq><Neq><FieldRef Name="marking" /> <Value ...
0
votes
2answers
50 views

Ordering CAML results

Follow up to this question: CAML is ordering by content type even though not specified I have the following query: <Where> <And> <Or> <Eq> ...
0
votes
2answers
94 views

CAML query for returning a single field

I'm trying to get a single field from a list. The list has columns like this: Office365Account - Type: Person Email Address - Type: Email Manager - Type: Person Basically what I want ...
0
votes
1answer
47 views

Query List with large number of items to perform aggregation

I have a scenario where there is one list with 3 columns : Col1, Col2, Col3 For each value of Col1 there would be 100 unique Col2 values. And for each Col2 values there would be 1000 unique Col3 ...
1
vote
1answer
57 views

caml query issue A or B

I have an issue with caml or query problem: <Where> <Or> <Eq> <FieldRef Name='Editor'/><Value Type='User'>x</Value> </Eq> <Eq> ...
1
vote
0answers
49 views

Query returns fewer fields depending on credentials

I inherited some code that reads in all the files from a Document Library for processing. The existing production library is a standard library bound to an InfoPath form. A new version of this library ...
0
votes
3answers
59 views

do you see anything unusual with this CAML

I am looking for list items where workflow status equal "Error Occurred". I have the following code and it's working fine. However, there are 124,000 items in my list and the code goes through each ...
0
votes
1answer
569 views

Using UpdateListItems for multiple items?

I would like to use UpdateListItems or something similar to allow my users to pass in some variable (e.g., a name) so I can use a caml query to find all items where SomeUserField = 'John B Smith' and ...
0
votes
1answer
126 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
107 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 ...
2
votes
1answer
3k 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
1answer
2k 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
632 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
509 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
1answer
482 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
919 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
3answers
566 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
3answers
6k 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 ...
1
vote
0answers
129 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 ...
0
votes
1answer
323 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
273 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> ...
4
votes
3answers
2k 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 ...
2
votes
2answers
272 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 ...
1
vote
1answer
196 views

Problem with Caml Query

I need to put this code: <View>"; <Query>"; <Where>"; <Eq>"; <FieldRef Name='PublicY' />"; ...
4
votes
2answers
247 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 = ...
0
votes
1answer
265 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 ...
1
vote
1answer
501 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" ...
1
vote
0answers
61 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 ...
0
votes
3answers
900 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
936 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, ...
0
votes
2answers
73 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
6k 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 ...
3
votes
1answer
3k 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
3answers
313 views

Unable to fetch tasks from all the task lists in SharePoint 2013 using CAML

following is my Query:- SPSiteDataQuery oQuery = new SPSiteDataQuery(); oQuery.Lists = "<Lists ServerTemplate=\"171\" />"; oQuery.Query = ...
1
vote
2answers
1k 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
555 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
197 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 ...
3
votes
3answers
928 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 ...
2
votes
3answers
514 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 ...
2
votes
1answer
258 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 ...
0
votes
1answer
194 views

Why is my CAML query for my list view not valid: filtering a date and membership of created by

The below query works only for each segement alone. Either: <And> <Geq> <FieldRef Name="Von"/> <Value Type="DateTime">{startdatum}</Value> </Geq> <Leq> ...
0
votes
0answers
68 views

Get SPListItem by title is very slow

I want to get a SPListItem by title. I´m using a caml query to filter the list (Around 1000 items). There is only 1 item with the title in the list. My problem is now that the performance is really ...
0
votes
3answers
72 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 ...
2
votes
2answers
641 views

Looping retrieved Items throws an InvalidCastException

I have some very simple code using the client object model to retrieve a list and all items from that list from a SharePoint 2013 Online site. When the ExecuteQuery() fires, I use Fiddler to view the ...
1
vote
0answers
989 views

How to query the list using CAML Query to List's multi allow user field?

I have a list in which there is one column which is of type People or Group with multi allow. I have created Item Adding event receiver in which I am checking the entered people value is already ...
0
votes
1answer
130 views

Help with complex CAML query

I am wondering if the following CAML query structure is correct: I appreciate your help. <Query> <CalendarDate><Today/></CalendarDate> <Where> <And> ...
5
votes
3answers
455 views

CAML query on external list: access denied by business connectivity services

I am trying to run a CAML query on a BCS list and getting access denied as an error when debugging the code: SPList CMList = web.Lists[Constants.cmlist]; SPQuery query = new SPQuery(); query.Query = ...
0
votes
3answers
270 views

CAML query with Five Condtion throws an Microsoft.Sharepoint.SPException

string query = <Where> <And> <And> <And> ...
3
votes
1answer
869 views

CAML Query works on hardcoded value, but not on variable

I am really new to SharePoint, and I came across an issue that is driving me crazy. I am trying to use CAML Query to get a specific list item. My query works on hard coded condition, but not when I ...
5
votes
2answers
9k 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> ...