Forum Discussion

sdayringer's avatar
sdayringer
New Contributor III
3 years ago
Solved

Extract Account's Assigned Plug Account via SQL

Hello, How can I call an account's assigned plug account via SQL? I able to get the PlugAcct DecimalValue, but need help with the syntax to return the account member name instead of the ID... SEL...
Reports
  • JackLacava's avatar
    JackLacava
    3 years ago

    You're joining on the wrong thing in the PlugAccount subquery. Should be:

    LEFT JOIN Member PA ON MP.DecimalValue = PA.MemberId

     

Henning's avatar
Henning
Icon for OneStream Employee rankOneStream Employee
3 years ago

Hi - also for possible audience reading this later - please keep in mind to use native functionality in the business rules to, such as in this case, check an account's assigned plug account. Only use SQL when really necessary, which may of course be the case here!

Just adding this as I have seen too many solutions where (complex) SQL was used instead of going the simple way via built-in functionality.