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
1answer
17 views

GetItems from SPList case sensitive

I have troubles with CAML Query and GetItems method from SPList. I get a SPList from web context: SPList docTypeList = _web.GetList(string.Format("{0}{1}", web.ServerRelativeUrl, ...
1
vote
3answers
47 views

CAML retrieve only the latest of each value in a column

(Sorry if the title isn't clear I'm not really sure how to phrase it in one question) Situation: I have a list in sharepoint containing some evaluation of different teams in a company with at least ...
0
votes
1answer
30 views

CAML Query with many conditions

I would like to know, is there a way to build such a CAML Query, or is this nonsense: I have a SharePoint List with two ContentTypes: ServiceGroup and Services. The Fields are Title ServiceGroup ...
0
votes
1answer
29 views

Caml Query on calendar to get the next x events (including recurring)

So far I'm able to get the next x events (without recurring events). Code: private SPListItemCollection GetNextEvents(SPList eventCalendar) { DateTime currentDateTime = DateTime.Now; ...
0
votes
0answers
27 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 ...
1
vote
1answer
56 views

CAML query for current date

I want to get all items from the list, which has a start date from date.now or later in time. This is what I thought would work: var dateNow = Date.now(); var camlQuery = new SP.CamlQuery(); ...
2
votes
1answer
115 views

CAML query filtering is not working

I've googled that it can be in case when query is not well-formed. But I'm verifying it for several hours and didn't find any mistake. Problem is common: query doesn't filters and returns all data. ...
0
votes
1answer
24 views

How to check if managed metadata has a keyword in CAML query?

I want to make a caml query that checks if a managed metadata column (which is a list of phrases) contains a certain phrase. I have this which seems to work, but the problem is it does a substring ...
0
votes
1answer
29 views

build caml query for multiple AND & OR

how to build caml query for following condition. All the fields all from single list. select empid, ename, salary from emp where empid=(100 or 107 or 99 or 103 or 105) and deptno=10 and mgrId=23
0
votes
1answer
19 views

How to filter document libraries using CAML query?

In my powershell script, I get all lists, then loop through and filter based on if its a document library and if its a certain content type, but I want to do this through CAML. This is the loop logic ...
0
votes
1answer
20 views

CAMLQuery with multiple and/or

I want to be able to check if (1 = 1) AND (2=2 OR 3=3) this is the following code i've tried so far: "<View>" + "<Query>" + "<Where>" + "<And>" + "<Eq><FieldRef ...
0
votes
2answers
30 views

How can I get my CAML to only return non-hidden (user created) fields without specifing every field?

I can provide the ViewFields but I was wondering if there is a way to return all the user created fields (non-hidden ones) without having to do that. I know this works: <ViewFields> ...
1
vote
1answer
35 views

How to fetch highest value item from SharePoint list

I created a Custom List in developer Site. In that List I created a column called Totalsumma and added some numeric items like "324", "567" etc. How can I fetch the highest value from that column. ...
1
vote
2answers
38 views

Sharepoint CAML Query IN operator

I have a sharepoint list with managed metadata column and I have to find items matching values from columns. If I filter the list for a column, let's say COLUMN1 <In> <FieldRef ...
-1
votes
1answer
78 views

ItemUpdated Event Receiver how to change element from one list to secound list

I have got two lists. I must do synchronize this list, but one have got only 3 columns, and secound list have got 3 columns too, but have got more columns with hidden value. I done synchronizing ...
0
votes
1answer
34 views

CAML query for the last document uploaded by a particular user

I'm trying to write a query using the JSOM to get the last document uploaded to a document library by the current user. The reason I'm doing this is because I have an upload button on a form and need ...
0
votes
1answer
73 views

paging on list not working

I want to do paging on sharepoint list. I have below code which is giving error. var customlist; var allItems; var context = new SP.ClientContext.get_current(); var web = context.get_web(); var ...
1
vote
2answers
55 views

“float;#22.0000000000000” Number Returned From CAML Query

I'm running a CAML query to retrieve list items. Some of the columns retrieved contain decimal numbers. The problem is the values coming back from the query look like float;#22.0000000000000. I just ...
0
votes
0answers
40 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
1answer
25 views

“0x80070003” error getting while I custom web part in SP2013

"0x80070003" error getting while I retrieve Only document from the document library In scop="Recursive all" in caml Query and that caml Query data pass in the Webpart...but while I Insert that custom ...
1
vote
2answers
38 views

CAML query with Beginwith/EQ/Contains/ Retrieving All rows from Lists

I have a caml query to retrieve only specific row which matched to the criteria, but it returns all the items in the LIST, @"<Where><BeginsWith><FieldRef Name='custaname' ...
1
vote
1answer
84 views

Using where clause in caml query

I want to select all items from a list where Title is equal to logInUser (which is current login user name). In my code I have created : var logInUser = context1.get_web().get_currentUser(); But ...
2
votes
1answer
109 views

What are the user data returned from Person or Group column (People Only) query?

I'm using SPServices to query a SharePoint Online (2013) list that contains a Person or Group column. (This column is set to allow selection of People Only, in case that matters.) The query used is ...
0
votes
1answer
49 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
423 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
57 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
18 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
49 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
91 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
1k 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
97 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
27 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
87 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
23 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
152 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
34 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
100 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
344 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
110 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
60 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
23 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
23 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
23 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
112 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
21 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
48 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
165 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
32 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
46 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 ...