Questions tagged [caml-query]

An XML-based language that is used to build and customize Web sites based on SharePoint Team Services from Microsoft.

Filter by
Sorted by
Tagged with
1
vote
1answer
248 views

CAML Query for Complex AND or OR scenarios

I want to create CAML Query for following scenario, (Metadata Name ="Author1" AND Value="Nitin Jagtap") AND (Metadata Name ="Program" AND Value="MBA"). I have tried but not able to create CAML query ...
3
votes
1answer
1k views

Caml query To display Upcoming Event From Sharepoint Calender List

Using Jquery & Caml Query Retrieve Upcoming Events form Calendar List.I use below query but it not work. It display only start date of Recursive Event. My caml query is: <Query> <Where&...
1
vote
1answer
56 views

Bug in Updating SharePoint list via javascript

here is My code : console.log(query); camlQuery.set_viewXml(query); collListItem = oList.getItems(camlQuery); clientContext.load(collListItem); clientContext.executeQueryAsync(function (sender, args) ...
1
vote
1answer
608 views

CAML Query is not filtering anything when using a Person or Group type column

I'm trying to get a list count based on the CAML query below, but it keeps returning zero. It should return the number of projects assigned to a designer (person or group type column) which their ...
2
votes
1answer
111 views

Caml Query between data-times?

I want to query all items within 7 days and I have the following code which is working perfectly: DateTime startDate = new DateTime(DateTime.Today.Year, DateTime.Today.Month, DateTime.Today.Day); ...
1
vote
1answer
42 views

DateTime error with Caml Query?

I have created a column in SharePoint named Data e skadimit të kontrates and I am trying to query this column with the following query: queryMuaj.Query = @"<Where><Eq> &...
1
vote
2answers
584 views

How to query with 3 Conditions? CAML QUERY

I have the first query: queryMuaj.Query = "<OrderBy>" + "<FieldRef Name ='testb' Ascending = 'TRUE'/>" + "</OrderBy>" + ...
4
votes
4answers
210 views

SP - CodError with CAML query,

I want go get last record field value from my SPList with CAML query. Really code working but gives me following ERROR... My Code: void ddCarNumber_TextChanged(object sender, EventArgs e) { try ...
2
votes
4answers
2k views

How to query with 2 conditions? CamlQuery

I have the following 2 queries: first one is this- 1) @"<Where> <Eq> <FieldRef Name='ReportsTo' /> <Value Type='Text'>" + reportsTo + @"</Value> </Eq> &...
-1
votes
1answer
709 views

Caml query with more than 2 or conditions [closed]

var fieldName; var listFields; var CmalQuery; $(document).ready(function () { $('#btnSearch').on('click', function () { txtValue = $('#txtSearch').val(); ...
0
votes
1answer
987 views

What is the limit of nested OR's in a CAML Query?? For each Version?

I'm needing to know what the exact nested CAML Query limits are for each version of Sharepoint? Also are these limits the same for using the IN, INCLUDES Operators with 2010+ ???
0
votes
1answer
148 views

Display Person's Documents in People Search Results Display Template

I am building a people results in display template that needs to include a link to an individual's CV in a document library. I've used a SPServices Getlistitem to query the list, but I can't get the ...
1
vote
1answer
503 views

How to convert Linq expression representation to CAML query

I have some code to get the fields of a List with some Criteria. Web web = context.Web; List list = web.Lists.GetByTitle("Employees"); FieldCollection fieldCol = list.Fields; context.Load(fieldCol, ...
0
votes
1answer
150 views

CAML to query a recurrent event - SP 2010

I´m using SP CAML Query Helper Online fot getting all the elements of a recurrent event but it only get the general recurrent event. there is possible to get all the days of this recurrent event in ...
1
vote
3answers
3k views

Making an dynamic <And><Or> Caml Query

I am Trying to write an Dynamic Caml Query. I did it like This: CamlQuery qry = new CamlQuery(); string qryStatus = ""; string qryCategory = ""; foreach (RiskStatus sta in ...
4
votes
1answer
62 views

How to return a List<File>, stored in a DocumentSet, based on the Current ListItem?

I have 2 ListItems, each has a DocumentSet with 2 documents each. I'm attempting to download only those Documents attached to the current ListItem. This is my first time working with documentSets. ...
0
votes
1answer
2k views

CAML Query Validator

Is it possible to validate a CAML query (to check whether it is correctly formed or not) before executing it in SharePoint? Otherwise, while executing the CAML query, it gives weird errors, which don'...
0
votes
2answers
566 views

CAML get child folders count

I want to query all folders from a document library and I am using following query <Where> <Eq> <FieldRef Name="ContentType" /> <Value Type="Text">Folder</Value>...
0
votes
1answer
193 views

caml query pass username dynamically in sharepoint hosted app

In my hosted app I have one text field which contains username. I have write following query in lists schema.xml <View> <Query> <Where> <Contains> ...
1
vote
1answer
878 views

Retrieve the Item ID from the Task List Related Item column

Using JSOM, I getting all the task details which are not started. Using CAML query i got all the column values including related item column from Task list var relateditm = $(this).attr("...
2
votes
2answers
5k views

CAML query to filter Datetime

I have to filter data with respect to a field named CreatedDate having type datetime. In input I'm just giving date (not time), I want to fetch all records with respect to specific date (ignoring ...
0
votes
1answer
5k views

caml query for text field(Title field) contains username in SharePoint hosted app

In my hosted app I have one text field which contains username. I want to apply filter on a view which on filtering gives me data related to current user. <Field ID="{fa564e0f-0c70-4ab9-b863-...
1
vote
1answer
633 views

Iterating SPList.GetItems(SPQuery) very slow and times out

I have a SharePoint 2013 Custom List. It has 3 MMS columns, 3 User Columns and 3 or 4 DateTime columns and a Choice Column and 1 or 2 columns of type Text. This list currently has around 2000 items. I ...
0
votes
1answer
478 views

Convert CAML queries to OData Filters

Is it possible to convert complex CAML query to OData filters so that I can use them in REST APIs? Some CAML queries have nested condition and multiple values to be passed in IN operator. Also, ...
0
votes
1answer
1k views

Can't make a caml query works for a boolean

I try to take the elemtens in a list where the field "Mise à jour parc" is set to "No" with the boolean type. My field 'Mise à jour parc" has for db name for sharepoint "...
-1
votes
2answers
563 views

executeQueryAsync function calling not working using for loop

I am having values in result[15452,33616] when using for loop ,the async function taking only last array value (e.g-33616) and fetching the data for that pushing to another array and final push into ...
1
vote
1answer
2k views

Keep the same ID on an item copied from another list

Environment : Foundation 2010 I have two helpdesk lists. In List A, the user create the item and an ID is automatically assigned. My workflow is used to copy that item in the list B. However IDs are ...
1
vote
2answers
2k views

Can't get filename of document with REST api/CAML query

Using the rest api to retrieve information about my documents. The documents use managed metadata which isn't expanded correctly when using the stand REST api. So I found this fix which uses REST with ...
2
votes
1answer
3k views

camlQuery rowlimit not working on a list

I'm trying to update some elements in a list with client object and caml query. It's working, my values are updated, but for all the items (around 15) even I have a rowlimit of 5 : var ...
5
votes
3answers
12k views

How to query list with >5000 items in SharePoint Online?

I want to query a list in SharePoint Online which has >5000 items. How can I do it? Right now it is showing me thresh hold limit error when I am trying to query the list.
0
votes
1answer
175 views

SharePoint Online list view threshold

I need to access a list with 40,000 items and populate that data into a csv. How can I do this using caml?
2
votes
2answers
587 views

Calendar List - CAML Query Next Two Events

I need to create a CAML query to obtain the following two events from a SharePoint 2010 calendar: To consider: There may be recurring events And exceptions to events The purpose is to show in a ...
5
votes
1answer
21k views

CAML query format filter in DateTime column

I need to get the list item created on a particular date. The below caml query doesn't seem to work. It always retuns 0 query.ViewXml = @"<View><Query><Where><Eq><FieldRef ...
1
vote
2answers
910 views

I want to display only Upcoming recurrence events from calendar list

here I tried something but that's not up to the mark objQuery.Query = @"<Where><DateRangesOverlap><FieldRef Name='EventDate' /><FieldRef Name='EndDate' /><FieldRef Name='...
2
votes
1answer
1k views

Sharepoint CAML IN operator not working with FileDirRef

I want to retrieve a list of file from two folders. When I combine two <Eq><FieldRef Name="FileDirRef" />... with <Or> it works fine. When I want to use the <In> operator it ...
0
votes
2answers
322 views

SP07 - CAML Query between two dates

I have two datetimeControllers : DateTimeControl dtFrom = new DateTimeControl(); dtFrom.ID = "startDate"; DateTimeControl dtTo = new DateTimeControl(); dtTo.ID = "endDate"; I want to get ...
1
vote
2answers
381 views

GetItems with CAML against lookup on online throws “list view threshold”-error

I want to query for items where a lookup has a title which contains some text. The list has over 5000 items, but the query result will return fewer, so it should work. This query works, querying for ...
1
vote
2answers
461 views

Caml String : How to search list by variable (string)

I have been trying to work on this for a few hours and a lot of googling. New to caml queries I simply want to search my list where the variable matches in the column. In sql I would write: sql= ...
0
votes
1answer
73 views

Show top 10 distinct users in Sharepoint 2010 list based on another list

I am having a Sharepoint 2010 site where I'm having a List named UserRank which has columns User of type people & group and Datetime. After each custom email webpart an entry to this list is ...
1
vote
2answers
658 views

CAML Query search exact word in comma separated

I have 2 list items that contains a title field with following string value Item 1 Title : apple,blackgreen Item 2 Title : apple,black I want to query the list item if comma separated word in the ...
0
votes
1answer
452 views

Retrieve all Comments by UserId in Discussion Board

It try retrieving all Comments from a single person inside a discussion board. This is the CAML: <View> <QueryOptions><ViewAttributes Scope='RecursiveAll' /></QueryOptions> ...
2
votes
3answers
3k views

CSOM - CAML : Get document icon

I was using JSLink to change the display of a documents webpart. I was retrieving the document icon url set by Sharepoint for a document library item like this: (it can be shortcut icon (DOCLINK.GIF),...
1
vote
1answer
610 views

Export CAML query data into Excel

I am using JSOM to fetch the data from SharePoint list and binding into HTML table from JS file. And I would like to export the query(CAML Query) data into Excel, how can I do this?
1
vote
3answers
764 views

CAML Query with AND OR

I'm struggling to get a simple query working and would appreciate any assistance in pointing out my error/s. I need to return all "Chart Type" that equal "Jacket" for "2016" in both "Mar" and "Feb". ...
2
votes
4answers
6k views

How to pass a string(date) in a caml query to get listitem based on datetime type of field

I want to pass a string(date) in a caml query to get listitem based on datetime type of field. I am not getting any value in return. Please suggest. Below is my code: ` private SP.ListItem ...
1
vote
0answers
1k views

How to pass multi choice(checkbox) values in a caml query to fetch item from sharepoint list in o365

Below is my code: SP.ListItem listItem = null; CamlQuery camlQuery = new CamlQuery(); camlQuery.ViewXml = @"<View><Query><Where><BeginsWith><FieldRef Name=" + field....
0
votes
1answer
65 views

Fetch the data from Date and Time Calculated column

I am trying to fetch the result from list based on 3 conditions( Month Name,Employee,Department). In my SharePoint List(Month Name is calculated column fetching month from column "Joining Date") . ...
2
votes
1answer
473 views

SharePoint 2013 SOAP Request with GetItems fails with NullReferenceException

I'm pretty lost here. I've inherited legacy code which uses SOAP to fetch SharePoint content. One method posts a SOAP request against SharePoint to get the HasUniqueRoleAssignments property of list ...
0
votes
1answer
94 views

SharePoint notification

I am trying to make a dynamic notification field which shows the number of for example not approved items in a list. But this needs to be shown always, wherever I am in SP. It should look like: Home ...
1
vote
1answer
826 views

Filter out hidden folder using client object model in SharePoint 2010 / 2013

I need to do the same thing as on this thread: Filter out hidden folder using client object model in sharepoint 2013 However my code needs to run on SharePoint 2010 and Sharepoint 2013. I'm using the ...

1
5 6
7
8 9
18