method for querying list data

learn more… | top users | synonyms

0
votes
1answer
474 views

Paging caml query results

I have about 1000 items in a custom list. i want to retrieve 10 only from a certain position, (i know how to do this). I also want to get the total in the list. How would i do this? (this is for ...
2
votes
2answers
340 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 ...
1
vote
2answers
329 views

CAML Query List by months

I was wondering if i have 3 random dates. 11/12/2012 9/24/2011 12/29/2008, I'd like to have September 9/24/2011 November 11/12/2012 December 12/29/2008 instead of using the query to sort by ...
2
votes
2answers
2k views

what does “ows” means and why people use it before name of a field

I seen at different places if a field has a name "LinkFilename" then while trying to get its value using CAML query or any other way, developers put it as "ows_LinkFilename", can someone explain it to ...
1
vote
2answers
549 views

CAML Query for Values Not “In” (with sufficiently different title to let me post the question)

I have the following CAML query: <Where> <In> <FieldRef Name='ObjectID' /> <Values> <Value Type='Integer'>71</Value> <Value ...
0
votes
1answer
151 views

Getting Information About Deleted Item from GetListItemChangesSinceToken

When calling GetListItemChangesSinceToken, and processing deletions, the data returned looks like this; <Changes ...
0
votes
1answer
170 views

How authentication is done when using a CAML query for SharePoint List in a console application

I am try to develop a console application in Visual Studio which uses CAML query to get data from SharePoint List. The question is, how does the console application authenticates from the SharePoint ...
6
votes
1answer
401 views

How to Combine IN-Opeator with LookupIds in a caml-query?

I want to build a CAML - Query using the IN - Tag. The queried Column is a lookup-field to a Title of another list. When I query using the text-property everything works fine: <Where> ...
0
votes
1answer
43 views

CAML to get content of referenced list

i got a CAML-Query, which (essentially) pulls the IDs from a lookup field. Then i got another one, which querys the target of the lookup to get the date from that list. So is there a possibility to ...
10
votes
4answers
3k views

CAML Now Instead of Today - CAML Bug?

I have a CAML query, in which the <Where> node looks like: <Where> <Leq> <FieldRef Name='PublishedDate'/> <Value Type='DateTime'> <Today/> ...
0
votes
1answer
344 views

How to get week birtdays

I have a list called profile, and this list contains the Birthday field, is a field of type DateTime. I created two fields of type calculated, one gets the day, and the other gets the birthday month ...
0
votes
1answer
67 views

CAML search ignoring diacritics

A rather strange request has appeared from our client, who wants to be able to search a SharePoint 2010 list for items (based on a string column) while ignoring diacritics. A quick example, assuming ...
0
votes
2answers
2k views

Retrieve items from one column in a list using CAML and bind that data to dropdownlist

I want to retrieve a column items from the list. My list contains two columns. I want to retrieve first column items and those items should bind to the drop down list. I am doing this in a web part. I ...
8
votes
3answers
5k views

How to write CAML queries filtering on ModStat (Approved, Rejected) when using Language Packs?

When using content approval the CAML for retrieving (say) just Approved Items is <Query> <Where> <Eq> <FieldRef Name="_ModerationStatus" /> <Value ...
2
votes
1answer
243 views

Should we use web service lists.asmx over CAML when working with large lists

There is a list that has around 100k items in a SharePoint Site Collection. This site has been customized to serve certain business requirements through visual webparts. While, regular CRUD ...
0
votes
3answers
2k views

Current User Task using CAML Qurey

Here's my query to get current user task using CAML but it's not working SPUser me = web.CurrentUser; SPList list = web.Lists["Tasks"]; SPQuery qurey = new SPQuery(); qurey.Query = @" ...
0
votes
4answers
3k views

Where can I find a good CAML tutorial?

I am just starting to get my feet wet with SP Foundation 2010, and need to customize some web parts. I am looking for some CAML tutorials that go beyond what's on the MSDN site, and also include the ...
1
vote
4answers
6k views

get all document from all folder and subfolder from document library sharepoint 2010

I want to retrieve all documents from folder to it's subfolder and so on using client object model.Please help me.
6
votes
4answers
4k views

Where can I find a list of CAMLvariables and ServerVariables?

Having some trouble finding a list of these variables. Any help would be greatly appreciated. More specifically, when I see this on the page: <ParameterBinding Name="UserID" ...
1
vote
2answers
542 views

Lists.GetListItems Query for items with a specific author

I am trying to query a list in SharePoint 2007 to get the items of the list that were created by a specified user. Here is my CAML: <Query> <Where> <Eq> ...
1
vote
2answers
652 views

Simple SPQuery throws error

I am trying to pull populate a lookup field using a lookup value without the lookup ID. I am getting the error: "One or more field types are not installed properly. Go to the list settings page to ...
3
votes
1answer
500 views

Using part of date in CAML query

I want to create new view for my list. The list contains a column called Year, which is a number and contains, as name suggests, year. Eg.: 2012 2011 2010 2009 I would like create a view, where I ...
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 ...
1
vote
1answer
100 views

I need help with creating CAML

I have a document library MyLib and i need to find specified file in it . query.Query = @" <Where> <Eq> <FieldRef ...
0
votes
0answers
1k views

Join With Camlquery for Lookup Column Field

there are 3 List on My Scenario : 1) Tasks : Columns like this : (Column Name) Title -------------------------- TitleTest TitleTest2 2) List1 : Column ...
0
votes
3answers
816 views

What is the difference between CamlQuery and SPQuery

