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

2
votes
1answer
38 views

GroupBy site name inside my CAML query

I wrote the following CAML query to be used inside my Content Query Web part, but i am not sure if i can define to Group the retrieved item by site name :- <property name="QueryOverride" ...
2
votes
1answer
20 views

Querying Standard Rendering Elements in CAML

Folks I'm looking to use the "standard rendering element" <PageUrl/> within a CAML query as per below: <Or> <Eq> <FieldRef Name="Webpage" /> <Value ...
2
votes
1answer
1k 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
1answer
21 views

Need CAML query LookupMulti column help, Is it possible?

I am trying to create a CAML query for querying list, here is my problem. There is a list Employees and it has a LookupMulti column for Hobbies. I want to get all Employees who have selected Reading ...
3
votes
0answers
43 views

<In> overrides everything else in SharePoint CAML query

I'm writing a CAML query for SharePoint. The list contains a term set field. I want to get all list items having specific terms, plus items where no term is set. My query contains this: <Or> ...
2
votes
0answers
24 views

SP2013 : CAML query for managed metadata columns for multiple items selected ?

How to write a caml query to fetch data from a managed metadata column ? I have written caml query which works fine for data matching to "Business" . How do my query return results if the data is ...
2
votes
0answers
25 views

Is it possible to perform Inner Join with Lookup Multiple Value Field?

I use CAML Query to perform inner join between two lists. It works when the lookup field is single value. However, when this field is multiple value, it always throws error: the value does not ...
2
votes
0answers
28 views

Does the total amount of lookups affect performance in a CAML query that has less than 8 lookup columns?

I have a large library with 12 lookup columns, and while I only use 6 of these columns when I retrieve data from this library (in a CAML query), the retrieval process often takes 20-30 seconds. Would ...
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 ...
2
votes
0answers
581 views

How to find out whether or not a list is hidden without writing code (SP2010)?

Does anyone know if there is a way of telling (without writing any code) whether or not a list is "hidden"? I have a CAML query which contains the following and I'd like to eliminate the possibility ...
1
vote
0answers
35 views

Query for SharePoint 2013 REST search

I have to site columns (column1, column2) that are also crawled by the search and available as Crawled properties, so I can use them as filters in REST query as well. I'm now trying to build the REST ...
1
vote
0answers
23 views

SPServices new item return expanded user information

I'm creating new discussion in a list using SPServices, like this: $().SPServices({ operation: "UpdateListItems", batchCmd: "New", listName: discListName, updates: "<Batch ...
1
vote
0answers
33 views

CAML, how to get Fields which are having Unique condition

