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
2answers
32 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' ...
0
votes
1answer
18 views

CAML query help needed - need system time plus or minus a number of minutes

Is there a way to replace the date / times in the query below with the current date/time plus or minus a number of minutes? <Query> <Where> <And> <Geq> ...
0
votes
0answers
27 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 ...
1
vote
1answer
20 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
791 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 ...
2
votes
1answer
313 views

Open in new tab document link item from document library

I have a document link item that points to a URL. This item is inside a document library. Is there a way to make this item open to a new page? I opened the aspx file it creates, but I am unsure how ...
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 ...
1
vote
2answers
654 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' ...
2
votes
1answer
642 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 ...
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 ...
3
votes
1answer
727 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
2answers
60 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> ...
0
votes
1answer
710 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 ...
4
votes
4answers
5k views

CAML vs LINQ vs SQL

So LINQ is a front end to CAML so of course CAML is faster, and CAML is a front end to SQL so of course SQL is faster. However what would be a good test to see where and when to use each of these on ...
0
votes
2answers
50 views

Using CAML Query to Retreive from Multiple Lists

I am creating an applicant tool which contains the following lists: Applicant; Applicant Answers; Job Questionnaire; Job Title The lists are related as follows: Applicant.ID = Applicant ...
1
vote
1answer
108 views

CAML Query, get item by lookup value, not by ID

I have the value of a lookup column, but I don't have the ID, I want to query items from SharePoint list using the lookup value. How do I achieve that in CAML?
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
1answer
319 views

error: The collection has not been initialized

I get this error error: The collection has not been initialized. It has not been requested or the request has not been executed. It may need to be explicitly requested. it has a problem in ...
0
votes
2answers
76 views

SP2010: Need to filter list items returned by caml query

I'm using SPServices and unslider.js to display a slideshow on a page. Instead of showing all items in the slider, the requirement is to manage the slides by using a filtered view. I added tags but ...
0
votes
1answer
37 views

Can a Lookup list field point to web property bag?

In my subwebs I have a 1 row list called "Details" that contains various bits of data that are meant to be web-level metadata. Image field, AssignedTo field, couple of string columns, etc. On top of ...
0
votes
2answers
75 views

Retrieve SharePoint list in DataTable with Condition

** I have a Sharepoint List called "Resources" and have various Fields as shown below and same returns as DataTable: ID Title Role LoginName Enable[Yes/No] 1 Pranav Developer ...
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 ...
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
1answer
26 views

What is the value to Variable when query results nothing in CAML

What is the Value of $spQuery when no items were returned from the filter in the query given below: I am trying to add a conditional statement at end of this script. if ($spQuery -eq $null){ ...
1
vote
1answer
32 views

Nested CAML operators

Is it possible to nest query operators other than Or/And, for example, In and Contains operators, so that the query would look for items which would contain any string from my given string collection? ...
0
votes
1answer
66 views

Copy People column from sharepoint list item to SharePoint group

I have Site Admin Custom sharepoint list in a Site1, where users in our oganization need to submit a request to become Cerified Site Collection Administrator. List Consists of 3 columns: Site ...
2
votes
3answers
7k views

Building CAML query with AND and Order by Clause

Hi I am trying to build a query using caml query builder - Below is the query (The query = get the values only whose address = 1234st AND LastName = Doe) - I believe the placement of AND operator is ...
0
votes
2answers
264 views

Retrieve single field using CAML Query in Sharepoint using Javascript

I have a List called ProjectInformation and contains following Fields.. ID ProjectName1 ProjectManager ProjectExecution 1 EDS PPB Time and Material 2 CS ...
0
votes
1answer
44 views

CAML query regex

is there a way to perform regex query with CAML? I have a string field (Display) composed by Name and Surname. I have a single search input. I wish to have these results *Display* match UserInput ...
0
votes
1answer
151 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
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
1answer
29 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
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 ...
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> ...
5
votes
0answers
96 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 ...
1
vote
2answers
124 views

CAML Query for SPServices parameter

I need to run a workflow on all items in a library. This SPServices example seems like a good plan but I'm running into problems. The library has folders and the CAML query returns only the folders, ...
0
votes
1answer
846 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 ...
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 ...
0
votes
1answer
69 views

How to select values in a CHOICES field?

I'm using a CAML query to update a SharePoint 2010 List from InfoPath. My CAML looks like this: <?xml version="1.0" encoding="UTF-8"?> <Batch OnError="Continue"> <Method ID="1" ...
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> ...
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 ...
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
2answers
36 views

Like 'String*' in CAML

How can I write LIKE 'String*' in CAML? I must create a query to display the folder structure.
1
vote
3answers
206 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
49 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
1answer
60 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
37 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
888 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