Hey
I created another filter option for dynamic "My Department".
the field "department" is reference field to 'cmn_department'
script include:
The code:
var MyDepartment = Class.create();
MyDepartment.prototype = Object.extendsObject(global.AbstractAjaxProcessor, {
getDepartment:function(user){
var gr = new GlideRecord('sys_user');
gr.addQuery('sys_id' , user);
gr.query();
gs.log('Shir');
var department;
if(gr.next()){
department = gr.department;
}
return department;
},
type: 'MyDepartment'
});
Dynamic Filter Options
It doesn't work, I would appreciate some help
The filter is shown,
but does not actually filter the list by department
Hi Shir,
You need Caller's Department in the filter rather than Caller itself.
To achieve this, enable "dot-walking" in the filter:
Then:
And finally:
Hope this helps!
Lukasz
HI @Shir Sharvit , in the dynamic filter , set the reference table to Deparment (cmn_department).
And in the list filter - give the filter condition as Caller -> Department is dynamic -> My Deparment.
Please , mark the answer as Correct/Helpful , if this is useful.
