How do i get a list of all users per Organisation?

Hello Jimmar Claro Tangkia,

My name is Ankit Asati from the Yellowfin Technical Support Team. We have received your support request, and I will be your primary contact on the following ticket:

Ticket Number: #32161
Case Title: How do i get a list of all users per Organisation?

Issue Overview:
How do i get a list of all users per Organisation?

Request for Additional Information:

To better understand and expedite the resolution of your case, please provide me following details:

• The info.jsp file for this instance in HTML format. In order to get this file please follow the instructions in the following link: https://community.yellowfinbi.com/topic/how-to-get-the-info-jsp/

Next Steps and Workarounds:

Please allow us some time while we fetch the information for you, Please share requested information.

Sincerely,

Ankit Asati

Yellowfin Technical Support Engineer

Here you go

Hello Jimmar Claro Tangkia,

Thank you for your patience,

The IpRltshp table outlines the connection between individuals and their respective organizations. The IpParent field represents the organization code, while the IpChild field indicates the user's ID. in order to retrieve information about 'ACTIVE' users within an organization, we can utilize a query similar to the one provided below.

SELECT o.OrgName, ir.IpChild, p.IpPerson, p.LastName, p.FirstName
FROM Person p
JOIN IpRltshp ir
ON p.IpPerson = ir.IpChild
JOIN Organisation o
ON ir.IpParent = o.IpOrg
where p.Status = 'ACTIVE'
AND ir.IpParent = <OrgCode>

Kindly update their IpParent to Organization id which can be retrieved from the Organization table within the configuration database.

We have the capability to adjust the query to display the required fields from various tables. Hope it helps!

Thank you,

Ankit Asati

Yellowfin Technical Support

Hello Jimmar Claro Tangkia

I wanted to follow up with you regarding the solution I provided in my last email. Did the solution we sent you resolve the issue?

Please let us know if you need additional support on this issue.

Thank you,

Ankit Asati

Yellowfin Technical Support

Hello Jimmar Claro Tangkia

I wanted to follow up with you regarding the solution I provided in a previous email. Did the solution we sent you resolve the issue?

If you are unavailable right now, you can always contact us again at a later time by opening a new ticket I will close this case by the end of business tomorrow if I do not receive a reply.

Please let us know if you need additional support on this issue.

Thank you,

Ankit Asati

Yellowfin Technical Support

Hi Ankit, you can close this case now.

Hello Jimmar Claro Tangkia

I am glad to hear the issue was resolved, thank you for the confirmation on closure of the case. If you have any other issue please contact us again by opening up a new ticket and we will provide additional support.

Thank you,

Ankit Asati

Yellowfin Technical Support

Hello,

In the IpRltshp table, what is the meaning of the rltshptypecode column?

I would like to understand whether it is possible, based on this table, to identify the origin of a user’s relationship with an organization. Specifically, I need to distinguish between two scenarios:

• Users who were created directly within a client organization and have access only to that organization's data.
• Users who were created in the default organization and later linked to other organizations.

After reviewing the table structure, I had the impression that the rltshptypecode column might be related to the type of relationship between the user and the organization, possibly allowing these scenarios to be identified. Could you confirm whether this interpretation is correct or indicate which field or table should be used to make this distinction?