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?
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).