How to use FOR VIEW in SOQL?

FOR VIEW:
for_view_soql   FOR VIEW clause stores information about record views in the interface and uses it to generate a list of
recently viewed and referenced records, such as in the sidebar Recently Items and for the auto-complete options in search. You can update objects with information about when they were last viewed using the FOR VIEW clause.

Example:
Thsi SOQL query that retrieves one Account to show to the current user and uses FOR VIEW to update the last viewed date of the retrieved Account. The same statement both retrieves the record and updates its last viewed date.

SELECT Name, ID FROM Account LIMIT 1 FOR VIEW

Before Using FOR VIEW go through this points:
1. The LastViewedDate field for the retrieved record is updated.
2. A record is added to the RecentlyViewed object to reflect the recently viewed data for the retrieved record.
3. Use this clause only when you are sure that the retrieved records will definitely be viewed by the logged-in user, else the clause falsely updates the usage information for the records.
4.  The RecentlyViewed object is updated every time the logged-in user views or references a record. It is also updated when records are retrieved using the FOR VIEW or FOR REFERENCE clause in a SOQL query. To ensure that the most recent data is available, RecentlyViewed data is periodically truncated down to 200 records per object.

COMMENTS

Name

Apex Apex Default Methods Apex Methods Apex_Collections Apps Batch Apex Books CRM eBooks Data Import Wizard Data Management DataLoader Dataloader.io Difference Between Error in Salesforce FAQ's FAQ's-Apex FAQ's-Apps FAQ's-CRM FAQ's-Data loader FAQ's-SOQL & SOSL FAQ'S-Triggers FAQ's-User Profile & Security FAQ's-VF Force.com Explorer Force.com Ide Formulas & Functions Integration Interview Questions Only Latest_Updates Limits&Best Practices Online-Training Reports and Dashboards Salesforce Deployment Salesforce Realtime Examples On Development Salesforce Realtime Task On Admin Salesforce Realtime Tasks Salesforce Realtime Tasks- Apex Salesforce Training Salesforce1 Mobile Sites SOQL Spring'14 Release Triggers User Profile & Security VF Tags VisualForce Winter'14 Release Wizard for Accounts/Contacts Workbench Workflows and Approvals
false
ltr
item
Sfdc Gurukul- All in one place for salesforce and force.com step by step tutorial for beginners: How to use FOR VIEW in SOQL?
How to use FOR VIEW in SOQL?
for view in salesforce,how to use for view in soql,soql for view,salesforce for view,for view in soql,soql for view
http://1.bp.blogspot.com/-FXtJx4bpjZY/UlUmc8BsOAI/AAAAAAAABDI/RodTmur4JP0/s1600/for_view_soql+(2).jpg
http://1.bp.blogspot.com/-FXtJx4bpjZY/UlUmc8BsOAI/AAAAAAAABDI/RodTmur4JP0/s72-c/for_view_soql+(2).jpg
Sfdc Gurukul- All in one place for salesforce and force.com step by step tutorial for beginners
http://sfdcgurukul.blogspot.in/2013/10/how-to-use-for-view-in-soql.html
http://sfdcgurukul.blogspot.in/
http://sfdcgurukul.blogspot.com/
http://sfdcgurukul.blogspot.com/2013/10/how-to-use-for-view-in-soql.html
true
4199533888133360731
UTF-8
Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS CONTENT IS PREMIUM Please share to unlock Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy