Questions tagged [camlviewfields]
The CamlViewFields complex type specifies which additional fields SHOULD be returned from a data retrieval request in addition to the fields the protocol server already returns.
21
questions
0
votes
1
answer
44
views
SharePoint CAML Query to get all folders that have a value for a specific field and were modified within the last five days
I am attempting to get ALL folders that contain a value for the ProjectNumber field and were modified within the last five days. This query only works when I remove the modified condition. Otherwise ...
- 103
1
vote
0
answers
89
views
How to filter CAML Query Results
How can I modify this code so that it displays only the records where the title equals whatever the current title is of the current record I am in? Currently I get all the records from the second ...
- 21
1
vote
1
answer
276
views
CAML query is returning all the list items
I have the following CAML query
CamlQuery camlQuery = new CamlQuery();
camlQuery.ViewXml = "<Query><Where><Eq><FieldRef Name='RiskRequestID'/><Value Type='Text'>&...
0
votes
1
answer
1k
views
CAML Query for SharePoint Online - ViewFields not working
I am trying to use PnP with CAML Query to retrieve all items in a document library where certain fields meet certain values. The query filter is working fine, it retrieves the correct documents, ...
- 175
0
votes
1
answer
21
views
Unable to get the pages which have their calcualted date.time field equal today using CAML
I am working on an online SharePoint site collection, where I have a calculated column named "ExpiryDate" of type Datetime, and I want to get all the pages which have their expiry date equal today, i ...
0
votes
1
answer
3k
views
CAML query using a Choice field is not working
I have the following CAML query inside our SharePoint online site collection, to get all the list items which have a choice field named CustomerOrderAlert = No, as follow:-
List ...
3
votes
2
answers
765
views
CAML Query Last List Item Where Status = New
I have a SharePoint 2013 custom list and a requirement to load the last list item where Status = New. I first tried SPGetLastItemID with a CAML query filter - however, that method only returns items ...
- 77
2
votes
0
answers
110
views
SPQuery.viewFields does not return specified fields
I have a list that contains multiple views. I am filtering the view data on the basis of date range using CAML Query. But I don't want all the fields to be return so I used viewFields property of ...
- 156
0
votes
1
answer
128
views
Is it possible to get 13+ lookup field values in an All Items query via CSOM?
I know I could split the queries into 2 or 3 and combine them if I only specify 4-5 lookup fields I want to retrieve each time.. But is it possible to get all of the lookup IDs with CSOM in one CAML ...
- 749
3
votes
1
answer
11k
views
CAML query of a managed metadata field
CAML request returns [object Object] for a field that contains managed metadata. How does that get converted to a value that can be display on the web. For example, I know that a lookup field requires ...
- 367
13
votes
3
answers
33k
views
CAML viewfields
When using CAML to extract from a list, what is the purpose of the viewfields in the query - to set value types - text, interger,etc. - and make the fields available so the get_item('fieldname') ...
- 367
0
votes
1
answer
85
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") .
...
- 1,155
1
vote
1
answer
4k
views
How to specify a CAML Query to return items that have any of two site columns?
I want to define a query to return items that satisfy the following :-
if any item have a CT & login user = site column
so i wrote the following :-
<property name="QueryOverride" type="...
0
votes
1
answer
592
views
CSOM CAML query returning every item in the list
I'm trying to retrieve a list of items where some conditions are applied but when I run my web page it returns all records. basically this query checks whether any record with these conditions exist ...
0
votes
4
answers
770
views
User-type fields in CamlQuery ViewFields return null
I am trying to return several User-type fields from SharePoint 2013 like this:
using (var clientContext = new ClientContext(myUrl))
{
var list = clientContext.Web.Lists.GetByTitle(listName);
...
- 109
1
vote
0
answers
98
views
CAML, how to get Fields which are having Unique condition
I am trying to get the field info of a list and I need to also know whether the field has Enforce unique values: as true.
IEnumerable<List> lists = clientContext.LoadQuery( lists.Include(list =&...
- 111
2
votes
0
answers
2k
views
Expanding user field for LikedBy in CAML query
I'm retrieving like ratings from a list. That is working. But I want to know if the current user has liked an item. I've added the LikedBy column to my include list. Here is the code that is working:
...
- 3,010
0
votes
2
answers
232
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>
<...
- 718
0
votes
1
answer
91
views
Create Custom ListView
Hi guys i have a unique requirement, i have a list of tickets with few columns like Creator name, approver name and signoff names, all are of type "Text" approver name and signoff names can have names ...
4
votes
1
answer
22k
views
SPServices - GetListItems - formatting results
I am using SPServices in Sharepoint 2013 to get some results from cutom list named "navigator" presented here:
and for this purpose I am using code:
<script type="text/javascript" src="../js/...
- 305
0
votes
3
answers
3k
views
SPservice for filtering Dropdown based on parent dropdown
we are $().SPServices.SPCascadeDropdowns for cascading. Suddenly it stopped working. now I want to use another option of using SPServices with CAML query to display the projects based on Employee ...
- 3,364