Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Creating the view with Workgroups and members of WG

Highlighted
Predrag Jacovic
Acclaimed 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
Honored 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
Acclaimed Contributor

Re: Creating the view with Workgroups and members of WG

Thank you for suggestions...
Predrag Jacovic
Acclaimed Contributor

Re: Creating the view with Workgroups and members of WG

I would try with SQL query to DB.
//Add this to "OnDomLoad" event