How to create an interactive filter for user email?

[Gintarelissss98]

Is there any possibility to bring an email into the interactive filter of the dashboard? I need this value from the sys_user table, but it is not showing up.

[AndersBGS · Accepted solution]

Hi @Gintarelissss98 ,

Please try to look into this community post which may give a solution to your request: https://www.servicenow.com/community/platform-analytics-forum/create-interactive-filter-to-search-on...

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders 

[Gintarelissss98]

Hello, this is my script include that I call in the ACL table 'problem' with the operation 'read'. It works perfectly if the user has the ITIL role, is added to the support group, or removed from it. However, if the user is assigned to the 'sn_problem_read' role or any other role, regardless of their role, they can see all the records: 

var checkIfRelatedToIncident = Class.create();

checkIfRelatedToIncident.prototype = {

    initialize: function() {},

    checkSecurityProblem: function(current) {

        var flag = false;

        var securityMember = false;

        var prob = current.sys_id;

        if (gs.getUser().isMemberOf(gs.getProperty('group.it.sec')) || gs.getUser().isMemberOf(gs.getProperty('group.help.desk'))) {

            securityMember = true;

        }

        var incidentGR = new GlideRecord('incident');

        incidentGR.addQuery('problem_id', prob);

        incidentGR.addQuery('u_security_incident', true);

        incidentGR.setLimit(1);

        incidentGR.query();

        if (incidentGR.hasNext()) {

            if (securityMember) {

                flag = true;

            } else {

                flag = false;

            }

        } else {

            flag = true;

        }

    return flag;

    },

    type: 'checkIfRelatedToIncident'

};

[Gintarelissss98]

I have mixed up a thread, please disregard the last message about ACL