Collaborative Application Markup Language (CAML) is an XML-based language that is used in Microsoft SharePoint Foundation to define the fields and views that are used in sites and lists.

learn more… | top users | synonyms

1
vote
1answer
175 views

extend caml token ?

is there an hook or interface or whatever that could be used for extending token functionality of sharepoint? For example [Me] token is insufficient for me and I would like to for example develop my ...
2
votes
2answers
2k views

CAML Query for sub folder documents javascript

I'm trying to query for documents in a specified sub folder of a document library. Using U2U CAML builder, I can generate the query and return successfully within it. However, when I run the query ...
2
votes
0answers
348 views

How to find out whether or not a list is hidden without writing code (SP2010)?

Does anyone know if there is a way of telling (without writing any code) whether or not a list is "hidden"? I have a CAML query which contains the following and I'd like to eliminate the possibility ...
0
votes
2answers
178 views

CAML Query Issue A or B and C

I'm trying to write a CAML query with the following parameters and I'm not having much luck. It should be simple enough but I can't figure it out. WHERE (X) EQUALS (A or B) And C I'm hoping someone ...
1
vote
1answer
226 views

CAML Query results every time 0 items

I try to filter items in the list by using caml. The List contains elements that matches the Filter. The code: enter code here SPQuery qry = new SPQuery(); qry.Query = @" ...
1
vote
1answer
474 views

Build CAML query by value from ClientPeoplePicker

I use these lines of code: <SharePoint:ClientPeoplePicker ID="clpUser" runat="server" UseLocalSuggestionCache="True"/> JS: var peoplePicker = ...
3
votes
1answer
6k views

How to retrieve items from document libraries using client context without performance lag

I need to retrieve items/list items from SharePoint 2010 document library and display it in a list ListView using C#. I have used following CAML query to retrieve list items and its properties. ...
0
votes
1answer
38 views

Longest practical filter for an alert

Environment: SP2010 Enterprise SP1, Server/SQL 2008 R2, VS2012 When building alerts through object model, what is the longest or most complex CAML filter that can be applied to them? Can they be as ...
1
vote
0answers
88 views

How to check value from other sharepoint list?

I have two custom lists in SharePoint 2010 (Absent Request and Employee Leave Balance) with these columns: Absent Request List: Absent Type, Approver, Start Date, End Date, Absent Reason Employee ...
3
votes
1answer
874 views

CAML Query OrderBy ignoring non set values

I'm currently writing some CAML Query for a QueryOverride in one of my Content Query Web Parts as I'm in need of multiple "Sort by" fields. My issue is that one of the additional fields that I need ...
1
vote
3answers
3k views

how to query multiple lists using CAML

I have requestID, date column in 4 different lists. I want to build a webpart which shows user requests of different types therefore i need to query multiple lists with column requestID and date. How ...
2
votes
1answer
313 views

Open in new tab document link item from document library

I have a document link item that points to a URL. This item is inside a document library. Is there a way to make this item open to a new page? I opened the aspx file it creates, but I am unsure how ...
1
vote
3answers
535 views

