[Vesku1980]

Hi,

I have a need to create a search from user roles.

Is it possible to have results from saved search like i have in image attached?

Regards

Vesku
This is a cached copy. Click here to see the original post.

[MChammaTX]

Depends how many roles you have but you could add columns by each role and the use something like case when {role.id} = '123' then {role.name} else '' end and then Group by employee name and all your columns.

Alternatively you could use the Pivot Reports BETA bundle but keep in mind this will be deactivated by NetSuite at any time to make way for the upcoming SuiteAnalytics upgrade.

[michoel]

Another option is a grouped search with the NS_CONCAT function, you will get a single column but with all the roles in a single row per user

---

teholmbe replied on 04/10/2018, 02:20 AM: My colleague Vesku raised this Q and this is what I was looking for. Thanks!

[Author]

Posts