function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

S-control doesn't always like RevenueForecast object

I have a scontrol, which basically does this:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
    <script type="text/javascript" src="/js/functions.js"></script>
    <script src="/soap/ajax/12.0/connection.js"></script>
    <script type="text/javascript">  
 function init_page() 
    var result; 
    var strSQL = "Select Id,StartDate,ProductFamily,Quota,Closed,Commit,Upside,Pipeline,CurrencyIsoCode from RevenueForecast where OwnerId='{!$User.Id}' and StartDate >= 2008-04-01 and StartDate <= 2009-03-31 order by ProductFamily"; 
           try {
  result = sforce.connection.query(strSQL);
    } catch(err) { alert(err); alert('SQL blowup');}

When I execute it as System Administrator, it works as expected. However, when I execute with another profile, I get an error:

{faultcode:'sf:INVALID_TYPE', faultstring:'INVALID_TYPE: sObject type 'RevenueForecast' is not supported.', ...}

Which security settings (besides API enabled) must the user's profile have in order to read RevenueForecast?


Well, I can give the user profile 'View all Data' authority,
but that is definately not acceptable since the idea with this s-control is on the Home Page for each sales rep to show graphically,
how they stand comparing quotas to actuals within current FY.

I also thought about a trigger, which copies RevenueForecast to a custom object with the necessary security settings.
However, it does not seem possible to make triggers for RevenueForecast object, not even via Eclipse.

Other ideas?


I also tried to include the s-control in a dashboard, having the system administrator being the running user. Didn't help.

Well, I found a way: Put all the code into an APEX page controller, make a VF page and call that page from an s-control.
The page controller will execute in system mode, thus avoiding security issues.

The s-control is the added to a dashboad available for all relevant users.

Simple, Watson!