method for querying list data

learn more… | top users | synonyms

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
707 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
670 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
799 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
426 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
478 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
405 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
205 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
793 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
2k 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
240 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
496 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' ...
3
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
390 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
771 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
673 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
615 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
675 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
251 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
983 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 ...
1
vote
1answer
5k views

CAML Query to filter a list item based on comparing item[“Title”] to ascx label.text control?

"<Where><Eq><FieldRef Name='Title' /><Value Type='Text'>'Label1.Text'</Value> </Eq></Where>"; I have not run this and checked yet, simply because I ...
0
votes
1answer
2k views

How can I pass a Query String variable into the CAML of a jQuery script?

I'm using Marc's SPServices jQuery library - the SPFilterDropDown script - to filter the items in a Lookup multi-select field on a New Item DVWP. It works fine if I stick some static text in there - ...
0
votes
1answer
294 views

How can I test a CAML query using mocking?

I have a CAML query in a class and I'm using unit test to cover my code with some proper test. For the SharePoint classes and stuff, I use TypeMock to mock the SharePoint objects. I would like to ...
0
votes
1answer
218 views

The multi-part identifier “t16.nvarchar1” could not be bound

MOSS2007 with SP3. I have a list with many items. From code I get items using simple criteria. (give me all products that have DeliveryDate between in a specific time interval and the field Customer ...
2
votes
0answers
217 views

How to (caml)query a list on metedata in the MetaInfo field

Is it possible to wite a CAML-query to filter documents with certain info in the MetaInfo field? The information is only stored as property in MetaInfo, not in a field of it's own. Context: I have a ...
1
vote
0answers
1k views

ProjectedFields working in SPQuery but not in the View

I've three lists: Competitions, Works and WorksVotes, linked to each other through Lookup fields. WorksVotes list has Lookup field to Works list, and Works list has Lookup field to Competitions list. ...
0
votes
3answers
11k views

CAML, get all list items where text field contains a value?

I would like to use CAML to write an efficient query to get all items in a list where a text field contains a value... for example: **ID Name** 123 234 ...
0
votes
1answer
858 views

SPQuery works on ListViewByQuery but not with GetItems

In one of my webparts, I have a ListViewByQuery displaying some elements (or all) of a specified list. The SPQuery is built dynamically depending on the search fields. Here is how I build the ...
6
votes
3answers
4k views

Caml to get today's birthdays

I have a list with birthday field (DateTime). How do I write caml query to retrieve only the records where birthday falls on today (i.e. only comparing day and month value of birthday column to ...
2
votes
2answers
342 views

Is there any guidance on designing lists for efficient CAML queries?

I'm designing some lists that may well contain thousands of items, and I'm trying to come up with the best design for efficient querying. I'm looking for some form of (hopefully Microsoft) ...