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
12 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
31 views

Like 'String*' in CAML

How can I write LIKE 'String*' in CAML? I must create a query to display the folder structure.
0
votes
3answers
44 views

CAML query rertieve 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
0answers
10 views

Order all day events on a calendar

I have a calendar list with a choice called "Category" with items A,B,C,D. I want to sort the all day events that are shown based on the selected category. I tried to set the Orderby using the below ...
0
votes
0answers
12 views

Select Max value records group by field

looking for CAML query to select records max value group by filed example: pid name value 1 abc 1 1 xer 2 1 wer 3 2 rer 1 2 wew 2 2 wew 4 I ...
0
votes
1answer
29 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
20 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
17 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
41 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 ...
-1
votes
0answers
22 views

Select one column caml query

Is there anyway to select one column from your list when using a caml query something like camlQuery1.set_viewXml('<View><Query><Select><Eq><FieldRef ...
2
votes
1answer
68 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
20 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
29 views

Whats wrong with my query

var camlQuery = new SP.CamlQuery(); camlQuery.set_viewXml('<Where><Eq><FieldRef Name="IsActive"/><Value ...
0
votes
0answers
32 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
0answers
19 views

Calender List events filter today

I have a calender list and various types of events like simple , all day , daily,monthly and yearly recurrence , recurrence with all day. I have to filter them to today. I have created a custom ...
0
votes
1answer
23 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
23 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?
0
votes
4answers
48 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
0answers
24 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
55 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
86 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
23 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
45 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
160 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
35 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
79 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> ...
1
vote
0answers
41 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
118 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
0answers
14 views

Combining multiple field references in OrderBy when implementing paging

I'm having some issues combining multiple fieldrefs in an orderby and paging by ListItemCollectionPosition. I may have an orderby query looking like this <OrderBy> <FieldRef ...
0
votes
1answer
179 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
179 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
147 views

XsltListViewWebPart build query using variable

is possibility send a variable from ParameterBinding to query in XsltListViewWebPart? <Query> <Where> <Eq> <FieldRef Name="FileDirRef"/> <Value ...
1
vote
5answers
114 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 ...
1
vote
2answers
113 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. ...
1
vote
1answer
116 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
0answers
43 views

Modifying CAML to filter by passed parameter

I have a list which contains a column called "Actual Start Date". I want to filter this list at the users command to only select the date they have selected. I have created a parameter called "Start" ...
0
votes
1answer
50 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
326 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
395 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 ...
2
votes
1answer
258 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
475 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
160 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
55 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 ?
2
votes
2answers
923 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
50 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
53 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
110 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
63 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
41 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
2answers
353 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 ...