method for querying list data

learn more… | top users | synonyms

2
votes
2answers
5k 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 ...
2
votes
2answers
196 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
2answers
163 views

moving list items from wss 3.0 to foundation 2010 using lists.asmx

I'm trying to use Lists.UpdateListItems to move items from a list in WSS 3.0 to a list in SharePoint Foundation 2010. The original list contains several items. The target list does not contain any ...
2
votes
2answers
382 views

CAML Query behaving differently in CAML Builder and Code

Based on feedback from my earlier question, I have constructed a query using the excellent CAML Builder tool: <Where> <Or> <Membership Type='CurrentUserGroups'> <FieldRef ...
2
votes
1answer
971 views

Does an OrderBy CAML query return ONLY the most recent items?

var query = new SPQuery { Query = "<OrderBy><FieldRef Name="Created" Ascending="False" /></OrderBy>", RowLimit = 100 }; Does this return the 100 most recently created items? ...
2
votes
2answers
374 views

Is there any guidance on designing lists for efficient CAML queries?

I'm designing some lists that may well contain thousands of items, and I'm trying to come up with the best design for efficient querying. I'm looking for some form of (hopefully Microsoft) ...
2
votes
3answers
3k views

Problem using viewFields to return more fields

Do I have to put a prefix of ows before retrieving fields? because I am trying to obtain additional fields and not being able to? soapEnv += "<listName>My SP List</listName>"; ...
2
votes
2answers
534 views

DefaultValue for CAML Variables

I have a question sort of related to this post. The default value of the CAML variable UserID is the CurrentUserName. Can that be set to different properties or is that fixed? For example, could ...
2
votes
2answers
2k views

CAML query get listitems between a specified Row Index Boundary

Is it possible to get listitems between a specified Row Index Boundary from a list using CAML Ex: if there are 10000 records I would like to fetch records between 201 - 250
2
votes
1answer
4k 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 ...
2
votes
2answers
2k views

How to get the last x number of splistitems changed for a SPWeb

I'm trying to pull back the last x number of list items in all non-hidden lists for a given web. My original code would go through all lists and run the following code: SPQuery query = new ...
2
votes
1answer
2k 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 ...
2
votes
2answers
267 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 ...
2
votes
1answer
256 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 ...
2
votes
2answers
632 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 ...
2
votes
1answer
5k views

Get List Items using ECMAscript CAML query

Hi can anyone show me how can I retieve list items based on 2 fields using ECMAscript CAML? I have a list where I have uid as number and city as text. I want to retrieve all items where uid = 100 and ...
2
votes
1answer
1k views

Caml Query - skip X first results

Let's assume I have list with 100 items. Is it possible to write CAML query to get 5 items, but skip 10 items from the beggining? Something like LIMIT and OFFSET in SQL?
2
votes
2answers
3k views

COM exception while querying document library

I have a need to get collection of SPLitsItem currently viewed to user. My solution is a ribbon button which calls custom application page in LAYOUTS via javascript in custom action. Application page ...
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> ...
2
votes
2answers
1k views

How do I test if I will be able to execute a query (does the site exist)

When I run a (CAML based query) executeQuery against Sharepoint, sometimes the site does not exist (it is created by a workflow process which may not have run). When this happens, I get a ...
2
votes
1answer
1k views

Nested CAML Querie results in exception “ Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries”

All, I am trying to mimic SQL"IN" operation using CAML. Lets take a scenario where we need fetch all the ListItems with ID within a list of IDs. The target list is realy large ( 50k records) ...
2
votes
2answers
646 views

Retrieve using CAML the currently published version of a document

I want retrieve the currently published version of a document from a document library using CAML. Can anyone tell me how I can achieve this? I need it to get the currently published version ...
2
votes
2answers
2k views

“Person or Group” fields shows HTML instead of Display Name only

In Sharepoint Designer, I have a Data View Web Part which pulls data from a list. (In a normal situation) if I select a Person or Group field explicitly within the CAML for the Data Source, the ...
2
votes
3answers
1k views

CAML query filter for HTML BR tag

I am trying to create a CAML query that selects all list items that do not have just a BR tag in them. Whenever I create a query filter: <And> <Eq> <FieldRef Name="ThreadId" ...
2
votes
1answer
115 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 ...
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 ...
2
votes
1answer
132 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 ...
2
votes
3answers
509 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
374 views

