Memb_org_no

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!

Parents
  • 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_ORG

    Hope that helps!
    James 



    [edited by: James Davis at 12:29 PM (GMT -6) on 23 Aug 2016]
Reply
  • 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_ORG

    Hope that helps!
    James 



    [edited by: James Davis at 12:29 PM (GMT -6) on 23 Aug 2016]
Children