method for querying list data

learn more… | top users | synonyms

2
votes
4answers
2k 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
4answers
208 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 ...
0
votes
3answers
5k views

SPServices <today /> not returning correct results

This is the chunch of code that I am working with. I am trying to get only the events (normal/all day/recurring) to show, and it is returning all items for the whole week. Any ideas? ...
1
vote
0answers
973 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 ...
8
votes
3answers
7k 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 ...
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.
0
votes
1answer
656 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 ...
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 ...
0
votes
1answer
527 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 ...
0
votes
1answer
277 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 ...
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 ...
1
vote
1answer
6k 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 ...
1
vote
4answers
15k views

CAML Query to retrieve announcement items in descending order based on ID # - Not Working

spQuery.Query = " <OrderBy> <FieldRef Name='ID' Descending='True'/> </OrderBy> <Where> <Eq> <FieldRef Name='Title' /> <Value ...
0
votes
1answer
751 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
302 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
545 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
774 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
382 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
236 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
252 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 ...
6
votes
4answers
19k 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 ...
2
votes
2answers
11k 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
988 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
349 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 = ...
5
votes
4answers
4k 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
284 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
103 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
13k 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
467 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
753 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 ...
4
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
361 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
926 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
611 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
973 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
10k 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
351 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 ...