Service Desk Practitioners Forum
cancel

Creating the view with Workgroups and members of WG

Highlighted
Predrag Jacovic
Contributor.

Creating the view with Workgroups and members of WG

I have tried to create a view in SD 4.5 (SP23) which should represent the table with workgroups and its members. This is intended to be a report to the Sales.
I'm not able to find attribute "members" (which is available when one creates explorer type view and in Leaves section Member attribute is present).
Anyone has an idea how to do this?
3 REPLIES
Radovan Skolnik
Acclaimed Contributor.

Re: Creating the view with Workgroups and members of WG

It is only possible in explorer view. You see the "members" attribute does not in fact exist in any database table (it cannot as it is M:N relationship between Person and Workgroup objects). The implementation in such cases is done in a table that has 2 major columns (a pair) referencing Person and Workgroup. This table is not visible in ServiceDesk as an entity (could be hacked I think to be visible). Easiest way to accomplish what you want is to report on database level (direct SQL query).
Predrag Jacovic
Contributor.

Re: Creating the view with Workgroups and members of WG

Thank you for suggestions...
Predrag Jacovic
Contributor.

Re: Creating the view with Workgroups and members of WG

I would try with SQL query to DB.