I am trying to get the field info of a list and I need to also know whether the field has Enforce unique values: as true. IEnumerable<List> lists = clientContext.LoadQuery( lists.Include(list ...
1
vote
0answers
30 views

Is there any way to implement numbered pagination instead of PREV | NEXT using JSOM without using search

I'm wondering if there any way to implement Numbered pagination while retrieving items from a list like "PREV 1,2,3..NEXT" instead of just having "prev | next". I followed this code example MSDN and ...
1
vote
0answers
20 views

How to query Range

Right now my code is is Equals in the query how can i prevent for example that if i book 2014-12-01 01:00 to 2014-12-02 01:00 This is a hole day, that no one else can for example book the same time ...
1
vote
0answers
74 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
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
0answers
53 views

SP2010 - Visual Web Part - Storing metadata in folders in document libraries

I want to store a number to folders to enforce ordering. I noticed these three pages Get Property Set Property Add Property And I want to know if it's possible to use these to add a number to the ...
1
vote
0answers
232 views

Sharepoint Webservice not filtering Data

Working Version Issue: I am querying SharePoint using SP CAML Query Helper. Using SPCQH I am able to retrieve one order. The query works. Once I add the query to my Biztalk solution the query below ...
1
vote
0answers
96 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 ...
1
vote
0answers
61 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 ...
1
vote
0answers
123 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
0answers
14 views

How can you get results from a SharePoint document library (with folder and child items) in a SSRS report?

I have a SSRS report that uses a SharePoint document library as a data source. The issue is that the list has folder and in those folders are child items. The dataset is only returning items from the ...
0
votes
0answers
27 views

CAML Query using <In> element breaks after >60 values are placed inside

The following CAML Query works on my list that has over 5,000 items because the Title field is indexed: <View Scope="RecursiveAll"> <ViewFields> <FieldRef Name="Editor" /> ...
0
votes
0answers
22 views

Providing a custom QueryOverride + Group items by <site> is not working together inside my Content Query web part

I am working on a Team site collection inside my SharePoint 2013. And I added a Content Query web part, and I define to Group the items by the Site:- And I got the following result which is ...
0
votes
0answers
41 views

CAML query is returning extra items that are not part of the filters

I am working on a Team site collection inside SharePoint server 2013. now inside the team site collection i have 5 subsites, and i want to return list items from the subsites that have the following ...
0
votes
0answers
10 views

Unable to Query Document Library on Lookup Column using CAML

I'm trying retrieve all items from a Document Library where a lookup column equals a certain value. The query returns no items for the given value but the same query with the same value returns items ...
0
votes
0answers
31 views

Remove Random Characters

After we upgraded to 2013 SharePoint, random characters are added to lookup fields when I pull using spservices. Ex: AAA is one of many values in a list called Vendors. I have another list called ...
0
votes
0answers
52 views

Multiple Inner Joins CAML query

I'm trying to convert the following SQL statement to a CAML query: SELECT t.Id, t.Name, t.CustomerId FROM Ticket AS t INNER JOIN Customer AS ...
0
votes
0answers
25 views

Two choice fields to select a unique list submission then edit the result

Goal: I am trying to filter against two choice parameters in order to find the unique ID of the item shared between the two. I would then open that unique item entry, edit it, and overwrite it back to ...
0
votes
0answers
40 views

SPQuery not returning expected results

I am trying to filter a SPListItemCollection with CAML but I don't get the results I want. Here is my code: query.Query = "<Eq><FieldRef Name=\"Title\" /><Value Type=\"Text\">" + ...
0
votes
0answers
162 views

Error : “Value does not fall within the expected range.” while using JOIN in CAML query

Here is my code: SPList list = web.Lists["List1"]; SPQuery query = new SPQuery(); query.Query = @"<Where>" + "<And>" + "<Eq>" + ...
0
votes
0answers
87 views

return empty fields using lists.asmx and GetListItems

I have a list with 3 fields. I'm able to get the rows but in the returned XML if one of the fields is empty then the field is not in the XML. Is there anyway to get all fields I specify in ViewFields ...
0
votes
0answers
55 views

How to use CAML with CSOM for getting users in SP2013?

I want to get all the users in CSOM SP 2013 in javascript, but I don't want all users. I want to filter them by CAML. This is what I have so far which filters by first name is Tom, but the CAML is not ...
0
votes
0answers
101 views

OrderBy in CAML query (using Camlex) cause an error

I'm developing a visual web-part for SharePoint 2010. I've to do a query with OrderBy clause. This is my code: if (ViewState["sortExp"] == null) { sortCol = "Column_x0020_A"; } else { ...
0
votes
0answers
27 views

Left outer join in caml query to get tasks

Here is caml query. It does not retrieve any results. Showing empty pages. What I am trying to do is: "In the last 24 hours what task did not complete" I need to display those tasks in my web ...
0
votes
0answers
119 views

Webpart with parameter binding injected into CAML query?

I'm trying to do a custom webpart that takes in a query string parameter and inject that parameter into a CAML query. Is this legal? <ParameterBinding name="QuerystringBinding" ...
0
votes
0answers
299 views

CAML Query - Data Between Two Date Sets

I'm trying to get the data between two date sets, but the CAML query doesn't seem to be working. I'm trying to get anything opened between the two dates or anything closed between the two dates. ...
0
votes
0answers
46 views

OrderBy on a lookupMulti

I need to order a Caml query result's on a lookupmulti. Is that even possible ? Thx in advance.
0
votes
0answers
30 views

SharePoint CAML query vs FQL

I am building an application with very complex CAML queries. Everything is working without any problem. But my question is: Is it possible to create also very complex queries with FQL. And which one ...
0
votes
0answers
24 views

Converting Oracle to CAML

I have oracle SQL query which needs to be converted into CAML Query. My oracle query is using left outer join. select task_id from main_list left outer join select task_id from sub_list on (task_id ...
0
votes
0answers
25 views

What is result of <Now> tag in caml query

I want to retrive 8 rows from my list which should be based on condition ( The 8 rows time should be greater than or equal to current time )Please make a note Time. Not date. It should compare only ...
0
votes
0answers
483 views

Caml LookupId and LookupValue

I need to get the LookupId value and the lookup text value by CAML. With this query I get the ID but I can not get the value text anymore. <RSSharePointList ...
0
votes
0answers
26 views

CAML query Problem

I tried several CAML query builder for generating query but its not generating correct Query. I want to query calender list with following logic StartDate >= Today And EndDate <= Today ...
0
votes
0answers
67 views

sharepoint alert filter not working on first alert only then filtering is ok

have a strange behaviour with alerts on my sharepoint site. I have a document library where i want to add alerts to specific users when adding,updating,deleting folders or documents. Alerts must not ...
0
votes
0answers
54 views

camlquery to get only the items

I've a large document library with folders, i'd like having all the items except the folders. for now i use this where columns is a list of all internal name from the list CamlQuery q = ...
0
votes
0answers
180 views

CAML query on site to get all items modified after a date

I'd like to know a way or if it's possible to get all items modified from a date in a site. Now for having this, I've a client script because i'm in sandbox solution, I've to loop on each list of the ...
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
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' ...
0
votes
0answers
72 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 ...