method for querying list data

learn more… | top users | synonyms

4
votes
2answers
2k 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
876 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 ...
1
vote
2answers
2k views

CAML OffsetDays

please help if it possible that CAML OffsetDays is not working in DvWP? I use the following CAML within a DVWP: <View><Query> <Where><And> <Lt> <FieldRef ...
2
votes
1answer
696 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
141 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 ...
1
vote
0answers
162 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
2answers
355 views

Multiple CAML query to filter Data list view

My Custom list have four columns(Doc ID, Created by, Assigned To, Assigned date). I want to filter the data in Data list view. In my page there are 4 text boxes and a Button is there for the user ...
1
vote
3answers
3k 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
1answer
721 views

How to change a date format in CAML

I got a wrong date format to a CAML. I have got (yyyy-mm-dd) and must to be understand by CAML to the format(dd-mm-yyyy), how can I do this. I tried by String.Format("{0:yyyy-mm-dd}", dateISO1);, but ...
3
votes
1answer
644 views

CrossListQueryCache().GetSiteData(contextWeb) throws NullReferenceException on second query?

I have an auqward problem that's been nagging me on and off for half a years time. It turns out, when I'm finally taking a real shot at it that my query throws a NullReferenceException the second time ...
0
votes
2answers
360 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> ...
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 ...
1
vote
2answers
1k 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 ...
2
votes
1answer
223 views

ContentTypes and Site Columns via Visual Studio / CAML Query Updates broken

I've been using CAML queries to do list updates for quite some time, but recently they've stopped working, and I have no idea why. Even an extremely simple query seems to be failing. For example the ...
0
votes
1answer
1k 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' /> ...
1
vote
1answer
292 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 ...
2
votes
2answers
1k views

Error in CAML Query with multiple “AND”

When I run the following query I get an error: <Where> <And> <Eq> <FieldRef Name="IssueLOB" LookupId="TRUE" /> <Value ...
0
votes
1answer
208 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
586 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 ...
1
vote
2answers
352 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
3k 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
773 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
178 views

Getting Information About Deleted Item from GetListItemChangesSinceToken

When calling GetListItemChangesSinceToken, and processing deletions, the data returned looks like this; <Changes ...
0
votes
1answer
194 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
652 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
44 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 ...
0
votes
1answer
405 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
81 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 ...
2
votes
2answers
362 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 ...
10
votes
4answers
4k 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
2answers
7k views

SPListItemCollection Get ItemCount with rowlimit

I am filtering a list in caml SPQuery oQuery = new SPQuery(); oQuery.Query = "<OrderBy><FieldRef Name='FullName' /></OrderBy><Where><Contains><FieldRef ...
2
votes
1answer
268 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 ...
1
vote
1answer
608 views

“Not in” membership caml query

In a custom list definition, I'm building a view with this query : <Where> <Or> <Membership Type="CurrentUserGroups"> <FieldRef ...
1
vote
1answer
419 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 ...
1
vote
2answers
802 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> ...
0
votes
1answer
381 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
562 views

Expand recurrence and CalendarDate:Event EndDate not autocalculated for recurring events

I have done the following code to save a recurring entry to Calendar List named Bookings. SPSite site = new SPSite(SPContext.Current.Web.Url); using (SPWeb web = site.OpenWeb()) { ...
0
votes
3answers
3k 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 = @" ...
1
vote
1answer
102 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 ...
5
votes
5answers
20k views

How to get current user with javascript?

I have a list . I want select items of list with a special quary.(get items that created with current user). Then get count of items. I use this code for get current user : function Initialize() { ...
0
votes
2answers
3k 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 ...
0
votes
2answers
308 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 ...
0
votes
1answer
110 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
2k 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
485 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
1answer
638 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 ...
1
vote
2answers
720 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 ...
2
votes
1answer
9k 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
808 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? ...
1
vote
2answers
166 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 ...