Is it possible for me to use the FOR VIEW clause in SOQL for another user instead of the CurrentUser. For example I want to see how many records on the Case object a certain user has viewed in one day.
Well this is not possible out of box. SFDC does not allow you to track record views by default the way you described above "I want to see how many records on the Case object a certain user has viewed in one day".
So, you will have to use apex & VF. Here are steps for one of such simple implementation.
- Create a object Case_views__c to track record view with 2 fields case_ID & user_ID
- Create a vf page to show case details using tag
- In controller insert record in Case_views__c
- Override case page detail view with this page VF page
Now every time user view case record SFDC will make entry in Case_views__c object.
You can then create a report to group by user and count the cases that they views in particulate time period