How to create an interactive filter for user email?

Gintarelissss98
Tera Contributor

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.

1 ACCEPTED SOLUTION

AndersBGS
Tera Patron
Tera Patron

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 

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

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

View solution in original post

3 REPLIES 3

AndersBGS
Tera Patron
Tera Patron

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 

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

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

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'
};

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