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
41 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
98 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
15 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
19 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
26 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
34 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
36 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
57 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
28 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
64 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
44 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
34 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
34 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
66 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
65 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
47 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
318 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
52 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
16 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
46 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
78 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
741 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
76 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
24 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
74 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
122 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
30 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
78 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
293 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
91 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
55 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
22 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
22 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
21 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
99 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
46 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
126 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
45 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
43 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
87 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
54 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
31 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: ...