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
0answers
73 views

Recurring Event Filtering Using CAML queries

I used following query to search between 2 dates ranges but it doesnt filter recurring instance of that day <Query> <Where> <And> <Geq> ...
1
vote
1answer
155 views

CAML query on external list not looking beyond ECT filter limit

I have an external list which is tied to an external content type. The external content type is tied to a SQL table with about 3000 records. I have set up a Read Item operation, and a Read List ...
0
votes
1answer
31 views

How do I see individual field names for a data connetion created from an XML file

I have the following CAML template: <?xml version="1.0" encoding="UTF-8"?> <Batch OnError="Continue"> <Method ID="1" Cmd="New"> <Field Name='Title'></Field> ...
0
votes
2answers
54 views

Like 'String*' in CAML

How can I write LIKE 'String*' in CAML? I must create a query to display the folder structure.
1
vote
3answers
4k views

CAML query retrieve all items from a SharePoint list

I have a JavaScript piece of code that I use to retrieve list item from SharePoint by selected options from drop-down list. Depending the selection it would assign a value to a CAMLQuery variable. ...
0
votes
1answer
144 views

Is this possible with CAML query?

I want to filter the lookup based on the value of the previous field. I have two tables one contains the category and related items. the other is one the sales staff will use to make data entries. ...
0
votes
1answer
71 views

element for tomorrow CAML

I have a calendar and am wanting to find all the events that have been put into calendar for tomorrow. Is there an element like <today/> for tomorrow? Basically how can I get it so it only ...
0
votes
1answer
81 views

How to add CAML query results with ListItems to a datasource of a repeater?

I am using SP2010. I have created a CAML query. This query has listItems as results. I would like to add these items to my repeaters datasource. How can I implement this?
1
vote
1answer
558 views

ListData.svc Returns 500 Internal Server Error - “Arithmetic overflow error…”

I'm having issues with some CAML deployed list instances. After deploying the lists, they do not appear in SharePoint Designer. Likewise, when attempting to connect to (almost all of) them, either a ...
4
votes
2answers
406 views

Adding 2 Caml queries in same executeQueryAsync

Is it possible to use two different queries to get to different lists and use them in the same executeQueryAsync() Something like this : var camlQuery = new SP.CamlQuery(); ...
0
votes
1answer
959 views

getting length of list after caml query

var clientContext = new SP.ClientContext(siteUrl); var oList = clientContext.get_web().get_lists().getByTitle('Privacy Statements'); var camlQuery = new SP.CamlQuery(); ...
0
votes
1answer
35 views

Whats wrong with my query

var camlQuery = new SP.CamlQuery(); camlQuery.set_viewXml('<Where><Eq><FieldRef Name="IsActive"/><Value ...
0
votes
0answers
287 views

Sharepoint 2013 List WYSIWYG Designer views

We need to offer our users a way to freeform format Custom List fields anywhere on a SharePoint page. The designer can not be InfoPath, SharePoint Designer or Reporting Services. Design experience ...
0
votes
1answer
83 views

Using Contains inside In

I have a list that stores various data about folders for an application. Some of these folders have nested folders, some do not. Using a list of strings that represent a substring of the folder's url, ...
0
votes
1answer
146 views

Search for managed metadata fields that are empty

I want to do a caml query for a specific managed metadata field, 'mark', and only returns the items that have an empty/null 'mark' column. How can I do this query?
1
vote
4answers
77 views

whats wrong with my query CAML

$caml = '<Where><AND><Neq><FieldRef Name="marking" /> <Value Type="Text">Off-S</Value></Neq><Neq><FieldRef Name="marking" /> <Value ...
0
votes
1answer
199 views

SPQuery cause me an error: "One or more field types are not installed properly

the problem is a CAML query of SPQuery that throw an error: One or more field types are not installed properly any help please: it work perfect in U2U CAML source code is: ...
0
votes
2answers
110 views

CAML query for returning a single field

I'm trying to get a single field from a list. The list has columns like this: Office365Account - Type: Person Email Address - Type: Email Manager - Type: Person Basically what I want ...
0
votes
1answer
4k views

Get all files under subfolder in Shared Documents list - SP Object Model

I am trying to get all files in a subfolder, in the Document Library "Shared Documents" in SP 2010. So the structure looks like http://sp2010site/sitename/shared documents/folder1/ ...
0
votes
1answer
95 views

CAML is ordering by content type even though not specified

I have a library in SharePoint 2010. The library has folders, each item in the library, including the folder, are tagged with a number (separate column). When I do an 'OrderBy' the column, the ...
1
vote
1answer
988 views

Lient Object & CAML -> Getting Items of a specific view

I need some support as I am struggeling to understand what is wrong with my code. I try to retrieve the data of a specific view. THe line "camlQuery.ViewXml = view.ViewQuery;" throws an exception "The ...
0
votes
3answers
1k views

Using a CAML query how to get a subfolders items based on the URL value the folder

If you right click on a sub folder in a library and select Copy Shortcut. How do you parse or use the Copy Shortcut value to CAML query the a single folder and its sub folders? Copy Shortcut value: ...
1
vote
1answer
87 views

Alert Template - CAML value manipulation

I'm modifying the alert template for when an task item is assigned. This section here <HTML> <![CDATA[<td class="toolbarbutton"><a href="]]> </HTML> <GetVar ...
1
vote
1answer
354 views

Threshold limit reached with a calendar month view

I'm perfectly aware about the threshold thing. I know I need to reduce my query. However, here, it's for a calendar... I use the below query: <query> <Query> <Where> ...
2
votes
0answers
79 views

CAML Query scheme in depth

I have a plan to develop my own version of the CAML builder app - as a pet project and in order to improve this field. :) It would be nice to support all the capabilities of the CAML query scheme ...
0
votes
1answer
1k views

