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

0
votes
1answer
35 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
79 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
644 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
2k 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 ...
1
vote
1answer
210 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
363 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
328 views

How tu change a date format in CAML

I have got a wrong format of date to a CAML. I have got (yyyy-mm-dd) and must to be understand by CAML to the format(dd-mm-yyyy), how could I done this. Please help me. I tried by ...
0
votes
1answer
115 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
767 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
824 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
822 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' /> ...
1
vote
2answers
685 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
260 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
532 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
1answer
105 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
323 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
281 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
320 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
1k 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
410 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
4k 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 ...
0
votes
2answers
920 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
181 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
204 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
729 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
182 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
3answers
3k 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
890 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 ...
2
votes
1answer
506 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
360 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
511 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
388 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
53 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
274 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
390 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
193 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
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
2answers
270 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
153 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
1k 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
634 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 ...
1
vote
3answers
3k 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 ...
1
vote
1answer
592 views

Declarative (CAML) BusinessData field

I am trying to create a List template definition declaratively (using CAML) which includes a External Data column and several secondary columns. I created a custom list via the UI and exported the ...
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 ...
2
votes
1answer
6k views

Querying a simple list with a 'User' column, using CAML

I'm having some trouble getting a CAML Query working against a very simple list. My custom list has the fields: Person : User Date : Date Amount : Lookup My query looks like this: <Query> ...
0
votes
2answers
917 views

CAML query returning everything?

I am busy messing around with lists and CAML queries: SPQuery query = new SPQuery(); SPList list; SPListItemCollection collection; query = new SPQuery(); query.Query = ...
0
votes
1answer
757 views

Join two list using multivalued lookup field with spquery

I have joined two lists with the lookup that allow single value using spquery.join. can any one help me to do for multivalue lookup