How to pull Client Reference ID in Yellowfin database
Answered
Hi, I am trying to build a reporting on Yellowfin data around usage by client organization. Which table stores the Client Reference ID? I have checked "Organisation" but it does not appear to live there.
The same question
Hi Shery,
Ah, yes. I see where you're referring to now. There's actually a few tables these settings touch. I'll just provide them all:
1. This is found in the TradingName column of the Organisation table:
(The Time Zone details are stored in this table too, for the record)
2. This is found in the InternalReferenceId column of the IpRltshp table:
3. This is found in the ConfigData column that corresponds to the ConfigCode value of 'CUSTOMSTYLEPATH' in the Configuration table
Please let me know if you have any further questions.
Regards,
Mike
Hi Shery,
Ah, yes. I see where you're referring to now. There's actually a few tables these settings touch. I'll just provide them all:
1. This is found in the TradingName column of the Organisation table:
(The Time Zone details are stored in this table too, for the record)
2. This is found in the InternalReferenceId column of the IpRltshp table:
3. This is found in the ConfigData column that corresponds to the ConfigCode value of 'CUSTOMSTYLEPATH' in the Configuration table
Please let me know if you have any further questions.
Regards,
Mike
Hi Shery,
Thanks for reaching out. The Client Reference Id is the same as the corresponding IpOrg value in the Organisation table:
If you're not seeing Client Orgs in your Organisation table, the only possibility I can think of is that it's a different config db from what you're looking at in the UI. However, you did also note you're on Product Version of '6.3 & older'; if this is actually the case, there's also a possibility that Client Org definitions were stored differently. What are you seeing in Organisation?
Regards,
Mike
Hi Shery,
Thanks for reaching out. The Client Reference Id is the same as the corresponding IpOrg value in the Organisation table:
If you're not seeing Client Orgs in your Organisation table, the only possibility I can think of is that it's a different config db from what you're looking at in the UI. However, you did also note you're on Product Version of '6.3 & older'; if this is actually the case, there's also a possibility that Client Org definitions were stored differently. What are you seeing in Organisation?
Regards,
Mike
Replies have been locked on this page!