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
2answers
59 views

How do I get list items' attached files with CAML?

I'm retrieving items from a list. The list contains entries which have attachments. Can I modify my query to include the attachment URLs? What's the most efficient way of doing this? <View> ...
1
vote
2answers
651 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
2answers
120 views

SP2010 and Report Builder

I have an SSRS report integrated with SP 2010, the data in the report is loaded from a SP list. The current issue that I am facing is not being able to read minimum and maximum date time field for the ...
3
votes
1answer
725 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 ...
1
vote
1answer
9 views

CAML query not working with dates no idea why

I have startdate as 18/12/2014 and enddate as 22/12/2014 But when trying to use the below query it doesn't work <Where> <Or> <Geq> <FieldRef Name='StartDate' ...
1
vote
1answer
19 views

Delete items from document library based on criteria just like WHERE clause in SQL statement

Is there a way to delete items from a document library based on some criteria for e.g. delete all documents whose created date is less than 1/1/2012. I know it can be done through code but I am ...
1
vote
1answer
82 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 ...
1
vote
1answer
790 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
1answer
138 views

Retrieve List items using CAML Query

I have a list which contains 3 columns -ID, TicketState and EndDate ID TicketState EndDate(DD-MM-YYYY) 1 Open 10/10/2012 2 Closed ...
0
votes
1answer
28 views

Create Custom ListView

Hi guys i have a unique requirement, i have a list of tickets with few columns like Creator name, approver name and signoff names, all are of type "Text" approver name and signoff names can have names ...
0
votes
1answer
13 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
1answer
43 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
91 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
164 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
1answer
158 views

Need help with getting List Item counts

I have a custom list created that tracks project status by stages. I need to present the same in a chart format. Below is the list information. Columns *Project Name *Development(Phase1) ...
0
votes
1answer
156 views

How are columns in SharePoint connected to CAML with regards to data submission?

I am trying to make an alteration to an infopath form that was created to submit data to sharepoint. I added a dropdown box and want to submit that data to sharepoint. The submission has been ...
0
votes
1answer
223 views

Adding the other fields in addtional to lookup field in CAML

I have a custom field definition in VS2010 that contains a lookup field (Title). All is well and I can use the Title ref to add items in the SharePoint list UI. in the instance UI, I can also check ...
0
votes
1answer
707 views

How to change a date format in CAML

I got a wrong date format to a CAML. I have got (yyyy-mm-dd) and must to be understand by CAML to the format(dd-mm-yyyy), how can I do this. I tried by String.Format("{0:yyyy-mm-dd}", dateISO1);, but ...
0
votes
1answer
252 views

SP2007 - How to display textbox field element based on dropdown menu choice on Edit Column page?

I'm creating a custom list field type which is basically a glorified multichoice field, but I want the checkboxes to be grouped by headings that the user can specify. For example: Status1 ...
5
votes
0answers
95 views

CAML query for Sharepoint Calender Lists

I am using CAML query for SharePoint calender list. I am able fetch proper daily data. but when i choose weekly, monthly and yearly, it doesn't give me reports as expected. it doesn't take date ...
2
votes
0answers
905 views

IsNull not working in CAML query for indexed fields

So for example I have field 'TestField' which is indexed. How can I caml for items where 'TestField' value is null? My example down here will fail and won't find what I am querying for. <Where> ...
2
votes
0answers
346 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
44 views

Joining lists and accessing items fromt the joined list

I am working on a SharePoint Hosted app for SharePoint 2013 and I'm having real difficulty joining lists and accessing items from the joined list. In my app I build a CAML query in which two lists ...
1
vote
0answers
51 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 ...
1
vote
0answers
104 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
478 views

SPSiteDataQuery for Documents using caml query

I am tring to query an entire site collection for all the documents where a certain field is equal to something. For example where LoanCategory = Insurance. I am trying to do this using an ...
1
vote
0answers
43 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 http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spfolder.getproperty.aspx ...
1
vote
0answers
165 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
88 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
57 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
118 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
24 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
10 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 ...
0
votes
0answers
17 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
8 views

How do I add a dropdown into CAML that is a retrieve data connection for Infopath form

I am brand new to CAML and sharepoint design. I have created an InfoPath Form that contains a repeating table from XML file. The form uses the WebService to submit data to Sharepoint list. I want the ...
0
votes
0answers
23 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
34 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
76 views

Using SPQuery returns today's recurring calendar item and tomorrows. Why?

We have an on call calendar in SharePoint. I'm trying to send an automated, weekly email of the calendar. The calendar has a mix of weekly recurring entries and non recurring entries. I'm trying to ...
0
votes
0answers
97 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
36 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> ...
0
votes
0answers
48 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
26 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
0answers
114 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
41 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
0answers
92 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
0answers
34 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
0answers
58 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
0answers
136 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
61 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 ...