How to pull Client Reference ID in Yellowfin database

Shery Cheong shared this question 45 days ago
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.

Best Answer
photo

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:

/20d827408011f3a9000378aacd44a267

1. This is found in the TradingName column of the Organisation table:

/d77e3c6059d7f193c02efef722fb3083

(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:

/9ba4aa983b92db896e62f262917d5cd9

3. This is found in the ConfigData column that corresponds to the ConfigCode value of 'CUSTOMSTYLEPATH' in the Configuration table

/40d798a8e9c6dcce2a92b3eeda038ceb

Please let me know if you have any further questions.

Regards,

Mike

Comments (1)

photo
1

Hi Shery,

Thanks for reaching out. The Client Reference Id is the same as the corresponding IpOrg value in the Organisation table:

/bad4c6457bf2a96a0f88b375a204e76d

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

photo
1

For me, the IPOrg value shows similar to your screenshot, 130xx, but I am referring to a custom ID value I had set up myself under Admin Console > Client Organisations.

photo
1

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:

/20d827408011f3a9000378aacd44a267

1. This is found in the TradingName column of the Organisation table:

/d77e3c6059d7f193c02efef722fb3083

(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:

/9ba4aa983b92db896e62f262917d5cd9

3. This is found in the ConfigData column that corresponds to the ConfigCode value of 'CUSTOMSTYLEPATH' in the Configuration table

/40d798a8e9c6dcce2a92b3eeda038ceb

Please let me know if you have any further questions.

Regards,

Mike

photo
1

Thanks, I believe that InternalReferenceId column of the IpRltshp table is what I was looking for. To join to that table, I set an inner join of Organisation.IpOrg = IpRltshp.IpChild and a filter of RltshpTypeCode Equal to 'CUSTOMER'.

photo
1

Hi Shery,

You're welcome, and yep, those joins look valid to me! Please let me know if you require anything else here.

Regards,

Mike

photo
1

Hi Shery,

I'm going to go ahead and mark this one as Answered since I haven't heard back from you, but if you have further questions or concerns on this, if you respond, it will re-open the case and put it back in my queue and I'll be happy to help.

Regards,

Mike

photo