Good morning all,
I am writing a custom report to show board member giving. Some board members are part of a household and the contributions are stored at the household level, but we want to show them next to the individual names on this particular report.
I am planning to build a custom view using one of the V_CUSTOMER_WITH_ views or maybe a function that will grab the household id for me. But I'm wondering if someone knows of a way using standard objects, or has written something custom, to do this.
I found VSB_CONTRIBUTION but that appears to do the opposite. i.e. Allowing contributions on an individual record to be pulled by the household customer_no.
Any thoughts are appreciated!
Thanks
- Levi
Hey Levi -
I'm not sure if this is what you want or not... Check in your scalar valued functions and see if FS_GET_HOUSEHOLD actually made it into your build. It was a little piece of code heaven that Chuck whipped up (I think so stop all my whining while testing) - and I know it is standard in v12, just not sure when it made it into v11.
I use it all the time - with the caveat that it is not super SUPER efficient. So if you used it on something that was pounding through a gazillion records you'd probably notice some performance hit.
HTH,
Heather
That sounds perfect Heather! I'm dealing with something less than 100 records. Unfortunately you seem to have a bit more pull than I :) The function is missing from my V11 database. If you have a few moments and can shoot me the SQL for it I'd be eternally grateful.
Heather-
I don't suppose I could get on this SQL email train, too? :) That function sounds AMAZINGly useful. We have needs similar to Levi's at our org, too. Thanks!!
Bethbethgill@umich.edu
Hey - the more the merrier. It will definitely be included in v12 release, but I got permission to share it early (thanks Tessi!). I've posted it to my profile and it is called FS_GET_HOUSEHOLD.
(We'll see if this link works)
http://www.tessituranetwork.com/Community/members/heatherlaidlawkraft3507/files/FS_5F00_GET_5F00_HOUSEHOLD.sql.aspx
Like I said. It's one of those little pieces of code that makes my world a happier place.
Enjoy!