Questions tagged [caml-query]
An XML-based language that is used to build and customize Web sites based on SharePoint Team Services from Microsoft.
890
questions
1
vote
2answers
217 views
CAML query to retrieve list metadata
Does SharePoint expose a list that can be queried for list metadata as returned in List.Fields?
Background:
My aim is to request only the data that I need. When I write:
// string listName = "My ...
1
vote
0answers
236 views
SharePoint Online - Some fields are not loaded in List Item CSOM
1) I am getting list items from a list by CAML query in ListItemCollection objects of Max 5000 items
2) I am pushing each ListItemCollection into a List of ListItem to enable the capability of ...
0
votes
2answers
13k views
CAML query using OR and AND Condition
I need to write a CAML query which satisfies the below condition:
projectstatus == "hold" OR projectstatus == "obsolete "
AND
ilprilt not equal to "ilp frozen"
When I run this query, am ...
2
votes
2answers
3k views
How to query a list's user field for a given login name in Javascript?
I need to build a query a custom list with a user field. The where clause filters the results to a given list of user login names of a dynamic length, so I build the query according to the numbers of ...
2
votes
1answer
904 views
SharePoint Online CSOM CAML query problem in view
I have a pages library in sharepoint online with 2 views.
Custom view - (I have added a condition in the view based on a content type) -
contains 500 items, It has got 100 items where title starts ...
6
votes
1answer
13k views
CAML Query - Going around the 5000 List Item Threshold
I have developed a SharePoint system for a client and I am planning forward with regards to CSOM code that runs on a specific library. This will eventually expand to a large set of data. Experience ...
0
votes
0answers
261 views
How to read Article pages Title & Description from page Library using CSOM
In C# code get Article pages Title & Description from page Library...
For this I used below code:-
ClientContext clientContext = new ClientContext("siteUrl");
clientContext.Credentials = cred;
...
0
votes
2answers
45 views
unable to pass spuser as paramter into CAML query
I want to pass the spuser as a paramter to the caml query
but when i tried the below code its throwing error:
using (SPWeb spWeb = spSite.OpenWeb())
{
...
1
vote
1answer
245 views
How to filter a document in document library based on file properties using caml query?
I need to filter several documents in document library based on file properties(Two managed metadata property)using CAML query. Please suggest me an idea to achieve this
0
votes
1answer
1k views
How to get details of a document with its GUID - facing error “Value does not fall within the expected range.”
I am trying to get the document details of a document with its GUID, but error says "Value does not fall within the expected range."
query.ViewXml = "<View Scope='Recursive'>" + _
"<Query>...
3
votes
2answers
19k 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
8k 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
417 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
508 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
639 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 ...
asked May 4 '17 at 13:20
Akshay Dattatray Nangare
3,1224 gold badges42 silver badges85 bronze badges
0
votes
3answers
224 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 ...
asked May 4 '17 at 12:41
Akshay Dattatray Nangare
3,1224 gold badges42 silver badges85 bronze badges
7
votes
2answers
559 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
1k 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
3k 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
145 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
284 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
196 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
146 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
245 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
267 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
460 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
248 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
978 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
126 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
503 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&...
asked Mar 23 '17 at 5:23
Trimantra Software Solution
2,2641 gold badge15 silver badges46 bronze badges
1
vote
2answers
472 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
470 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
496 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
69 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
14k 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
438 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
425 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
922 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
702 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
735 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
332 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
345 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
230 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 ...
