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
3
votes
2answers
18k views

Get all items in list by Field Name caml query

I have a list and want to return all items in a specific column. The code I have below isn't working, is the caml query wrong? CamlQuery camlQuery = new CamlQuery(); camlQuery.ViewXml = "<Query>...
1
vote
3answers
7k views

caml query to fetch selected fields from list

I am having a list with 40 columns and need to fetch only 10 fields in a batch of 4. how to achieve this. Can someone provide me caml query. I prepared below caml to fetch 2 columns please let me know ...
2
votes
3answers
373 views

Lookup field based CAML query returns the entire list instead of matching data [duplicate]

I m using O365 List called Employee with lookup field. When I query the list based on the lookup column it will returns all list Item instead the matching data. Could you please help me. Using MVC ...
0
votes
2answers
40 views

Error while trying to query data from SharePoint 2013 list

I am building a visual web part application with c# and i need to query items from my list, but i have to add some conditionals. I am successfully querying ID and Title but I need another conditional ...
1
vote
1answer
473 views

filter list using SPServices

I have a list with the following fields (Title, Area, Zone, Reference, qtt). I created two "select" tags for the area and zone fields. I also created an "input" tag for filter field reference. I am ...
0
votes
1answer
607 views

Programmatically get pages which are created using custom page layout

I have custom ArticlePage.aspx page layout. I have created some pages in Pages library using ArticlePage layout. Now programmatically. I'm trying to get that pages with their properties. I did ...
0
votes
3answers
203 views

CAML query returns no result, where the same query in camel designer shows result

I'm use camel query for pages library to get pages created using ArticlePage.aspx layout. also add filter with department and location value to match. The query shows result in U2U Camel Query ...
7
votes
2answers
547 views

Using CAML Builder Is it possible to query the items from multiple list in SharePoint 2013?

I have three lists like List1, List2, List3. I need to retrieve an item based on conditions, Is this possible to query the items from multiple lists using Caml query builder tool U2U. I am not sure ...
1
vote
2answers
951 views

Caml query to filter by two columns of a sharepoint [duplicate]

Below CAML query is working for filtering the list items with one column, I have tried to add another column to filter it but facing some errors. "<View Scope='RecursiveAll'><Query><...
1
vote
2answers
2k views

CAML query to filter by more than one ID

I have to send more than one ID to CAML query. But got struck with the or condition. How can we implement or condition for unknown number of ID's to be passed to the query. I have done in for two ID'...
1
vote
0answers
141 views

CrossListQueryCache - get 10 items on indexed column

I have a question, basically I build a query and use the CrossListQueryCache to retrieve all the required items. Now all was good and well but there is a problem: lists are big some of them more than ...
0
votes
1answer
267 views

Valid ClientContext Web Lists GetByTitle returns Null

I currently do have a working method in VB and proven through usage on other lists. Below will be my code Public Sub getWiki(ctx As ClientContext) Dim WaterIce As SP.List = ctx.Web.Lists....
0
votes
1answer
178 views

caml query is not working to get checked out files by specific user only

Loop through all the folders in document library and fetch checked out files by specific user only
1
vote
2answers
5k views

SharePoint CAML query to retrieve the item more than threshold limit

I facing a problem while retrieving the list data from SharePoint online. I have list items around 20,000. I am using a caml query to retrieve the data based on conditions in dotnet csom. it has 5300 ...
0
votes
2answers
138 views

How can I query list items using CAML

I have 3 fields(Fname,Email,Phone) <viewFields> \ <ViewFields> \ <FieldRef Name='Title' /> \ <FieldRef Name='ID' /> \ ...
0
votes
1answer
238 views

Use SPServices to Grab Recently Modified DOcuments

I'm looking to build a list of files that have recently been modified in my SharePoint Online library. I am using SPServices to query my SharePoint Library. Here is my code: var fieldsToRead ="<...
1
vote
1answer
248 views

Caml Query Error with Contains-Element

I have a strange problem with a CAML-Query in SharePoint 2016 when using the Contains-Element. This is the query: <View> <Query> <Where> <And> ...
0
votes
2answers
430 views

getting 403 forrbidden when using caml to get a list

I just recently started to invest some time into CAML. I am trying to learn it. I think I have it down, but when I try executing the query I get a 403 forbidden. Anyone know a way to fix this. error ...
1
vote
0answers
239 views

Join two lists without lookup column using caml query and sharepoint web services

I have 2 lists with the following columns: list1 City ID list2 Customer ID I need to join these two lists on the basis of similar ID, I can't use the lookup column method. How can it be possible?...
1
vote
3answers
2k views

Searching for multiple values in a field with CAML, Sharepoint 2013

We have a SharePoint 2013 list that stores a list of work hazards. One of the columns is called "Hazard" and contains words which relate to the type of hazard it is. Two Examples of data in the ...
1
vote
2answers
905 views

CAML query with ORDER BY is not working

Hi i have document library having custom column named INDEX of type Number and there is some folders and documents in document library like I have created CAML query to get item having maximum Index ...
0
votes
1answer
116 views

CAML Query error while using WHERE clause

I keep having the following exception when trying to execute the following CAML query. What's wrong with the WHERE clause? Exception of type 'Microsoft.SharePoint.SoapServer.SoapServerException' ...
0
votes
2answers
466 views

Whats wrong in given caml query?

I am trying to get the data based on some datetime string using CAML query. Here is my CAML query: <View> <Query> <Where> <And> <Le&...
1
vote
2answers
417 views

Display particular folder list view

I have document library in which several folders, in one of them I have sub-folder that I need to display in custom view. So, position of that folder is like Doc.Library > Folder2 > Internet. I found ...
1
vote
1answer
440 views

order null values ascending with caml query

I have a customOrder column in list, its ordered by that number ascending. I want all null values listed after items that has value in customorder. I wish all null values would be ordered asc as ...
3
votes
1answer
63 views

Get SharePoint Versions with all the properties including custom properties

Is there any possiblities to read SharePoint item's version with all the properties (including the custom properties) for SharePoint Online ?
1
vote
2answers
483 views

Retrieve list items with date query using client object model

I wrote this caml query to get the data. the query i wrote- <View> <Query> <Where> <And> <Eq> <FieldRef Name='AccNo' /> <Value Type='...
1
vote
1answer
66 views

How to perform search on my page?

I want to create one page or document library where can I perform search. Suppose user hit the Url like http://mysite/doclibname/filestartnamethat time on my page show only filestartname files. How ...
1
vote
1answer
3k views

Targeting a specific list view - PowerShell CAML (SharePoint Online)

I need some support in how to target specific views within a SharePoint Online list using CAML. Just last week our script started to fail because we've now hit the view thresholds of our list - it's ...
9
votes
3answers
13k views

Make CAML query with in rest api call

I have a SharePoint list and i need to get the list items by using JSOM.how to add CAML query with in the API method? i have used the below code var url = "/_api/Web/Lists/GetByTitle('list')/...
1
vote
2answers
410 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
409 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
863 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
679 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
678 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
1k 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
328 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
318 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
212 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
154 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
442 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
644 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
855 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
489 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
872 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
707 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
470 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....