book
Article ID: KB0071780
calendar_today
Updated On:
Description
In this article, we will discuss the process of retrieving the Group details of the User according to the Group they belong to.
Resolution
Currently, there are two methods to achieve this:
In the first method, get the User names by Group using the getUsersByGroup() API. Input the result into a view and use the XML extract function to fetch the names in text format (refer to the below sample screenshot).
In the second method, we can connect to the TDV repo and get the User/Group details from the Metadata tables.
NOTE: Do not make any changes to the TDV Metadata Repository Database.
- Connect to TDV repo using any JDBC client such as DBVisualizer or PGadmin (refer to the KB article in the reference section).
- Explore cis_repo schema.
- Run the below query to get user_names and their respective groups.
- select gm.group_id, su.name
from cisrepo.security_members su, cisrepo.security_group_members gm
where gm.member_id = su.id;
Note: Modify the queries mentioned in this article according to your deployment.
Issue/Introduction
How to retrieve the Group details of a User based on the Group they belong to in TIBCO Data Virtualization?