Hi!
I'm trying to update a custom Header Element written for us during implementation and need to know the numbers for all my membership orgs. Can I find those numbers anywhere in the front end of the software? I don't have anyone onsite who can look in the database for me and trying to find it out by trial and error in TEST is driving me loopy. Thanks!
Hi Jama! There isn't a place in the application where you can see the ID. But there is an output set element called Membership_memb_org_id that will output the ID number. You could use that in an output set and run it against a list of members to see the IDs.
-Michael Wilcox, Tessitura Network
As the ID number doesn't show up under campaigns -> memberships I don't think you can find it within Tessitura in an easy way.
If you have Membership Organisation as a list manager criteria, you could probably find out the ID numbers by selecting Membership Organisation IN (and then a particular level) and then clicking 'show query' which should be selecting the id number of that particular level.
If you have access to SQL you can:
Select * from T_MEMB_ORGHope that helps!James
Hi Michael! I was trying to keep from emailing you saying "help!" but I was awfully glad to see your reply! When I run the output set, the column is totally blank. Any idea what I might be doing wrong?
Thanks James! I looked in List Manager, but we unfortunately don't have that as a criteria.
Did you provide a value in the Membership Organization parameter in Execute and Output Set?
Thank you Michael! (We miss you!)