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
432 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
798 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
0
votes
1answer
10 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?
2
votes
2answers
463 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
1answer
337 views

CAML Join for retrieving FieldLeafRef

I'va a custom list which contains a lookup field to a document library. Now I need to retrieve all items from this list with the corresponding file name from the document library with Javascript CSOM. ...
1
vote
1answer
24 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 ...
2
votes
1answer
58 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(); ...
-1
votes
0answers
19 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 ...
1
vote
2answers
411 views

CAML query to retrive data from 3 lists present in three different site

I have a parent site X, and three child site A, B and C. There is a list by the name "MyList" in all the list sites. I want a CAML Query to retrieve the latest ten records,from "MyList"(now ten ...
0
votes
1answer
17 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
28 views

Whats wrong with my query

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

Convert server side script to client side script

$SPWeb = Get-SPWeb myweb-AssignmentCollection $SPAssignment $SPWeb.ListTemplates | Select Name, Description $SPTemplate = $SPWeb.ListTemplates["Custom List"] $myListGuild = ...
1
vote
1answer
554 views

SPServices Autocomplete and dynamic CAML query

I have two Text filter web parts (Project and Customer Name) with Apply Filters button for one list. There is a SPServices.SPAutocomplete on each and it works great. Now, I want to show the values in ...
0
votes
0answers
17 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
22 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
385 views

How to use SPServices search sql query - getting malformed query

I am using the SPServices javascript library to make a search request to sharepoint 2010 search. I am trying this query: queryText = "<QueryPacket xmlns='urn:Microsoft.Search.Query' ...
0
votes
1answer
17 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
46 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 ...
2
votes
4answers
4k 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 ...
0
votes
0answers
20 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: ...
3
votes
1answer
564 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
2answers
51 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
39 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
21 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
36 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
109 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
89 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 ...
1
vote
1answer
31 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
61 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> ...
9
votes
2answers
7k views

Where can i download the U2U CAML query Builder for Sharepoint 2010?

I have try to download form below links. But the site is not opening. http://www.u2u.be/res/Tools/files/CamlBuilderSetupv4.0.0.0.zip . http://www.u2u.be/res/tools/camlquerybuilder.aspx ...
1
vote
0answers
39 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
85 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
12 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
138 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
134 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
2answers
100 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
5answers
95 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
1answer
107 views

XsltListViewWebPart build query using variable

is possibility send a variable from ParameterBinding to query in XsltListViewWebPart? <Query> <Where> <Eq> <FieldRef Name="FileDirRef"/> <Value ...
0
votes
0answers
40 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
437 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 ...
3
votes
2answers
1k views

SP 2010 - Client object model (javascript) - How to use get_listItemCollectionPosition for paging?

This is my code: When I call the function to get the items, it fails (doesn't go to the fail function, it goes into the success function but crashes when I try to get the position object), and I get ...
0
votes
1answer
42 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 ...
0
votes
2answers
444 views

CAML Query returning null

I'm very new to sharepoint and have the following query on my Shared Documents. It is returning null for all three documents I have. I'm wondering where to check in database to see if values are null ...
1
vote
2answers
277 views
2
votes
1answer
199 views

Expand recurring events for the next 2 years

How can I get an expanded list of recurring events for the next 2 years? I am currently using this CAML expression: <DateRangesOverlap> <FieldRef Name="EventDate" /> <FieldRef ...
1
vote
2answers
864 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 ...
0
votes
1answer
312 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
2answers
1k 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 ...
1
vote
3answers
1k views

Web service based CAML query breaks 5,000 item limit

I have a CAML query of the form shown below which is called via the Sharepoint web service interface to search the entire Sharepoint site containing 600,000 documents looking for documents: ...