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
33 views

Joining lists and create dynamic columns

I have 3 lists A, B and C in the same site and i have to make a View joining them and generate few dynamic columns: Columns of A: Title (Indexed), Util(number) Columns of B: Title, Title_A (Lookup), ...
0
votes
1answer
41 views

Export contents of a sharepoint list to a html table

How can I export the contents of a list to a html table? I know how to extract the elements of a list using CAML Queries, but how do I generate a html table containing the elements dynamically?
0
votes
2answers
31 views

Detect if a document or list item was deleted

I'm working on building a synchronizer for certain kinds of data from some lists to an outside application. Via the SOAP API, I can get updates and new items; by using CAML Queries, we can fetch all ...
0
votes
0answers
7 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
17 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
1answer
36 views

CAML query to get data for SSRS from SharePoint list

I am writing CAML query to get data from sharepoint list <RSSharePointList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> ...
1
vote
1answer
126 views

Sharepoint REST API - Using caml query and select/expand to get lookup data

I have a Sharepoint app and I use a caml query to filter the data I get back: var caml = "<View><Query><Where><And><Contains><FieldRef Name='PublishingPageLayout' ...
0
votes
0answers
21 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
17 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
1answer
25 views

Add filter and pagination to CAML query

I'm developing a visual web part for Sharepoint 2010. I would display all documents from a specific DL, but this DL contains more than 7000 items. So I would like to add a pagination (show only 20 ...
0
votes
0answers
16 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
1answer
52 views

CAML query OrderBy is not working

SPWeb _SPweb = _SPSite.OpenWeb(); SPList _SPlist = _SPweb.Lists[FL.ToString()]; SPQuery _spquery = new SPQuery(); _spquery.Query = "<Query><Where><Eq><FieldRef ...
1
vote
1answer
22 views

CAML - Understanding when to use Eq, Geg and Value

With the following CAML query: camlQuery.set_viewXml('<View><Query><Where><Geq><FieldRef Name=\'ID\'/>' + '<Value ...
0
votes
1answer
41 views

Is it possible to write a CAML query that will update or insert an entry based on its existence?

I'm working with Sharepoint using CSOM and Javascript. I need to cache usage statistics in a List with one entry per user, updating values in a user's list entry when they interact with the site in a ...
0
votes
1answer
98 views

How to consolidate JS for CAML queries with multiple filters?

I'm very new at the entire JS/SPServices concept (and JS as a whole) and I'm trying to slim down the amount of JS needed for a few HTML pages. I have several unordered lists on the HTML page that I ...
1
vote
2answers
49 views

GetListItems not returning empty fields even when using ViewFields

I am using the GetListItems web service to query a list. I am passing the viewFields property to return certain fields: var viewFields = XElement.Parse(@" <ViewFields> <FieldRef ...
1
vote
1answer
32 views

Query the Author column using login “domain\user”

I need to query a SharePoint list and specifically the Author column with a given login in the form "domain\username". I read that I must switch the column's "Show Field" property to "Account", but ...
0
votes
1answer
14 views

Author's active directory ID through CAML (instead of numeric ID)

I am querying a SharePoint list using CAML, and I am selecting the Author column: <ViewFields> <FieldRef Name="Author" /> </ViewFields> Which returns the authors in the following ...
0
votes
0answers
20 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
1answer
18 views

CAML Query builder using oracle query

Is there any tool for creating caml query.I know how to write in Oracle. I want to convert into caml query which i doesn't know. Please anyone help me out on this.
0
votes
1answer
36 views

Left outer join in CAMl Query

I want to use left outer join in my caml query in java script. I am little bit confused how to use joins. Please anyone explain an easy example of left outer join query in caml.
0
votes
0answers
7 views

MINUS Operator in CAMl Query [duplicate]

I am planning to retrieve list items from two different lists .The condition is based on MINUS Operator.I meant What are the list itmes not in my second list whcih is in first list .I need to display ...
0
votes
1answer
20 views

MINUS Operator in CAML

I need to use MINUS Operator in my CAML Query. Is it available in CAML? Looking for answers. Thanks in advance
0
votes
2answers
39 views

CAML Query to Return all rows

I am having Sql Query like // sTitle is my input string string sTitle='something'; Select Title From EmployeeList WHERE Title like '%sTitle%' or 0=sTitle OrderBy Title Desc; How do i Build it in ...
0
votes
1answer
49 views

CAML query datetime - publishingstartdate

I'm trying to get a CAML query working with dates - specifically PublishingStartDate and PublishingExpirationDate. When scheduling an item, there is the option to select 'immediately' and 'never' ...
1
vote
1answer
29 views

Retriving list items

I am retrieving my list items using the current time, but my code is retrieving nothing. Please anyone help me out on this. Here is my CAML code: ...
0
votes
1answer
28 views

Why using Decimal in this CAML Query is not returning correct records?

I have the following table: DoubleNumber ------------- 10.50 44.77 88.90 I am using the following CAML Query: query.Query = "<Where><Contains><FieldRef ...
0
votes
1answer
31 views

Sharepoint CAML best practices

Can I write a CAML query inside a for loop? Copied from comment I have a funds list which displays funds and user name. I have populated a DataTable into a GridView and able to display all the data ...
0
votes
2answers
55 views

What is wrong with the following Caml query

I have the following table with columns: Editor | _UIVersionString | Title | LookupNumber | Author a | b | Title1| 100;800 | admin I use the following query caml ...
0
votes
0answers
24 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
2answers
44 views

Getting Current time in CAML QUERY

I want to retrive 8 rows from list which is greater than current time (not date) using caml query. Please help me out on this.
0
votes
0answers
24 views

SPQuery removing hashtag from checkbox field when binding to datatable

I've written a windows forms app that pulls info from a SharePoint library using a CAML query and binds it to a datatable. One of the columns is a checkbox type so it returns ";#" with each value (ex: ...
0
votes
1answer
99 views

Executing Caml Query without ExecuteQueryAsync and “The collection has not been initialized…” Error

I have been trying to use Caml Queries to filter SharePoint lists and return the number of times that a given value is found in the SharePoint list. Here is the part of my code that I've been having ...
0
votes
0answers
37 views

CAML query to Filter data on “DateTime” on a sharePoint 2007 list

I am trying to create a web part as a report to filter list data based on date and time I've created CAML as follows <Value IncludeTimeValue='TRUE' Type='DateTime'> Further I've ensured ...
2
votes
2answers
63 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
27 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
70 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
39 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
0answers
15 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
19 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
20 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 ...
1
vote
2answers
259 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
2answers
277 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
1k 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
31 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 ...
1
vote
1answer
2k 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
174 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
62 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
446 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
0answers
41 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 = ...