CAML Query Custom Ordering

I have looked around a bit, but have not found any reference to this particular issue. Is it possible to specify a custom ordering in a CAML query? What I mean by this is, say I have a list with a ...
2
votes
1answer
1k views

CAML query join and sort by column of projected fields

I am trying to execute the following query: query.Query =<Where> <IsNotNull> <FieldRef Name='Product' /> </IsNotNull> </Where> <OrderBy> <FieldRef ...
2
votes
1answer
273 views

Can we query and fetch data from LIST between different subsites using CAML Query.?

Have LIST created under one site, can the same LIST be used to fetch data from other site using CAML Query.? eg: Consider a LIST "xxx" created under SitePages/AAA/Lists/ Can i access the LIST "xxx" ...
2
votes
1answer
850 views

CAML query speeds

So I have a list of about 75,000 items. I want to know if I perform a CAML Query that returns a couple of hundred items, is that going to be slow? (slow = 10+ secs, med = 5-9 secs, fast 0-4 secs) ...
2
votes
1answer
154 views

Help Return Lists With With No List Items

This is my first time posting and I'm looking for some help, so hopefully someone has an answer. I used the search, but didn't find anything. I created a custom list definition, and content type ...
2
votes
5answers
1k 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.
2
votes
2answers
552 views

How to Add a ListItem?

I am able to add an item to a list using the CAML below. Now I need to modify it to make sure I can add an attachment as well. What is the syntax to add an attachment? <?xml version="1.0" ...
2
votes
1answer
2k views

CAML query Lookup column value

I have a simple list represent a hierarchy. The list columns: ID, Title, Parent, other columns. Where Parent is a lookup column back to the list itself and get information from the Title column. In a ...
2
votes
1answer
354 views

Duplicates of SPListItem when two quick requests occur

We got code, running on page load. That code asks certain SPList for its items by CamlQuery, which gets only items with specific (current) user in one field (field A) and with some value in other ...
2
votes
1answer
2k views

How to make a CAML Query union?

I have a webpart with several CAML Querys that look like this: SPSiteDataQuery qry = new SPSiteDataQuery(); qry.Lists = "<Lists ServerTemplate='104' Hidden='TRUE' />"; qry.Webs = "<Webs ...
2
votes
4answers
2k views

CAML query to find a value that does not begin with

I want to build a CAML query to search for all title fields that do NOT begin with a certain value: something like this: Where Title NOT BeginsWith 'myvalue'. How can i do that in my CAML query?
2
votes
2answers
4k views

What does the GetListItems query option IncludeMandatoryColumns do?

I found myself working with the Lists.GetListItems method fairly often. Unfortunately, I have never understood what the IncludeMandatoryColumns query option actually does. The documentation seems to ...
2
votes
1answer
3k views

ClientContext + camlQuery.ViewXml

I use SP Client and want to return ListItemCollection which will be filled with items from specific view which I choose. I get ViewQuery string by sending view index in viewcollection. Problem is in ...
2
votes
1answer
1k views

How can I use managed metadata field in the where clause of CAML?

How can I use managed metadata field in the where clause of CAML?
2
votes
2answers
49 views

Get document from document set by caml query

I have a requirement to fetch a single document from a document set. I have 5 different custom content types that have document set as the base type. Each document set has numerous documents. I want ...
2
votes
0answers
28 views

Camlquery with date comparison

Cannot get this to Work, it returns all rows. Anyone? <Query> <Where> <Geq> <FieldRef Name='Modified'/> <Value Type='DateTime' ...
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 ...
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 ...
2
votes
2answers
494 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> ...
2
votes
1answer
2k 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 ...
2
votes
2answers
2k views

Caml query to get the next event from calendar

I'm facing a problem building a caml query for the calendar list. Here is my caml query SPQuery query = new SPQuery(); StringBuilder sb = new StringBuilder(); ...
2
votes
1answer
350 views

CAML batch query - valid XML?

The standard format of a CAML batch query is as follows: <?xml version="1.0" encoding="UTF-8"?> <ows:Batch OnError="Continue"> <Method ID=""> ...