When performing several SOQL queries from different Apex classes, "No such column 'LastViewedDate' on entity <entity-name>" is thrown

When performing several SOQL queries from different Apex classes, "No such column 'LastViewedDate' on entity <entity-name>" is thrown

Apex , API

Last updated Yesterday ·Reference W-2330031 ·Reported By 279 users

In Review

Summary
When performing several SOQL queries from different Apex classes, "No such column 'LastViewedDate' on entity <entity-name>" is thrown from an Apex class with API version 28.0+

- Actual Result.
Throw error message "No such column 'LastViewedDate' on entity <entity-name>"

- Expected Result.
No error message thrown, SOQL query executed without error.

Repro
1) Create two Apex classes:
a) "thisIs27" that should use API version 27.0
b) "thisIs28" that should use API version 28.0.

thisIs27:
-----------------------------
public class thisIs27{
public void myQuery(){
String queryS = 'select id from contact';
database.query(queryS);
}
}
-----------------------------

thisIs28:
-----------------------------
public class thisIs28{
public void myQuery(){
String queryS = 'select lastVieweddate from Contact';
Database.query(queryS);
}
}
-----------------------------

2) Then go to the Developer Console and run the following Apex code:

thisIs27 v27 = new thisIs27();
thisIs28 v28 = new thisIs28();
v27.myQuery();
v28.myQuery();

3) After executed it, we get error: "No such column 'lastvieweddate' on entity 'Contact'"

4) Notice that if we change the order of the last two lines the code executes without error:

thisIs27 v27 = new thisIs27();
thisIs28 v28 = new thisIs28();
v28.myQuery();
v27.myQuery();

Workaround
Update the API version of every Apex classes to 28.0 and above.

Reported By (279)

Paul Narsavage Detlef Rahlf Erdem Tokmakoglu Tugce Sirin Brett Gibson (Clouding Around) Synefo Brian Landvogt Jeff Levy Matt Hanagan Emily Tam Jorne Van Landschoot Shraddha K Avrio Admin RJ Smith Vijaya Kumar Basa Youchen Wu Kalin Gilman OCE Admin Taylor Johnson OCE Admin Jim Morrow Anthony Sanchez Sriram Penkey Narayanan Lakshmanan Ankit Aggarwal Martin Brennan Phil Bergner Anand Chaturvedi Cyprien CHAUVIERE James Thompson joost karsten Amit Sharma Gulam Sabir Khan Aurélien FONTAINE Jorge Ortega Traverso Rajat Mittal Julie Hallstrom Rodrigo Domingues Rodrigo Chiarato Fabian Off Katarzyna Karabowicz Manthan Shah Gary Chan Matthew Holliday Matteo Orsenigo Lucas Louf Eirik Skeid Satoshi Nagatsuka David Johnson Teemu Ahonen Claire Oestreicher Avani Manne Hector Cabrera Diaz Vishal Jaiswal Marina AUTIN Arvind Aiah Sterling Keaton Raymond Ensley Nathan Hinchey Dan Crowdus Ryan Gardiner DEV Stanley Zapata Celeste Young Web Infinity Bhuvaneswary R Wijnen Robin Sarah McCaig Sergio Alcocer Vazquez Mauro Barincelli Prashant Gupta Jonathan Shinn Sebastien Sansom Lorie Miller Rachel Chand Anirudh Singh Carol Rathbun Angel Castro SANJEEV BATHINI VARMA SRIDATLA Meryem Serraj Andaloussi Jay Kapadia Shyam Kannapiran Vijay kumar Basa ROBERT CAMPBELL Sitaram Srivatsavai Andy Luciani Tay Tufenkjian Patrick Watkins Aditi Deshpande James Ellis Christian Menzinger Christian Szandor Knapp Eric Kintzer Pankaj Hingane James Melville Prabushanker K Melissa Meyers Zachary Matthewstearn David Habib Endiem Admin Finian O'Driscoll James Hadfield Daniel Temple Pedro Molina Hector Rodriguez Esparza Priya Marupudi Ken Human System Administrator (PK) Nathan Pilkington William Linke Fernando Herrero Brad Ciszewski sravanthi bhavanam Michael Slawnik Javier Perez Pim Uijttewaal Satoshi Takezawa NOU Sovatthymony Gustavo Tandeciarz Tiffany DeYoung Aldo Enrique Lezama Lainez Jérôme Mignée Anusha Vuyyuru Candy Weekes Brian Beck Craig Ceremuga Tim Skoch Brenden Wells Harri Vuori Eric Grust Kelly Song Austin Turner Chad Joubert Ajit Verma Tyler Johnston Scott Stith A Admin Marco Falconi Peter Kavanagh Willem Mulder Mohith Shrivastava Trifecta Developers Guy Snitovsky Rinku Daxini Carl Brundage (Inactive) BOSS Admin Eric Stansbury Daniel Ballinger Scott Geosits Angus Thompson Nick Gibson Erin Fink Suman Banerjee Aurélien Lacenaire Austin Delorme Mohammad Unte Swayam Chouksey Craig Hayashi Matthew Soleyn Chris Minerd Jim Daly Yad Jayanth Bruce VanBuren Skye Evans Karla Smagorinsky Allison Klein David Habib PatronTech Admin Sean Barenbrugge Deepanjan Chattopadhyay Davide Redaelli Santo Scaccianoce Pasquale Romeo Dimitri Suls Nisar Ahmed Deloitte User Nerissa Tong Jacqui Lloyd Kathir Radhakrishnan Josef Kral Rosalind Holland Victor Hanson 李 志新 Behzad Bahadori Gene Izydorczyk Admin User Robin Ridgely Charlie Halpin John Thompson Manish Thaduri aka sfdcFanBoy Nitin Sahgal Caleb Brandon Philip Nelson Harry Radenberg Gears CRM Armando Meeuwenoord Mike Gallagher Ashok Naglikar Yuying Chen Scott Covert Jonathan de Vries Catering 608022 Abhijit Shrikhande Product Services Abby Jones Mark Morris Susan Sparks Amy Read Sian Bradley Chloe Green Javier Coca Samantha Brennand Yulia Brereton Chris Peterson Wahsitee Chongchua Diane MacRobie Vertiba Admin Arpan Patel Etude Developpement Ajay Anikar Jahanzeb Hashmi Robert Soesemann Rob Muschiana Prasad Ruwanpathirana Thomas Koegl Manish Thaduri Raj Yanambakkam Tom Fuda Blake Smith Rajpal Singh Capstorm David Habib David Robison Vish Goki Russell Potter SHAWN TAYLOR Osama Nasir Rajesh Krishnaiah Grady Duncan Ramesh Yellanki Ethan Weitz WisdomEdge Team Scott Wells Richard Blake Cloud62 Cloud62 Lukasz SKRODZKI David Sparks Tami Lau System Administrator MIS Business Analysts Matt Gvazdinskas Dan Moore David Henriquez Lissa Smith Jed Micka Eric Kong Kristoffer Jacobsen Stephen Hill Taylor Pariseau Weinheimer Shaun McInerney Mauricio 7demo Zach McElrath Hiren Patel Chirag Mehta Vigneswaran Sugumaran Melissa Hansen Michael Smith (DO NOT USE) Benj Kamm David Tondreau Jeff Clark Long Lam Holt Farley Vinylume Inc Adith Srinivasan kenichiro imasawa Paul Kissick sfpsdev Leslie Linard Nicolas Palitzyne

