Hello community,
I want to use a script include in my dynamic filter.
Dynamic filter looks like this:
My script include looks like this:
var getIAmDelegate = Class.create();
getIAmDelegate.prototype = {
initialize: function() {
},
getIAmDelegate: function() { // Keep the same method name
// Get the current logged-in user's sys_id
var currentUserSysID = gs.getUserID();
// Create a GlideRecord object for the 'sys_granular_delegate' table
var grDelegate = new GlideRecord('sys_granular_delegate');
var now = new GlideDateTime();
// Query 'sys_granular_delegate' where the current logged-in user is the delegate
// and the delegation is valid (within the start and end dates)
grDelegate.addEncodedQuery('delegate=' + currentUserSysID + '^starts<=' + now + '^ends>=' + now);
grDelegate.query();
// Initialize an array to store the matching user sys_id values
var delegateArr = [];
// Loop through the 'sys_granular_delegate' records
while (grDelegate.next()) {
var userSysID = grDelegate.getValue('user'); // Get the user sys_id (delegator)
// Now, query the 'sys_m2m_delegate_rule' table to validate the delegation rule
var grDelegateRule = new GlideRecord('sys_m2m_delegate_rule');
// Add a query to check if the 'delegate' field in 'sys_m2m_delegate_rule' matches the current 'sys_granular_delegate' sys_id
grDelegateRule.addEncodedQuery('delegate=' + grDelegate.getValue('sys_id')); // Use the sys_id of 'sys_granular_delegate'
grDelegateRule.query();
// If a matching rule is found
while (grDelegateRule.next()) {
// Compare the delegation_rule from sys_m2m_delegate_rule directly with the expected GRC delegation rule sys_id
if (grDelegateRule.getValue('delegation_rule') === '5a9a9d631b541210b635ddb69b4bcbbb') {
delegateArr.push(userSysID); // Add the user sys_id to the array if delegation_rule matches
}
}
}
// Return the array of user sys_ids (delegators)
return delegateArr;
},
type: 'getIAmDelegate'
};
Use case scenario:
Use case scenario:
I am using this dynamic filter in the GRC Modules. Entity owner (IS DYNAMIC) I am Delegate
In other words, when a user is set as a delegate with the specified delegation rule, he/she should see his/her Controls and also Controls where the Entity owner is an user, who created a delegation.
But for some reason my script include does not work.
I also had this script include, which worked perfectly, but it had to be adjusted:
In other words, when a user is set as a delegate with the specified delegation rule, he/she should see his/her Controls and also Controls where the Entity owner is an user, who created a delegation.
But for some reason my script include does not work.
I also had this script include, which worked perfectly, but it had to be adjusted:
function getIAmDelegate() {
var grDelegate = new GlideRecord('sys_granular_delegate');
var now = new GlideDateTime();
grDelegate.addEncodedQuery('delegate=' + gs.getUserID() + '^starts<=' + now + '^ends>=' + now);
grDelegate._query();
var delegateArr = [];
while (grDelegate._next()) {
delegateArr.push(grDelegate.getValue('user'));
}
return delegateArr;
}
Would you know, why does not it work?
I am a bit lost and to be honest, not that experienced in scripting.
1 ACCEPTED SOLUTION