CAML Query filter by month

I would like to use CAML Query to select records between a certain period (a particular month) and which where made by a certain user. Here's what it look like but it doesn't work ...
0
votes
1answer
759 views

Lists with null columns not returned when retrieving custom lists with Caml query and Javascript

I am retrieving a list with caml query and Javascript. Everything works fine besides the fact that I have an image column and not all lists have that column populated: Here is a sample query I am ...
0
votes
1answer
2k views

Iterate through List items in a view and manipulate column data using JavaScript

The short story is I want to open a custom filtered view created by the standard SP UI and click a button that will iterate through all the items in the view and change the status field to complete. ...
1
vote
1answer
1k views

XsltListViewWebPart build query using variable

is possibility send a variable from ParameterBinding to query in XsltListViewWebPart? <Query> <Where> <Eq> <FieldRef Name="FileDirRef"/> <Value ...
2
votes
5answers
1k views

Translating a SQL query to CAML query

I am new to CAML query and as much as I have expected it to be simple like SQL I have found it quite frustrating to deal with. I have a simple query SQL query I am trying to translate into CAML but do ...
2
votes
2answers
933 views

How do I fetch the data from list present in root web of the root site collection?

We need to populate some data on an application page. The application page is present in the layouts folder and hence is accessible via the respective site URL. There are multiple site collections. ...
2
votes
1answer
680 views

CAML Query based on IDs to get version number?

With JavaScript, is it possible to get its version number if I know the ID of an item? I have a function that needs to do something with the selected file, but even if I select the file, it is ...
0
votes
1answer
646 views

Field types are not installed properly while quierying a List

I have this problem: I want to query a list using Caml. Here is the query: <Where> <And> <Geq> <FieldRef ...
1
vote
2answers
1k views

How to display current month items only from SharePoint list with caml query

how to display current month items from SharePoint list with query.
0
votes
1answer
2k views

Expanding ListViewByQuery Web Part stuck on “Working on it…”

I am using a ListViewByQuery in a custom web-part. If I set the CAML GroupBy to <GroupBy Collapse='FALSE'> (i.e. expanded), the webpart works fine. However, if I set it to <GroupBy ...
3
votes
1answer
2k views

Create Multiple List Items with One Function

Is it possible to create multiple list items with one function in JavaScript / ECMAScript? I know that a single item can be created with the code below, but would like to know if it is possible to ...
6
votes
1answer
977 views

SQL Injections with SharePoint 2010 CAML Queries

IBM Appscan has detected that some pages in our system are vulnerable to SQL Injection. The report shows which URLs are vulnerable, so I checked the pages based on the URLs, but most of the pages ...
0
votes
1answer
500 views

Get last item by caml in an ItemAdding event receiver?

I have a custom list in sp2013. On this list I have created in vs a eventreceiver on ItemAdding. In this event receiver I would like to get the last item from the list and get some value of a field ...
0
votes
2answers
78 views

CAML : filter items based on FieldType regardless of the Column name

In a CAML query, can you filter items which has values in the column (Not Null), based on the FieldType of the column. regardless of the Column name ?
3
votes
2answers
8k views

CAML query to filter items by Content Type, independent of column name

In a SharePoint list I have a column, created using a custom content type. Let's say, the content types is "MyContentType". I used in a column "My Custom Column". Need to filter out items if the "My ...
0
votes
1answer
191 views

LINQ in SharePoint to order listitems

I have tried the following in CAML but it does not seem to be returning them sorted SPQuery query = new SPQuery(); query.Query = "<Query><OrderBy><FieldRef Name='Sequence ...
2
votes
1answer
65 views

creating CAML queries in a 32 bit environment?

I'm currently developing with SharePoint on my 32 bit computer. While I'm able to make simple changes with designer on my PC I'm aware that using visual studio to make changes (CAML queries) without ...
1
vote
1answer
190 views

CAML RenderPattern Get current list Item ID

In a my share point 2007 list i have a custom field. In the custom field i need to get the current Item ID. Later have to pass this to a JavaScript. How to get the current Item ID in RenderPattern ? ...
1
vote
0answers
142 views

Custom Field RenderPattern Customization - SharePoint 2007

I'm creating a custom field in SP 2007. I need to Get the Custom field value and field properties on Item click, in the list item display view. Also i Need to pass these values to a JavaScript. So, ...
1
vote
1answer
47 views

About CAML and its content

Problem: I have understood the foundation of CAML and there are some questions that are still unclear in my mind. What context and when should a SP developer use CAML? Why using CAML to retrieve ...
3
votes
3answers
1k views

CAML query for sharepoint list not working

I have a CAML query where I am getting records between a date range for a sharepoint 2010 list through an asmx web method call. It looks like this ...
0
votes
0answers
222 views

Get Items Lookup Mult timeout

I have a list with many records , and when I'm doing a filter for a column that is Lookup Multiple runs smoothly : Example <Where> <Eq> <FieldRef Name='Column' ...
2
votes
2answers
80 views

Items not showing in folder?

Basically, I have a situation where instead of creating 10 individual document libraries, I've created one and filter each "region" as such by subfolders in the library. Canada Finance > Document ...
0
votes
1answer
119 views

How to get list items same values in each two list items to display in 3rd list using with caml query

How can I write one caml query to get items from two lists joined on empid? will you please anybody give me help with suitable caml query or even otherwise possible code. Note: There is no lookup ...
0
votes
1answer
212 views

Why is my CAML query for my list view not valid: filtering a date and membership of created by

The below query works only for each segement alone. Either: <And> <Geq> <FieldRef Name="Von"/> <Value Type="DateTime">{startdatum}</Value> </Geq> <Leq> ...