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
2answers
451 views

Nested CAML Query - People picker, multiple persons

I'm using SPServices to query a SharePoint list containing 3 fields of the type PeoplePicker. They allow multiple people to be added, so i need to check if the current user is added to any of the ...
0
votes
1answer
433 views

CAML Query in Search Display Template

I have a search result web part based on a display template I made up. I created an action to had items as favorites. This way they appear first in the search result web part and they have a full star ...
1
vote
1answer
959 views

Uncaught Error: Sys.ArgumentNullException: Value cannot be null. SharePoint 2013 JSOM

I am trying to retrieve items from a Sharepoint 2013 list using JSOM with CAML query. camlQuery.set_viewXml('<View><Query><Where><Eq><FieldRef Name=\"Title\" /><...
1
vote
1answer
719 views

Is it possible to get all list items using CAML-query?

I'm trying to retrieve items from all lists on current site collection. Is it possible to do that using a CAML-query?
0
votes
1answer
47 views

Can I query list items from two different lists in SharePoint 2010?

I'm just wondering if it's possible to query list items from two different lists using Ajax in SharePoint 2010. I know it's possible to use Designer, however, I need this ability outside of Designer (...
1
vote
1answer
754 views

using SSRS to generate a report based on a Calendar in Sharepoint 2013

We use the calendar in SP2013 to collect information when a user is away on holiday and when there will be any visitors. It works fine as a calendar but now struggling to generate a report in SSRS to ...
0
votes
1answer
2k views

Join 2 lists in SharePoint using CAML query

I have only been using SharePoint for a few days and I know this question has been asked many times before but I've tried all of them and none of them work. These are my design Document as a ...
0
votes
1answer
339 views

Pulling in two list using javascript - sharepoint 2013

I am using javascript to pull in list information and display it. I need to pull in another list from another site collection. Both lists have to show up on the same page, each it there own sections....
0
votes
2answers
362 views

Caml Query to search a SharePoint List alert if result is empty

The code below works on success, or if there's a serious error (like the name of the list being wrong) but if the item is not found I receive no error and it does nothing. I just want an alert if the ...
1
vote
0answers
249 views

How to create a CAML query comparison that works on both numbers and strings?

I am working with a system that makes requests to SharePoint lists that have latitude and longitude columns. One of the most common use cases is requesting list items that fall within a certain ...
0
votes
1answer
158 views

How to get attachments Url in all folder use javascript

I want to retrieve file Url in all of that folder. I use javascript. Problem is it console the last item. I do not know why. Please help. Thanks function checkAttachment(AttachID,getAttachmentStatus){...
0
votes
1answer
478 views

CAML Query Where Items are Approved is Ignored

I am working with some custom web parts recently. Those web parts will only display items which have been already approved. To get the items, I use CAML Query and filter the modstat value like: <...
3
votes
2answers
740 views

What are the possible issues with large sharepoint lists and queries?

Background We have developed a sharepoint 2010 enterprise solution - application that basically uses sharepoint lists in order to store the details. In order to get the information out we use Caml ...
3
votes
1answer
2k views

How to add multiple condition filtering in query string to list view

I've gone through some articles, knowing that I can use querystring to filter a list web part: https://msdn.microsoft.com/en-us/library/cc751316.aspx https://stackoverflow.com/questions/24702889/...
0
votes
2answers
939 views

Using javascript variable or function inside caml query on sharepoint list view page with sharepoint designer

I am trying to put custom JavaScript variable or function into the sharepoint's list view page, inside caml query, using sharepoint designer for example: i am opening list view i want to modify. ...
0
votes
2answers
540 views

CAML query seems to be ignored

My CAML query seems to be ignored as I'm getting the same result no matter which dates I send. I found an JavaScript example which seemed to work fine until I started to edit my query function ...
0
votes
2answers
920 views

SPservices get Values from calculated column

I'm using spservices in SharePoint 2010 to get items from a list, and a want to retrieve all items from this year but i don't get anything. This Year column is a calculated type from the created ...
0
votes
2answers
744 views

SharePoint SPServices query and sum list items

I have 3 dropdown menus, in those 4 fields I have choices to query a SharePoint 2010 list using SPServices Dropdown filters are: Year, Month, Company List fields are: Year, Month, Company, ...
3
votes
1answer
4k views

Exception from HRESULT: 0x80131904 Caml Query

I'm trying to execute a query on a custom list. I'm receiving a generic error that isn't helping me track down the problem. Error Message: Exception from HRESULT: 0x80131904 Stacktrace: at ...
0
votes
1answer
499 views

How to get Unique record from this CAML Query?

This query return duplicate record. I want to get only unique record. I want to fetch like my list contains User1, User2, User1 I want get record User1 and User2. var context = new SP....
1
vote
1answer
761 views

JavaScript CAML for Recursive Results

I'm working with CAML Designer 2013 to create a query capable of returning all folders and subfolders within a SharePoint 2013 document library. I've gotten a working solution within the designer: ...
2
votes
0answers
815 views

group by and count in caml

I need to create chart using JavaScript from SharePoint 2010 list data .I am stuck to create data structure. Status: Pending Department: XYZ Number-row:10 Please help me to create caml query ...
1
vote
5answers
593 views

How to create List Item in my SharePoint Site List from excel sheet?

I have already created list in my SharePoint I want to create the item in this list from Excel Sheet. How can i do this? Is any java script or any other? I want to import all the record to my ...
2
votes
4answers
426 views

Return all files from DocumentLibrary (more than allowed admin limit - 5000)

I have followed the msdn sample of how to use paging while retrieving items from a list. Here is my code: internal static void ReturnAllFiles(ClientContext context) { List list = ...
2
votes
2answers
2k views

Caml query how to get data witin date range

For example, I reservation on 6/10/2016 - 8/10/2016. When I search start date on 7/10/2016 and end date is 7/10/2016 it do not show anything. if I use <Query> <Where> <And> ...
0
votes
1answer
177 views

How to get max value of a field in NewForm

I have a Bids list with a lookup column Title pointing to Auctions list. when people create a new bid for a specific Auction, I would like to retrieve the max bid and increment by 10 for that Auction ...
1
vote
0answers
296 views

Unable to connect to SharePoint Online with CAML Builder

I have U2UCamlBuilder.exe with this I can connect to local sites and build the queries as per requirement. But I'm unable to connect to the online site, once I have connected I can see only -Lists ...
1
vote
1answer
330 views

Sharepoint 2010 CAML QUERY Can't find file

I'm wanting to check a document out from an SP site, but my code/CAMLQuery can't find it (it's defo there). It stops at the ExecuteNonQuery line, saying it can't find the FileIWantToGet.xlsx I've not ...
0
votes
2answers
1k views

SP.CamlQuery().set_viewXml() returns undefined

I am trying to run a CAML query to sort through some data. Once the page finishes loading i do not get the results i want. I checked the functions and it turns out that for some reason, my CAML query ...
4
votes
1answer
194 views

Is CAML process at client side, sharepoint server or sql server?

I am now working on some SSRS reports with Report builder 3.0. I built a datasource with CAML to query (and joined) data from SharePoint lists. In production environment there are over 50,000 records ...
1
vote
1answer
94 views

Sharepoint 2010, SPQuery Value does not fall within the expected range

I have a SPQuery that getitems from a document libraries in different sites collections and display the result in listview, this query is generated from database table, everything works fine under 160 ...
3
votes
2answers
256 views

Error in CAML query

Have I written the below CAML query correctly? Am I missing anything? I am encountering an error on below line of code. SPQuery spQuery = new SPQuery(); spQuery.Query = "<Where><And><...
1
vote
1answer
212 views

caml query returns the wrong result,means trying to get today's and upcomming events from query

am trying to fetch taday's and upcomming events only from caml query in javascript but it is returning the one event of previous date alsocaml Query is as bellow query.set_viewXml('<View> <...
0
votes
1answer
1k views

Query with Content Type

I am trying to get the ListItems from a generic List with normal/standard Items in it. I have following query: <Where> <Eq> <FieldRef Name='ContentType' /> ...
0
votes
2answers
1k views

How to use a local variable in Caml Query? C#

I have a caml query and I have a list item in SharePoint list named testb and it is of DateTime type. But I was wondering if I could use a local variable like one I declared testBdate. Can I use ...
2
votes
1answer
8k views

How to configure CAML Query Options to show items inside specific folder

I wrote a java program that uses SharePoint's Lists web service. Right now, this is my CAML Query : <Query> <Where> <Contains> <FieldRef Name='FileDirRef'/>&...
3
votes
2answers
898 views

Query SharePoint List by multiple item IDs

I have a requirement to query SharePoint list items by multiple ids. I have a collection of list item ids and I want to get the list item collection programmatically. Is there anyway to do through C# ...
4
votes
3answers
19k views

CAML query using 'contains'

I have a CAML query <Query><Where><Or>"+ "<Eq><FieldRef Name='UserName' /><Value Type='User'>" + User.Name + "</Value></Eq>"+ ...
1
vote
3answers
70 views

CAML query not fetching desired results

I have a CAML query <Query><Where><Or>"+ "<Eq><FieldRef Name='UserName' /><Value Type='User'>" + User.Name + "</Value></Eq>"+ ...
0
votes
1answer
53 views

SharePoint 2013 Site workflow to locate documents with a given date

I want to build a SharePoint 2013 Site workflow for SharePoint Online using SharePoint Designer. The idea is my workflow checks every day to see if a reissue date is equal to 4 months from the ...
4
votes
3answers
4k views

Check in files that have no check in version (CSOM)

I am using Office 365 SharePoint and have a requirement to require check in for all documents. As a result of this, whenever someone uploads a document, it is automatically checked out. Sometimes, the ...
2
votes
1answer
5k views

CAML Query of List's Lookup Field

I have a child form and I want to get the total of the child forms to update the parent with the sum total. I am struggling with the CAML query to get the total back. The below returns zero records at ...
4
votes
2answers
711 views

Filter Fields using Caml Query

Normally I have this query, filtered with MostrarHome eq 'No' var queryGallery = "$select=Title,Description,Enlace,EncodedAbsUrl,Categoria/Title&$expand=Categoria/Title&$orderby=Title asc&...
0
votes
3answers
3k views

Get list of documents with CAML Query

I am trying to retrieve only documents from a library. When I use this CAML: <Where><Eq><FieldRef Name='FSObjType' /><Value Type='Lookup'>0</Value></Eq></Where&...
0
votes
3answers
591 views

caml Query Returning Last Item in List

I have a CamlQuery which I set as follows: camlQuery.set_viewXml('<Where><Eq><FieldRef Name="Part_x0020_Name" /><Value Type="Text">' + partName + '</Value></Eq><...
6
votes
2answers
384 views

Selecting only PowerPoint files in a CAML query

I am trying to select all PowerPoint files in a list. How do I do that? Up until now I used this: class UsedIn { private static NetworkCredential credential = new NetworkCredential("login", "pwd", "...
1
vote
0answers
26 views

Content by Query Webpart returning Results twice

I am instantiation a content by query webpart from code. I am overwriting the CAML Query. As soon as my query contains a managed metadata filter all results are returned twice. My query looks like ...
1
vote
1answer
3k views

Value does not fall within expected range error Sharepoint 2013 CAML query

I use a caml query to check whether a file exits in a given folder. When I run the application it gives an error saying "Value does not fall within expected range". What am I doing wrong. I have added ...
1
vote
1answer
548 views

JSOM error while loading Managed metadata fields “ Value does not fall within the expected range”

I am trying to fetch items of a particular view using JSOM using below code: ListDataService.getItemsByCamlQueryUsingCSOM = function (listName, camlQuery, viewfields) { var deferred = $....
1
vote
2answers
231 views

SP - How to get Full Url on first element in Library

I want to get FULL URL on first item from document library: using (SPSite oSite = new SPSite(documentsURL)) { using (SPWeb oWeb = oSite.OpenWeb()) { SPList docsList = oWeb.Lists[...

1
4 5
6
7 8
18