Filter accounts by Plug Account
Hi,
How can I filter accounts by the plug account property just like I can filter by other account properties such as text?
I am creating a CubeView and I need to show a series of accounts that h...
Forum Discussion
In a cube view, yes the where plugaccount = "XXXX" would be nice!
You can get all plug accounts by limiting A#XXX.where(ISIC = true).
To get a full list for a specific plug, I think I would use an XFBR. You can pass the name value pair of the plug you want, loop through all accounts in the hierarchy you want and create a string prefixed "A#" with all the account names where the plug account is the one you have passed.
Regards