Maybe a simple question, when to use CamlQuery and when to use SPQuery ? I think that SPQuery is used inside a WebPart running on the SharePoint server, and that CamlQuery is part of the Client ...
0
votes
3answers
913 views

What's wrong with this CAML query?

The And block of Field3 is being ignored. It doesn't matter if the text matches or not. What's wrong here? <Where> <And> <Eq> <FieldRef Name='Field1' /> ...
0
votes
2answers
254 views

SQQuery, Dates and Regional Settings

First, some setup: My Site is set to Eastern Time, and the server is located in Eastern Time. I'm trying to run a query against a list using the created date. I have tried using all variations I can ...
2
votes
2answers
334 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" ...
0
votes
1answer
105 views

A column is not appearing in GroupBy option when editing view

I have a document library created from a custom content type (which inherits from Document type). The Document Libraries are created via feature activation using CAML in the Elements and a List ...
0
votes
1answer
1k views

SPServices: How would I add Ascending=False to CAML in GetListItems

How would I use SPServices GetListItems and still be able to add Ascending=False to the CAMLViewFields? I haven't used this for long and I am just wondering if this is possible? Thanks as always!
0
votes
1answer
410 views

how to query greatest ID of each value in a Sharepoint list?

I have a list with two columns (ID,Value). I want grouped list with value columns then select greatest Id of it. ID | Value 1 | 101 2 | 305 3 | 102 4 | 101 5 | 305 6 | 101 Result : ID ...
0
votes
2answers
1k views

Is <QueryOptions> valid in SP.CamlQuery for meeting work space

I'm trying to query all items in a meeting workspace list. I'm trying a query I think should work, but still only returns items specific to the instanceID. Is there a different flavor for client side ...
2
votes
1answer
7k views

How to use GroupBy in CAML query

I have simple list, consisting of 2 columns - Date, Order. Now what I want to do, is to GroupBy Date and count orders. So, for example if I have following items Date Order 08/10/2012 5 ...
2
votes
1answer
704 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? ...
0
votes
1answer
3k views

Get URL of image from Picture Library using CAML

How is it possible to get the URL of an image that is stored in a Picture Library using CAML? Currently, I've made a CAML Query and run it in the U2U CAML Query Builder, and am seeing values like ...
1
vote
2answers
154 views

Dynamically assemble CAML to call related List Items?

I have good methods in place to get my core List of Posts. Let's say I get the 100 most recent Posts. I'd like to get all comments related to those posts. Comments have a field called PostID that ...
1
vote
1answer
3k views

Adding IsNotNull and ViewFields in CAML Query

Trying to add IsNotNull parameter and ViewFields paramter but throwing an error. Am I inserting incorrectly or missing something to make sure this executes correctly? Seems like View is bring back all ...
1
vote
1answer
268 views

Get all webs with certain property value

If I have a certain number of webs within my site collection, and those web have set some property, eg. web.Properties["foo"] = "bar". I'd like to get list of all the webs which have property foo set ...
0
votes
1answer
1k views

How do I use a variable in CAML query to send approriate email

I have created two list. One is "Storage" the other is "Approvers" I am able to retrieve all values in the column 'System' in the "Storage" list by iterating through the column list, like so and ...
0
votes
1answer
94 views

CAML Query assistance

I have a query I created using U2U CAML query. I am able to retrieve all the information within the builder, but when I use in VS I am returning everything seems like. Unless while debugging I am ...
2
votes
4answers
1k views

where clause is ignored when query list

I have a CAML query which returns lists by a lookup field. here is the query <Query> <Where> <Eq> <FieldRef ...
0
votes
2answers
687 views

FullTextSearch: SPSiteDataQuery on each request vs. caching data and filter in code

I'm implementing a full text search on list contents. Is it more efficient to fire a SPSiteDataQuery on every request with a dynamically built CAML-Query, to filter the items? Or is it better to ...
1
vote
2answers
608 views

comparing and modifying items in a list

Ok, so adding to my previous question here - I want to get certain columns from a sharepoint list, then compare values of those columns to items in my own c# list and, if they're different, modify ...
0
votes
1answer
2k views

CAML query for null lookup field values

I have a problem with filtering list items using CALM I Have this list: Code - Text, Name - Text, Link - Text, Order No - Number, Parent - Lookup to this List. I want to filter all items where Parent ...
0
votes
1answer
2k views

Getting items from rows 4-8 in a Sharepoint list using CAML query?

Here is the code Im using to retrieve the first 4 most upcoming announcements from the OOTB announcements list in sharepoint: How do I modify this to retrieve the next 4 (5,6,7 and 8) most upcoming ...
5
votes
3answers
787 views

sharepoint caml is fast - how?

We all know that Caml is faster than using linq, since linq internally gets translated to caml. But can anyone explain how caml is best to do sharepoint queries or how it is fast or what makes it ...
1
vote
1answer
416 views

How to check if a record doesn't exist in another list

I have listA and another ListB When i a user views an item in ListB there is a custom button that the user clicks. Now when the user clicks the button i insert some rows into ListA which are: ...
0
votes
1answer
470 views

Logical AND ,OR CAML Query not working in External List

I am using ClientContext Class and CAML query to retrieve items from External List in sharepoint 2010.I have built the query with Logical AND Condition in CAML Query like this string sDataFilter ...
2
votes
0answers
56 views

How to avoid loosing complex query in a view?

In a custom list definition bound to a custom content type, I attached the out of the box AssignedTo field. In the schema, I defined a view with this query : <Query> <OrderBy> ...