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
957 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 ...
1
vote
1answer
36 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(); ...
1
vote
2answers
894 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' ...
1
vote
1answer
61 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 ...
3
votes
1answer
858 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 ...
4
votes
2answers
1k 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
1answer
90 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
23 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
2answers
944 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
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
2
votes
1answer
747 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 ...
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 ...
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 ...
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
32 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. ...
0
votes
1answer
607 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 ...
-1
votes
1answer
55 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
62 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
40 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
27 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 { ...
1
vote
0answers
51 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 Get Property Set Property Add Property And I want to know if it's possible to use these to add a number to the ...
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 ...
6
votes
3answers
179 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
33 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
63 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
55 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 ...
10
votes
4answers
15k views

Where can i download the U2U CAML query Builder for Sharepoint 2010?

I have try to download form below links. But the site is not opening. http://www.u2u.be/res/Tools/files/CamlBuilderSetupv4.0.0.0.zip . http://www.u2u.be/res/tools/camlquerybuilder.aspx ...
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
277 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
49 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
1answer
75 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"> ...
0
votes
0answers
15 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
43 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" ...
1
vote
1answer
674 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
68 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.
5
votes
4answers
16k 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
1answer
63 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
22 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
115 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
70 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
273 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
87 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
52 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.