Using a variable in alert filter (CAML/C#)

Environment: SP2010 Enterprise, VS2012 I've been using C# to programmatically create alerts for various users and implementing the alert.Filter property to assign filters that point to specific ...
0
votes
1answer
716 views

How to change a date format in CAML

I got a wrong date format to a CAML. I have got (yyyy-mm-dd) and must to be understand by CAML to the format(dd-mm-yyyy), how can I do this. I tried by String.Format("{0:yyyy-mm-dd}", dateISO1);, but ...
0
votes
1answer
135 views

How to add id CAML grouping?

I write this code, and I try to group by Ascending or Descending. <Query> <Where> <Neq> <FieldRef Name='Nazwisko' /> <Value Type='Note'>" ...
1
vote
2answers
1k views

CAML query not filtering results

Can someone tell me why the following CAML query is not filtering results? It's returning files that do not contain "/Internal/Bug 594" in their FileRef value. Thanks. <View ...
1
vote
2answers
1k views

CrossListQueryInfo\SPSiteDataQuery how to skip items with specific WebId?

Customer wants to see 10 news items from all webs on front page. Also customer wants to specify some news that we should skip. I am trying to do next thing: var id =1; <Neq><FieldRef ...
0
votes
1answer
1k views

How to check DateTime condition in CAML Query?

I want to fetch the records from List which are created in Last 5 minutes. I have written following code, but its not working. giving me error. <Geq><FieldRef Name='CreatedDate' /> ...
2
votes
2answers
1k views

Error in CAML Query with multiple “AND”

When I run the following query I get an error: <Where> <And> <Eq> <FieldRef Name="IssueLOB" LookupId="TRUE" /> <Value ...
2
votes
1answer
344 views

Add content type from sandboxed solution to list definition (farm solution) does not work

I'm using a sandboxed solution from a 3rd party vendor which contains some site columns and a site content type. I want to add this content type to my document library definition in CAML. But when I ...
0
votes
1answer
707 views

Caml Join Field Type

I'm having trouble using the Join via Caml. In a way, I'm having trouble working with 1 field, that is "new window" that the field type is boolean. My code looks like this: SPQuery oQuery = new ...
0
votes
2answers
120 views

SP2010 and Report Builder

I have an SSRS report integrated with SP 2010, the data in the report is loaded from a SP list. The current issue that I am facing is not being able to read minimum and maximum date time field for the ...
1
vote
2answers
347 views

CAML Query List by months

I was wondering if i have 3 random dates. 11/12/2012 9/24/2011 12/29/2008, I'd like to have September 9/24/2011 November 11/12/2012 December 12/29/2008 instead of using the query to sort by ...
1
vote
1answer
329 views

Using the value from a lookup column, obtained with REST, as a dataview parameter

I was wondering if you could help me with something. I have a list called Site Configuration. One of the columns is called Package Level (Package_x0020_Level) and is a lookup that looks at the ...
2
votes
2answers
361 views

CAML Query behaving differently in CAML Builder and Code

Based on feedback from my earlier question, I have constructed a query using the excellent CAML Builder tool: <Where> <Or> <Membership Type='CurrentUserGroups'> <FieldRef ...
0
votes
2answers
2k views

ProcessBatchData CAML Mass Delete SPListItems

Attempting to bulk delete List Item using ProcessBatchData in a PowerShell script. Here is a command that my code is generating but I am getting an error when it executes. I have been unable to find ...
1
vote
1answer
489 views

Caml for “multi lookup has no values” condition

I need to get items from my list where multiLookup field contains value (for example, value is 42) or has no values. First part is simple: <Eq> <FieldRef Name='mlookup' LookupId='true' ...
4
votes
4answers
6k views

Multiple Values in CAML query from Array? SharePoint 2010 using jQuery/SPServices

So if I use SPServices to GetListItems with CAMLQuery, is it possible to insert multiple values inside Value Type='Number'> here I would like to evaluate things throught a flow in my page, add to an ...
1
vote
2answers
1k views

Defining Lookup Fields in CAML that pulls multiple fields

We have defined a number of lookup fields like so: <Field ID="{81A578F2-8022-4083-8683-7F9BF039C82A}" Name="NameLookup" DisplayName="Navn" ...
1
vote
2answers
313 views

How to query an existing view in Sharepoint 2010

I want to query and existing sharepoint view. Is this possible? I did not find any tutorial to guide for querying a view.How cant it be done? Kindly tell me is this possible or not and if yes than ...
0
votes
1answer
224 views

Query by user field returns wrong number of items

I'm trying to query a list in an eventreceiver through properties.List.GetItems (in the itemadding event). The field I'm filtering on is a 'Person or Group' field. But the query always returns all ...
1
vote
1answer
968 views

How do I convert CAML to use in the CQWP?

I have the following CAML query which returns checked out files. <Query><Where><Eq><FieldRef Name="CheckoutUser" /><Value ...
1
vote
1answer
228 views

grabbing a column from a list

I'm having an issue when I'm trying to grab a column I made in the tasks list (it's a lookup column). for some reason when i'm try to access it with javascript i always get an exception that it isn't ...
4
votes
4answers
5k views

CAML vs LINQ vs SQL

So LINQ is a front end to CAML so of course CAML is faster, and CAML is a front end to SQL so of course SQL is faster. However what would be a good test to see where and when to use each of these on ...
1
vote
2answers
1k views

Query for retrieving managed metadata column where the column values are a subset of a list of values

In CAML, if I have a managed metadata column with multiple values, you can determine if one of a list of values is in the column using the following query (where the order of the Values/FieldRef ...
3
votes
1answer
728 views

SP2010: Strange behavior querying on taxonomy field

I need to query a document library to get items associated with some taxonomy terms, or items with specific documentId (site collection scoped feature, not the integer ID of the item), but the whole ...
0
votes
1answer
485 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
613 views

DVWP CrossList Paging Does Not Work

I've build a Data View Web Part with SharePoint Designer 2010, using SPDataSource and DataSourceMode="CrossList". The DVWP works great, but when I add paging, it adds the paging placeholder and the ...
0
votes
1answer
628 views

SQL Not IN equivalent in CAML

I have two list(subject, subjectcategory). subject(ID,Title,CategoryId) subjectcategory(ID,Title) I want to create a CAML query for SharePoint that does something like this SELECT ID, Title ...
1
vote
0answers
57 views

Calendar repeating alert

I have a sharepoint calendar which I would like to send out alerts for recurring appointments. All the appointments are on a monthly basis, e.g. every 3rd of the month. I have a reminder web part ...
2
votes
2answers
436 views

How to Add a ListItem?

I am able to add an item to a list using the CAML below. Now I need to modify it to make sure I can add an attachment as well. What is the syntax to add an attachment? <?xml version="1.0" ...
2
votes
2answers
588 views

When using Sharepoint Client Model I get error : The 'Contains' member cannot be used in the expression

When using 'Contains' in Linq query: var camlQuery = new CamlQuery(); var listItems = list.GetItems(camlQuery); var itemQuery = listItems.Where(i => ...
0
votes
3answers
1k views

how to check CamlQuery results

.I am running below query against a sharepoint list. How to check the results of below Camlquery? cPop is set with value 'AboutUs'. Result is always zero records although list has valid matching ...
0
votes
1answer
253 views

SP2007 - How to display textbox field element based on dropdown menu choice on Edit Column page?

I'm creating a custom list field type which is basically a glorified multichoice field, but I want the checkboxes to be grouped by headings that the user can specify. For example: Status1 ...
1
vote
0answers
118 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
2answers
321 views

Provision a ListView to a already existing list

How do you with CAML provision a View to a already existing list? I know how to add views through list definitions.
1
vote
2answers
174 views

Provision a file through a module (CAML) and choose its Content Type

How do you provision a file through a module (CAML) and choose its Content Type? Is it even possible? The normal behavior for a new item is to get the default content type.
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
973 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 ...
2
votes
4answers
5k views

CAML Query Filtering with OffsetDays

I'd like to set up a CAML query in a Data View Web Part (DVWP) that works like this: If a date is not specified on the Query String, then show me items created in the last 30 days If a date is ...