method for querying list data

learn more… | top users | synonyms

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
444 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
8k 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
746 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
160 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
276 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
713 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
699 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 ...
6
votes
3answers
807 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
430 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
486 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> ...
3
votes
2answers
5k views

Filtering items in a view using a CAML query

I'm having trouble querying SharePoint in such a way, as to combine a view results with my own CAML query inside a WCF service. It seems GetItems ignores my query, and just returns all the items in ...
1
vote
1answer
409 views

CAML query and jQuery to retrieve last item's fields

I want to get list item fields where its the last item that the same user created. Then I want to populate the newform.aspx with some of these items. I'm mainly stuck with the query and how to write ...
4
votes
1answer
1k views

CAML: Filter URL field on description (not on URL)

I have a list with an URL-field. Nothing special, just the OOTB Hyperlink-field. I want to execute a CAML-query that selects items with a certain value in the description part of the URL-field. CAML ...
1
vote
0answers
116 views

Sharepoint - caml join with numbers

I have done a join in Caml with my list (example list A) to another list (example list B) One of the fields in list B is a number of 2 decimal places. However, in the view it is displaying lots of ...
0
votes
0answers
207 views

How to create charts with custom filters about sensitive data using JS without using external APIs?

I need to create charts out of business data which comes out of SharePoint lists in SharePoint 2010. The solution needs the ability to easily filter the data by custom queries, just like the SPJS ...
1
vote
1answer
2k views

CAML Query to pull list items only if their approved?

Although the solution seems relatively strightforward it doesnt seem to work. Here is my CAML query to pull all items from a list that have been approved through the OOTB Sharepoint Approval ...
2
votes
2answers
818 views

CAML query to retrieve the second set of three list items from the announcements list?

The CAML query to pull say 3 items based off of the following requirements seems pretty starightforward: Title is not null Expires(Expiry Date) is greater than or equal to Today Order Created in ...
0
votes
2answers
220 views

SharePoint list query efficiency

I'm trying to build a very high performance application on top of SharePoint 2010. One thing I'm having a hard time deciding is if I should make 2 list queries (1 small and 1 large) or if I should ...
2
votes
2answers
6k views

Using Date offset in CAML query

In SharePoint 2010, Inned to get items from a list based on a condition. Considering one of the fields to be 'EventDate' of type DateTime, the condition is: (EventDate - 60 Days) <= Today <= ...
0
votes
4answers
6k views

How can I Create a join between two sharepoint custom list using CAML Query?

Will you please provide me help to create a join between two SharePoint lists using CAML Queries. I am using SharePoint 2010 Development Platform. Thanks in advanced.
0
votes
2answers
3k views

SPQuery for Selecting/Excluding Hidden columns from a SPlist

I am trying to take a DataTable containing ID and other columns which are not hidden. I am doing this for a generic list which contains any number/type of columns. so I don't know the field names ...
0
votes
0answers
79 views

CAML : How to Join Two List in CAML Query? [duplicate]

Possible Duplicate: How can I Create a join between two sharepoint custom list using CAML Query? I have been asked this question in interviews a lot and I am still trying to figure out what ...
0
votes
1answer
241 views

Display ManagedMeta using xslt

I am showing the results of query against a document library within a dataformwebpart. The managed meta data field is named 'Tags'. The output to the page of this column looks like 3;#test;#2;tos ...
1
vote
2answers
506 views

How to order all day events on a calendar

I have a calendar list with a choice called "Category" with items A,B,C,D. I want to sort the all day events that are shown based on the selected category. I tried to set the Orderby ...
2
votes
1answer
9k views

caml query to get listitem by Name field

I am trying to check if a filename exists in the 'Name' column of Shared Docs Library. I think only CAML could help here. So I made this query "<Where><Eq><FieldRef Name='Name' ...
4
votes
1answer
3k views

CAML query recurrent events problem

Here is the code I use: SPQuery query = new SPQuery(); query.ExpandRecurrence = true; query.CalendarDate = new DateTime(2013, 1, 1); query.Query = @" <Where> <DateRangesOverlap> ...
0
votes
1answer
2k views

Is it required to specify the value type in a CAML query?

I was wondering if CAML query Value Types are strongly typed or not. It would save me some time if I didn't have to specify "text" or "date" every time I made a query. Here is the code I am using, ...
1
vote
2answers
2k views

How to get List Item from sharepoint list based on ItemID

Dynamically I am adding radgrid to the page. I need to retrieve list item from the SharePoint list. Say I have 10000 items in the list using SPQuery, I will get filtered records as 2000 items. Here ...
0
votes
2answers
391 views

How can i access sharepoint using LINQ instead of CAML?

is there any way to access Sharepoint lists via LINQ instead of CaML?
0
votes
4answers
206 views

Should I learn CAML? [closed]

I've been spending the last few days studying sharepoint and plan to work with it for a long time - but I've only just heard the word CAML mentioned and seen it's querying in action, is it something ...
3
votes
1answer
4k views

CAML and External List - pass parameter to ReadList (finder) method

I have a Finder method defined on an External Content type (created with Visual Studio). Whan That method receives a parameter. So the method is something like ReadList(string partnerName). I have ...
0
votes
2answers
2k views

Populating a simple custom Event Web part that retrieves information from the OOTB calendar web part

I have a requirement to build a Event web part that shows the 5 most upcoming events and a see all link (that links to the OOTB calendar view). Here is a graphical representation: How exaclty do I ...
2
votes
3answers
2k views

The <today/> tag not working in my CAML Query?

I am trying to retrieve the 5 most upcoming (with respect to expiry date) announcement list item "Title's".The query partly works but what it fails to do is include and display todays announcements as ...
1
vote
0answers
785 views

Nintex Workflow Query Lookup Filter not working for User field [closed]

So I have a nintex workflow where a username is extracted from an infopath form via Query XML. Confirmed that it comes out into the user variable (of type person or group) in the format DOMAIN\USER ...
0
votes
1answer
695 views

SharePoint Object Model: how to query ONLY last major version of data from Publishing Page?

I came into a situation where I wanted to use SharePoint Object Model SPSiteDataQuery to query data from Publishing Page. However, I dont want the data query based on the permission on current login ...
0
votes
1answer
622 views

Caml query returning multiple lists

Trying to load a list from library containing two files. The following code when tested in CamlBuilder it is returning single row according to the filename selected. But in the program it is returning ...
0
votes
1answer
686 views

Rendering IMAGES (attached to announcement list) in my custom web part?

Please bear with me as I am brand new to the whole sharepoint world. I want to be able to display images that have been attached to OOTB announcement list in a custom visual web part I am trying to ...
0
votes
1answer
253 views

Filter list based off a set of IDs

I've written a web part that generates several KPIs based off a list given: - List and column names placed in custom configuration values - Parameters at run time Each KPI is composed from a set of ...
3
votes
1answer
1k views

Content Query webpart- CommonViewFields vs ViewFieldsOverride

I'm reading up on the Content Query web part and based on this page, I can't understand the difference between the CommonViewFields property vs the ViewFieldsOverride property. How are they different? ...
1
vote
2answers
2k views

Using the Now() function in CAML Query?

i am trying to get the 3 most upcoming events from the current date and time (The current data and time refers the time everytime my web part loads. Basically it is not a fixed date and picks up the ...