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
91 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
24 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
51 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
159 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
120 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
643 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
133 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
2answers
187 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
3answers
500 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
1answer
32 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
142 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' ...
2
votes
1answer
333 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
376 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
82 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
2answers
3k 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
192 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
336 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"> ...
2
votes
2answers
6k 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
1answer
434 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
1answer
735 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 ...
0
votes
1answer
95 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
406 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
875 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
402 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
144 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
40 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
1answer
32 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
369 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.
1
vote
1answer
28 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
85 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
415 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
35 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
77 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
68 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
196 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
25 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
102 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
1answer
567 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 ...
2
votes
2answers
164 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
48 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
628 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
81 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
20 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
30 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 ...
4
votes
2answers
1k views

How do I get list items' attached files with CAML via REST API?

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
4k 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 ...
4
votes
1answer
13k 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
75 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
11k 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
317 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 ...