Questions tagged [caml-query]

An XML-based language that is used to build and customize Web sites based on SharePoint Team Services from Microsoft.

Filter by
Sorted by
Tagged with
4
votes
1answer
10k views

CAML query with more than multiple AND/OR generates SPException “One or more field types are not installed properly. Go to the list settings page to delete these fields.”

I need to build a CAML query at runtime based on user input. The CAML query could be as simple as <Where> <Eq> <FieldRef Name="Status" /> <Value Type="Text">...
0
votes
1answer
698 views

CAML > get item by it's URL

Should this CAML be working. (I tried it with u2u and it does not display the URL column.) I get this error. {System.ApplicationException} = {"One or more field types are not installed properly. Go to ...
3
votes
3answers
2k views

CAML Query Maximum Size

I am running a sharepoint caml query where I want to check that a field on an item is equal to one of many values. I do this dynamically and may wish to check against many hundreds of values. I found ...
0
votes
1answer
353 views

caml query help

I'm building a webpart that queries an sp list. my list contains two fields (title, tip). title = is a single text line and tip = a yes/no check box currently in my code, i am calling all items in ...
1
vote
1answer
997 views

CAML Query get elements with most recent created date

I'm trying to get the elements with the most new created date using CAML query in sharepoint 2007. I can do it using: "<OrderBy><FieldRef Name='Created' Ascending='False' /></OrderBy&...
0
votes
4answers
34k 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 ...
2
votes
1answer
4k 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 ...
0
votes
1answer
781 views

Sharepoint 2010 ALERT settings - customize possible set of lists

I want to customize possible set of lists on which user can set "alerts ON". Customizing just ribbon button ("Alert me") for not showing on specific list isn't enough because - on some list on which ...
1
vote
1answer
614 views

CAML or C#: Change the URL of “Edit Item” of Custom List item

How can I change the target URL of "Edit Item" option of a custom list in CAML or .net?
3
votes
1answer
5k views

CAML 'Endswith' equivalent?

I have to pull the data from the custom list by using a CAML query. I would like to use the "Endswith" option in the CAML query however it seems to be unsupported in sharepoint 2007. What would be ...
2
votes
2answers
1k views

CAML Returning Tomorrow's Value when filtering Today

I have the following CAML query for SP2003 SPQuery qry = new SPQuery(); qry.ExpandRecurrence = true; qry.CalendarDate = DateTime.Now.Date; qry.Query = "<Where><And><DateRangesOverlap&...
1
vote
1answer
1k views

How do I determine the CAML equivalent for a SQL query?

I want to write an equivalent CAML query for the given SQL Query below: select top 10 * from TestTable where ItemID in ( select top 10 ItemID from TestTable order by Views desc) order by UserName ...
0
votes
1answer
180 views

CAML to search column name

I'm looking to search within each list for a column. The problem is that this column is referred to differently in CAML. Look at this for a detailed explanation: Finding the internal name and ...
2
votes
1answer
2k views

How can I use managed metadata field in the where clause of CAML?

How can I use managed metadata field in the where clause of CAML?
4
votes
2answers
1k views

CAML OrderBy and managed metadata

I have something like this: SPQuery query = new SPQuery(); query.Query = "<OrderBy><FieldRef name=\"MyTerm\" /></OrderBy>"; myList.GetItems(query); I can sort on normal fields, but ...
2
votes
4answers
17k 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
1answer
111 views

Retrieving lists from sharepoint site

I am trying to retrieve lists from a sharepoint site. I know how to do it using web services. However, the requirement is that I need to use Xelement GetList and the output should have PropertiesXML ...
5
votes
3answers
5k views

How to get last major published version?

I am trying find exact CAML query, or other possible way in code to find out "The last major published version" (not necessarily the latest)?
3
votes
1answer
2k views

Nested CAML Querie results in exception “ Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries”

All, I am trying to mimic SQL"IN" operation using CAML. Lets take a scenario where we need fetch all the ListItems with ID within a list of IDs. The target list is realy large ( 50k records) ...
1
vote
2answers
1k views

CAML statement for “top x rows” out there?

Let's say I'm querying a big list but only need a subset of the rows for demo purposes. What's the easiest way to say "Top 100 Rows" or similar in CAML? Can't seem to find a statement out there. ...
0
votes
1answer
2k views

Why is this custom view with multiple GroupBys and one OrderBy not working?

First Group By is not working (however the second file subcategory Group By works) The OrderBy is not working Show all items without folder is not working Any ideas?? private static void CustomView(...
5
votes
2answers
818 views

Get CAML from LINQ to SharePoint

Is there an equilivant to GetCommand in LINQ to SharePoint? I know about ctx.Log, but I'm looking for something to retrieve the CAML from a LINQ statement without executing it.
3
votes
2answers
2k views

CAML query get listitems between a specified Row Index Boundary

Is it possible to get listitems between a specified Row Index Boundary from a list using CAML Ex: if there are 10000 records I would like to fetch records between 201 - 250
2
votes
2answers
987 views

Retrieve using CAML the currently published version of a document

I want retrieve the currently published version of a document from a document library using CAML. Can anyone tell me how I can achieve this? I need it to get the currently published version ...
1
vote
1answer
759 views

Using SPMetal to read data from sharepoint 2010

I've just started to look at using spmetal with SP 2010 to read data from document libraries: http://msdn.microsoft.com/en-us/library/ee538255.aspx I'm curious as to how I can ensure that I only ...
3
votes
1answer
5k views

Content query web part filtering on multiple content types

Is it possible to use the Content Query web part to filter on multiple specific content types that do not have a parent/child relationship? I have a requirement to show Events (from a calendar) and ...
2
votes
1answer
2k views

How to retrieve User Information List data

I would like to filter a list based upon a user group that the user may belong to and a specific value found in the User Information List for that user. I tried doing this with CAML in SharePoint ...
1
vote
3answers
1k views

Hard code group name into CAML query

I am trying to hard code a user group into a CAML query's where clause. The reason is so that I can apply additional criteria when the user is in one group, and something else if they are in another ...
2
votes
1answer
1k views

SharePoint 2010: Full text plus faceted search over an External Content List using Search Services (or possibly FAST)

I have an External List over a products table in our database. I want to be able to build a search form over it via a full text search; in addition to being able to filter down on properties on my ...
1
vote
2answers
1k views

How to update a list item from web service using a where clause?

I have a scenario where I need to update a list item, but I don't know the internal ID of the list item - hence the following won't work for me: batchElement.InnerXml = "<Method ID='1' Cmd='Update'...
0
votes
1answer
1k views

How come GetListItems filtering on a field's equality to a value fetches this field's value as undefined/null

I think I found a bug. Please share if you know more about it. I use GetListItems operation to fetch items to display on an ajaxified form. Just an hour ago everything was fine, but now when I query ...
1
vote
1answer
921 views

Is SharePoint's ListViewXML syntax based on a standard?

Recently I had to change a ListView webpart and noticed the syntax that renders the HTML is not XSLT. Is this syntax documented somewhere? Example, <IfEqual> <Expr1> ...
4
votes
4answers
1k views

Best way to get CAML for a custom content type

I am trying to get the CAML for a custom content type that I am creating. What I am really doing is creating the content type in Visual Studio 2010 and then deploying that content type to my sandbox. ...
2
votes
2answers
4k views

“Person or Group” fields shows HTML instead of Display Name only

In Sharepoint Designer, I have a Data View Web Part which pulls data from a list. (In a normal situation) if I select a Person or Group field explicitly within the CAML for the Data Source, the ...
2
votes
3answers
2k views

CAML query filter for HTML BR tag

I am trying to create a CAML query that selects all list items that do not have just a BR tag in them. Whenever I create a query filter: <And> <Eq> <FieldRef Name="ThreadId" /&...
2
votes
2answers
672 views

How do I query several lists with the Object Model and merge the results?

Is it possible to with the Object Model query several lists at the same time and get the result merged together? Something like linked sources in SharePoint Designer? I have created a web part that ...
3
votes
2answers
2k views

How to get the last x number of splistitems changed for a SPWeb

I'm trying to pull back the last x number of list items in all non-hidden lists for a given web. My original code would go through all lists and run the following code: SPQuery query = new SPQuery();...
8
votes
1answer
5k 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 ...
6
votes
4answers
6k 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" Location="CAMLVariable"...
1
vote
1answer
440 views

Visual Studio reports fake schema validation errors. How to clean SharePoint schema cache?

I have recently generated a couple of ListDefinitions using both SPSource and VSeWSS SharePoint Solution Generator. In both cases, surpisingly, Visual Studio reports fake schema validation errors in ...
0
votes
3answers
2k views

How to replicate a query join in CAML

In SharePoint 2007, if I had 2 lists with a master/detail type relationship (via a lookup column) how would I best implement a search query across these 2 lists (for a custom search and results page). ...

1
14 15 16 17
18