• Replies 2 replies
  • Subscribers 337 subscribers
  • Views 93 views
  • Users 0 members are here
Related

Constituency start and end dates in Extractions/Lists

Siobhan Parker (Past Member)
$organization

Hi

I'm wondering if there is any way of adding the Constituency start and end dates to Extractions? I've added it through T_KEYWORD but it doesn't seem to connect with the constituency if the customer has more than one on their account, even if I put the Constituency in the same segment as the date.

Thanks

Siobhan

Parents
  • $organization

    Hi Siobhan,

     

    I think there are two things to check.  First, check that the criteria you added reference the same table as the standard constituency criteria.  Most standard criteria reference a secure view instead of the table, so if your added criteria reference the table while the standard criteria reference the view you not get the results you want (i.e. a single constituency row that matches both the constituency and start and end date criteria). 

     

    Once you are sure that all your criteria are referencing the same table or view, be sure that your criteria use the IN operator not the HAS operator.

     

    Kevin Sheehan

    Documentation & Learning Resources Specialist

    Tessitura Network

    1 888 643 5778 ext 329 Office

    ksheehan@tessituranetwork.com

     

Reply
  • $organization

    Hi Siobhan,

     

    I think there are two things to check.  First, check that the criteria you added reference the same table as the standard constituency criteria.  Most standard criteria reference a secure view instead of the table, so if your added criteria reference the table while the standard criteria reference the view you not get the results you want (i.e. a single constituency row that matches both the constituency and start and end date criteria). 

     

    Once you are sure that all your criteria are referencing the same table or view, be sure that your criteria use the IN operator not the HAS operator.

     

    Kevin Sheehan

    Documentation & Learning Resources Specialist

    Tessitura Network

    1 888 643 5778 ext 329 Office

    ksheehan@tessituranetwork.com

     

Children