I'm trying to use a scripted filter on my report. I want to read only the import set rows belonging to the most recent import set for a given table. So I will pass in the Import Set Row table name as a param and return the sys_id of the most recent import set for that table. (I actually return an array of a single element, for now.) My report will filter the import rows to those where Set.sys_id matches one of these values.
So I started by creating a client callable script include, accessible from all scopes, to take the table name as a param.
var ImportSetDetails = Class.create();
ImportSetDetails.prototype = Object.extendsObject(global.AbstractAjaxProcessor, {
/**
* Returns the sys_id of the newest import set created for @tableName
*/
getImportSetSysids: function(tableName) {
// returns an array
},
type: 'ImportSetDetails'
});
and an ACL:
The ACL has snc_internal.
Now the script include works fine. But when I invoke it through a list or through the report filter I get nothing. Adding print statements confirms that the script is not being invoked. The filter expression is:
javascript: new my_scope.ImportSetDetails().getImportSetSysids("my_scope_vendor_data");
This must be a permissions problem, but I set up the ACL on the script include. There are a number of posts on this problem, and the all discuss the ACL and making the script include callable. What else can I check?
