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
327 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 ...
1
vote
1answer
481 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 ...
1
vote
2answers
63 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
55 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
23 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
1answer
25 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
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
0
votes
0answers
21 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" ...
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
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 ...
3
votes
2answers
856 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
22 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
381 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 ...
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 => ...
1
vote
2answers
59 views
2
votes
1answer
149 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
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 ...
0
votes
1answer
62 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: ...
2
votes
1answer
62 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 ...
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 ...
7
votes
1answer
5k 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 ...
6
votes
1answer
319 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
40 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
30 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 ?
1
vote
2answers
77 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
32 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 ...
3
votes
2answers
173 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 ...
2
votes
1answer
49 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
70 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
34 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
39 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 ...
0
votes
0answers
62 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
58 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
73 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 ...
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
72 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> ...
0
votes
2answers
914 views

How to check checkboxes in caml query?

In SharePoint 2010 client object model (JavaScript), I am using this caml query to download list items. There is a column called 'Office' and in it, there are several check boxes (i.e. its a ...
0
votes
0answers
42 views

Get SPListItem by title is very slow

I want to get a SPListItem by title. I´m using a caml query to filter the list (Around 1000 items). There is only 1 item with the title in the list. My problem is now that the performance is really ...
0
votes
2answers
226 views

CAML query order by not working in SPList

I am using the following code display items in list but it is not sorting them. No matter what I write in order by clause, it always brings the same results. SPListItemCollection items = null; using ...
0
votes
0answers
86 views

SharePoint 2007 data view web part - using datetime from querystring in CAML

I have a SharePoint list, with a Start Date (internal:StartDate) and End Date (internal:_EndDate) that I am displaying with a data form web part. I have a static version of the part working perfect. ...
2
votes
1answer
657 views

CAML query limitation of values in IN operator

I have less than 5000 items in my library. I want to get 530 items by ids. So I am using following query. <Where> <In> <FieldRef Name="ID" /> <Values> ...
1
vote
1answer
226 views

CAML Query - Does <IN> count as one or multiple lookups?

In a CAML Query I filter for multiple lookup fields by combining multiple <Or> statements. This caused a log entry like this: Some lookup fields were omitted from the query result because the ...
0
votes
3answers
546 views

How to get list of documents checked out by me in view?

I have created a document library definition in which I want to insert a view that shows all documents which are checked out by me. The declarative code is: <View BaseViewID="140" Type="HTML" ...
1
vote
1answer
347 views

Get values from one list where a value is present in another list

I have 2 lists with a parent child relationship. List A ID Title ---------------- 1 First 2 Second 3 Third List B ID Title List A Lookup ---------------------------- 1 ...
1
vote
1answer
343 views

Sharepoint 2013 .NET CSOM CamlQuery Join

I am unable to create a working query with join in my .net csom application. I was using this article: http://msdn.microsoft.com/en-us/library/ff798388.aspx here is my code: ClientContext context ...
1
vote
2answers
155 views

How to retrieve the login of the user who checked-out a given file

I am currently developping a C# application which has to retrieve some data from a SharePoint website through a CAML request. I successfully get everything I need except one information : the login ...
1
vote
2answers
199 views

CAML In clause - Value does not fall within the expected range

I get a 'Value does not fall within the expected range' error from the following CAML. <Query> <Where> <In> <FieldRef Name="ID"/> <Values> ...
0
votes
1answer
78 views

Why do my CAML queries always have excess characters like “#”, etc. in the values?

Whenever I do CAML queries for SharePoint list items I find that the return results always have strange characters in the value. For example, if I do a query against the filename (FileLeafRef) I will ...