method for querying list data

learn more… | top users | synonyms

0
votes
1answer
735 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 ...
3
votes
1answer
5k 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 ...
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 ...
1
vote
1answer
3k 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
297 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
2answers
527 views

How to use XmlDefinitionLink & CAML to reuse View definitions in multiple XsltListViewWebPart controls?

This is what I want to achieve (in SharePoint 2010): A custom page containing 2 XsltListViewWebPart Both of them rendering the same list data, but with different XSLT definition for display I ...
0
votes
1answer
742 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
374 views

CAML strip or remove HTML tags in custom AlertTemplates.xml

is there any way to remove the html tags for text in CAML? I have made a custom alert template when sending e-mails that uses a field that looks like this: <'GetVar Name="DisplayName#{Field}" ...
2
votes
0answers
233 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 ...
0
votes
1answer
233 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 ...
4
votes
4answers
17k views

Get Items Under Folder CAML

I am trying to retrive all items that are under a certin folder, in a document library. this is what i have so far List DocumentsList = clientContext.Web.Lists.GetByTitle(list); CamlQuery camlQuery ...
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. ...
3
votes
4answers
5k 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
2answers
10k views

CAML Query on “Person” field type

I would like to query list and get items that were created by specific user, in my list I have the fild "User" of type Person I tried this but it didn't work: <Where> <Eq> ...
0
votes
1answer
956 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
5k 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 ...
1
vote
1answer
338 views

SPQuery doesn't return all rows

I don't know why i only get one row as per below: When they are 2 rows to be returned. Am i missing something using SpQuery? Thanks in Advance string siteUrl = ...
3
votes
4answers
3k views

Caml query builder Office 365 Sharepoint Online

Does anyone knows where to find a CAML query builder that I can use for Office 365, Sharepoint Online? (if there exists one)
1
vote
2answers
1k views

CAML Query to retrieve First Name using Email Id of users in Sharepoint

I am creating a custom workflow which gets activated whenever some data is entered in a particular list. One of the field in this list is a column for Email ID of the a user( not necessarily the ...
1
vote
1answer
281 views

FilterDefinition CamlQuery

I working with custom AlertTemplate. I only want to send an Alert if field "Beställare" or "Agent" contains my UserId I Have tried with this query, but I always get an Alert when something chanches. ...
1
vote
0answers
102 views

How can i enter User information in the Data element of a list instance

For example... <Rows> <Row> <Field Name="ClassName">Programming 101</Field> <Field Name="Attendee">Domain\User</Field> </Row> </Rows> ...
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> ...
4
votes
3answers
12k views

How to build a CAML query with where clause

I have this CAML below and i'm tring to do something like this. Where username ='username' and id = 'id' <Query> <Where> <And> <Eq> ...
0
votes
2answers
455 views

Add Timespan to DateTime Column via SPServices (jquery)

I want to increase and decrease a DateTime column from a specific list with jquery and SPServices. Normaly I should first receive the original datatime and then add the timespan and after that save ...
4
votes
4answers
3k views

Help with CAML query

I have the following query but I am not sure if it does what I really want: <Where> <And> <Contains <FieldRef Name='Phase' /> <Value ...
0
votes
2answers
740 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 ...
3
votes
2answers
2k views

CAML: Possible to query non existing field?

I'm using SPSiteDataQuery to fetch list contents from 2 different lists. List A) has the fields CustomField and Title List B) has only Title Is it possible to build a (filter) query with ...
7
votes
1answer
8k views

CAML query for field of type “Person or Group” which allows multiple selections

Consider a list which has a column of type "Person or Group" (single selection) witch contains a SharePoint group. I want to return all rows for which the group is within a list. I know the IDs of the ...
2
votes
2answers
348 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) ...
1
vote
1answer
876 views

How to Retrieve Numeric Column value from SharePoint List

In the SharePoint list I am having the numeric column and the value is like this 123,456,789,012,346,000,000,000,000,000,000,000,000,000,000,000,000,000,000,000. I am using SPQuery to retrieve items ...
1
vote
1answer
602 views

SharePoint 2007 Error - some part of your SQL statement is nested too deeply

Im working with an application on SharePoint 2007, I encountered an issue where the list item unable to view. It hit error 1309 "Some part of your SQL statement is nested too deeply. Rewrite the ...
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' /> ...
2
votes
1answer
938 views

Dynamically adding And to CAML query

I have the following "base" query: <Where> <And> <Eq> <FieldRef Name='Field1' /> <Value Type='Boolean'>1</Value> ...
4
votes
4answers
9k views

CAML query not working

I have written following CAML query to Retrieve items which are due in 7 days, It doesn't seems to be working, Please let me know what I missed ? string internalEndDate = web.Lists["List ...
0
votes
3answers
340 views

Custom Lists: how to retrieve 3 most recent item submissions

I have currently 2 custom SharePoint lists. One represents questions, the other one answers. Both lists have the default columns in place: ID, modified by date and username. The requirement is now ...
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 ...
1
vote
0answers
73 views

Update SharePoint field with XML illegal characters using caml [duplicate]

Possible Duplicate: How to query using CAML when a value has < in the value I am trying to update a field named Title using caml query. The value that i am trying to put is ...
1
vote
1answer
389 views

Are CAML queries a proper way to do a full text search

Let's assume that enterprise and fast search are not an option. Are CAML queries (with CONTAINS operator) a proper way to do a full text search in fields of a publishing page? Or is that for any ...
1
vote
1answer
120 views

WebPart which displays a list with information about pages: What is the best way to search/filter this list

I have a webpart, which displays a list with information (title, creation date) about publishing pages under the current web site. Above this list there should be a search form (filter) to search ...
2
votes
1answer
2k views

CAML query Lookup column value

I have a simple list represent a hierarchy. The list columns: ID, Title, Parent, other columns. Where Parent is a lookup column back to the list itself and get information from the Title column. In a ...
2
votes
1answer
336 views

Duplicates of SPListItem when two quick requests occur

We got code, running on page load. That code asks certain SPList for its items by CamlQuery, which gets only items with specific (current) user in one field (field A) and with some value in other ...
0
votes
1answer
2k views

dynamic CAML query in DataView web part

I need to generate a dynamic CAML query for DataView web part. My requirement is similar to what is mentioned at: http://stackoverflow.com/questions/1985560/sharepoint-dynamic-caml-query-problem . ...
1
vote
2answers
542 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 ...
1
vote
2answers
670 views

SharePoint 2010 - Find WebPart in WebApplication

I´m searching for an good way to find the ContentQuery WebPart in my WebApplication. My plan is to write a PowerShell script and create a url list. I found the following possible ways: SharePoint ...
0
votes
2answers
403 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
1answer
2k views

How to get folder structure including items from list, without using webservices

I have a list containing folders and items. The folders are a custom content type based on folders, with some extra columns like URL and some Yes/No Checks. One contenttype can contain n items and ...
0
votes
2answers
794 views

Logical OR CAML Query not working

I have a query that I've written like this: <Where> <Or> <Neq><FieldRef Name='Status'></FieldRef><Value Type='Text'>Created</Neq> ...
2
votes
2answers
5k views

CAML error: “One or more field types are not installed properly.”

I'm using the U2U CAML Query Builder tool and no matter what I do, I can't create a query. It keeps generating the error: One or more field types are not installed properly. Go to the list settings ...
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 ...
6
votes
1answer
2k views

Need help with CAML in CQWP

I tried to implement a CQWP web part that could show me all the checked-out files following this guide: ...