script include filter not working on company table

[Adarsh kumar si]

Hello team,
I am trying to filter out the company  in company table which are used in "Business Application" table .
I have created script include which is in different scope than global scope and accessible from is "This application scope only" 

Script :--

function GetCompany() {

    var companies = [];

    var ga = new GlideAggregate('cmdb_ci_business_app');

    ga.addNotNullQuery('company');

    ga.groupBy('company');

    ga.query();

    while (ga.next()) {

        companies.push(ga.getValue('company').toString());

    }

      return companies.join(',');

}

.................................................................

And  on company table filter is :--sysid is one of javascript:GetCompany()

when i run the filter it becomes sysid in NULL.


NOTE:-- I have checked sandbox enabled.

thank you

[Ankur Bawiskar · Accepted solution]

@Adarsh kumar si 

for existing one it won't allow

please create new and then set it and use that

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Ankur Bawiskar]

@Adarsh kumar si 

1st issue is the accessibility.

Script include can't be called unless you make it Accessible from All scopes

Did you try updating that?

from where are you calling that? share screenshots

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Adarsh kumar si]

Hello @Ankur Bawiskar 
Accessible from is not updating to all scope. 

Please find the both screenshot

[Ankur Bawiskar · Accepted solution]

@Adarsh kumar si 

for existing one it won't allow

please create new and then set it and use that

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Adarsh kumar si]

Thanks @sankur ,
It worked.