As of May 31, 2023, we have updated our Code of Conduct.

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.

Filter by
Sorted by
Tagged with
1 vote
0 answers
75 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 ...
user95039's user avatar
1 vote
1 answer
221 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'>&...
John John's user avatar
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, ...
Sylvie's user avatar
  • 163
0 votes
1 answer
17 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 ...
John John's user avatar
0 votes
1 answer
2k 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 ...
John John's user avatar
3 votes
2 answers
697 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 ...
RnR93's user avatar
  • 77
2 votes
0 answers
108 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 ...
notorious's user avatar
  • 156
0 votes
1 answer
120 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 ...
Dinerdo's user avatar
  • 739
3 votes
1 answer
10k 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 ...
PianoMan's user avatar
  • 367
13 votes
3 answers
32k 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') ...
PianoMan's user avatar
  • 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") . ...
MSA's user avatar
  • 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="...
John John's user avatar
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 ...
Mohammad Mavia's user avatar
0 votes
4 answers
745 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); ...
BCdotWEB's user avatar
  • 109
1 vote
0 answers
96 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 =&...
harshal's user avatar
  • 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: ...
Rothrock's user avatar
  • 2,920
0 votes
2 answers
220 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> <...
IMTheNachoMan's user avatar
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 ...
Sharepoint-Dev's user avatar
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/...
omygoodness's user avatar
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 ...
SharePointMan's user avatar