method for querying list data

learn more… | top users | synonyms

2
votes
1answer
765 views

Search document from document library usin CAML query

I have document library which have folder and sub folder. the folder and sub folder level is more than 5. like as follow : Document Library |-> Folder-1 | -> Folder-1-1 | ...
0
votes
2answers
135 views

CAML Query Issue A or B and C

I'm trying to write a CAML query with the following parameters and I'm not having much luck. It should be simple enough but I can't figure it out. WHERE (X) EQUALS (A or B) And C I'm hoping someone ...
3
votes
1answer
4k views

How to retrieve items from document libraries using client context without performance lag

I need to retrieve items/list items from SharePoint 2010 document library and display it in a list ListView using C#. I have used following CAML query to retrieve list items and its properties. ...
1
vote
1answer
173 views

CAML Query results every time 0 items

I try to filter items in the list by using caml. The List contains elements that matches the Filter. The code: enter code here SPQuery qry = new SPQuery(); qry.Query = @" ...
0
votes
3answers
1k views

how to check CamlQuery results

.I am running below query against a sharepoint list. How to check the results of below Camlquery? cPop is set with value 'AboutUs'. Result is always zero records although list has valid matching ...
5
votes
5answers
1k views

When I execute a CAML query, how do I know what ListItem details I can include?

I was querying a SharePoint library, trying to retrieve some file attributes. Apparently some things like FileType and Date are not supported, even though those fields are listed as a built in field. ...
0
votes
2answers
349 views

CSOM list query with JOIN, return tree structure

I have two lists, Parent and Child. The Child list has a lookup field called "Parent", which "looks into" the Parent list, using ID column. Using CSOM I'm joining the lists with this query ...
0
votes
2answers
287 views

caml-query Sharepoint[2010]: CAML select several records, same ID

I have a list where IDs are not unique. How can I make a CAML Query for this list so I can get all values for a particular ID This is my list: ID Customer LOB PeriodOne PeriodTwo ...
1
vote
2answers
405 views

SPQuery always returns values

I am trying to check a list for related values but for some reason every item in the list is returned each time. I have seen this issue before and for me its always meant a bad CAML string but I have ...
1
vote
2answers
2k views

How to write CAML Query with more than 3 AND Condition

I have search and see the way how to write CAML Query with 3 AND conditions. However, I am not sure how to write CAML Query with more than 3 AND conditions may be with 4 or 5 AND conditions. Can any ...
4
votes
2answers
930 views

CAML Query for items with a text value containing square brackets

I'm attempting to query for list items using a value stored in a plain text multi-line of text field in a SharePoint 2007 custom list. My column is named FilePath and contains a value like: ...
3
votes
1answer
654 views

CAML Query OrderBy ignoring non set values

I'm currently writing some CAML Query for a QueryOverride in one of my Content Query Web Parts as I'm in need of multiple "Sort by" fields. My issue is that one of the additional fields that I need ...
2
votes
1answer
482 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) ...
1
vote
2answers
826 views

CrossListQueryInfo\SPSiteDataQuery how to skip items with specific WebId?

Customer wants to see 10 news items from all webs on front page. Also customer wants to specify some news that we should skip. I am trying to do next thing: var id =1; <Neq><FieldRef ...
3
votes
4answers
4k views

Not IN CAML Query

I have two Lists in SharePoint 2007 Clients Actions Actions list has a Lookup column called Client which takes its values from Clients List. I want to display all those clients which are NOT ...
1
vote
0answers
141 views

filtered lookup: query filter

I have a task to make a small helpdesk app :) I have a "SITE 1" where I made a custom list "APPS" with a list of applications and other custom list "MODULES" with a list of application modules from ...
1
vote
3answers
2k views

how to query multiple lists using CAML

I have requestID, date column in 4 different lists. I want to build a webpart which shows user requests of different types therefore i need to query multiple lists with column requestID and date. How ...
0
votes
2answers
299 views

How to skip few list items using SharePoint CAML?

I want to skip sharepoint items where 'location' field equals 'USA' and 'Id' equals 3 How can i do this with sharepoint CAML query? I need something like NOT for this AND: <And> ...
0
votes
1answer
826 views

How to check DateTime condition in CAML Query?

I want to fetch the records from List which are created in Last 5 minutes. I have written following code, but its not working. giving me error. <Geq><FieldRef Name='CreatedDate' /> ...
0
votes
5answers
5k views

Jquery to get list items from sharepoint list

I have a work from my time to use jquery with sharepoint. I have written the code to get list items. When I run in IE it dosen't show any errors to me, but I am not getting the results. Can any one ...
1
vote
1answer
195 views

Caml accent-sensitive

I wonder if the caml supports accent-sensitive, I'm doing a query and have many records with an accent and realized that these items are not appearing What can I do in this case? I can use any search ...
0
votes
1answer
334 views

Task list field database location changed from 2007 to 2010

What I've witnessed I've just noticed something rather annoying with SharePoint following an upgrade from 2007 to 2010. The task list schema in SharePoint 2007 had the 'Assigned To' field first. ...
1
vote
1answer
321 views

Issue while Fetching recurring items from Sharepoint Calendar

I want to fetch all the items on a particular day. Programmatically the entry is added as recurring event, Now i need to fetch all the instances of recurring event, on each day as per the date ...
0
votes
1answer
183 views

Output powershell caml query to table

This has to be real easy but I just cant find an answer on google that will work in my case. I am running a ps1 file that caml queries a document library. I just want to organize these results into a ...
0
votes
1answer
403 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
324 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
324 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
458 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
131 views

Getting Information About Deleted Item from GetListItemChangesSinceToken

When calling GetListItemChangesSinceToken, and processing deletions, the data returned looks like this; <Changes ...
0
votes
1answer
151 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
347 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
2k 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
303 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
64 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
215 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
2k 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
411 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
602 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
485 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
717 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 ...