Is it Fixed?

AP0 AP3 AP4 AP5 AP6 AP7 AP8 AP9 AP14 AP15 AP20 AP21 AP22 AP28 CS1 CS2 CS3 CS4 CS5 CS6 CS7 CS8 CS9 CS10 CS109 CS108 CS107 CS106 CS105 CS102 CS101 CS100 CS115 CS110 CS11 CS116 CS12 CS137 CS138 CS13 CS14 CS15 CS152 CS151 CS16 CS17 CS18 CS19 CS20 CS21 CS22 CS23 CS24 CS25 CS26 CS27 CS28 CS29 CS30 CS31 CS32 CS33 CS34 CS35 CS36 CS37 CS40 CS41 CS42 CS43 CS44 CS45 CS47 CS50 CS51 CS52 CS53 CS54 CS57 CS58 CS59 CS60 CS61 CS62 CS63 CS64 CS65 CS66 CS67 CS68 CS69 CS70 CS71 CS72 CS73 CS74 CS75 CS76 CS77 CS78 CS79 CS80 CS81 CS82 CS83 CS84 CS85 CS86 CS87 CS88 CS89 CS90 CS91 CS92 CS93 CS94 CS95 CS96 CS97 CS98 CS99 EU7 EU8 EU9 EU10 EU12 EU13 EU14 EU15 EU16 EU17 EU18 EU19 EU25 EU26 NA104 NA100 NA101 NA103 NA102 NA105 NA129 NA130 NA132 NA131 NA21 NA32 NA33 NA37 NA39 NA40 NA42 NA44 NA45 NA46 NA47 NA49 NA50 NA51 NA52 NA53 NA54 NA56 NA57 NA58 NA59 NA60 NA61 NA62 NA63 NA64 NA65 NA66 NA67 NA68 NA69 NA70 NA71 NA72 NA73 NA74 NA75 NA76 NA77 NA78 NA79 NA80 NA81 NA82 NA83 NA84 NA85 NA86 NA87 NA88 NA89 NA90 NA91 NA92 NA93 NA94 NA95 NA96 NA97 NA98 NA99 UM1 UM2 UM3 UM4 UM5

Any unreleased services, features, statuses, or dates referenced in this or other public statements are not currently available and may not be delivered on time or at all. Customers who purchase our services should make their purchase decisions based upon features that are currently available.