method for querying list data

learn more… | top users | synonyms

0
votes
5answers
7k 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
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 ...
0
votes
1answer
379 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
418 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
207 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 ...
2
votes
2answers
361 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
347 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
769 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
177 views

Getting Information About Deleted Item from GetListItemChangesSinceToken

When calling GetListItemChangesSinceToken, and processing deletions, the data returned looks like this; <Changes ...
0
votes
1answer
193 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
647 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 ...
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
1answer
404 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
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 ...
8
votes
3answers
6k 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
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 ...
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
7k 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
796 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
719 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
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
101 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
3answers
985 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
1k 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
304 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
436 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
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
484 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 ...
1
vote
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
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
807 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
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 ...
1
vote
1answer
4k 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
287 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
2k 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
739 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
760 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 ...
1
vote
1answer
3k 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 ...
6
votes
3answers
822 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
441 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
510 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
57 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> ...