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.
19
questions
1
vote
1answer
38 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
1answer
387 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, ...
0
votes
1answer
14 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
1answer
253 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
2answers
413 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 ...
2
votes
0answers
99 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 ...
0
votes
1answer
93 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 ...
3
votes
1answer
9k 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 ...
13
votes
3answers
28k 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') ...
0
votes
1answer
78 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
vote
1answer
3k 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
1answer
586 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
4answers
682 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);
...
1
vote
0answers
91 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 =&...
2
votes
0answers
1k 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:
...
0
votes
2answers
168 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>
<...
0
votes
1answer
90 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
1answer
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/...
0
votes
3answers
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 ...
