Pulling Constituency withe End Date

Hello All, 

I have a constituency with a start and end date that has passed. I want to pull a list of those records. 

My list criteria is as follows:

Constituency - IN - student

Constituency End Date - = - 5/16/13

This is not giving me any results. What step am I missing?

Thanks, 

Marie Kocher

Development Assistant

Kansas City Ballet

500 W Pershing Rd

Kansas City, MO 64108

(816) 931-2232 x 1382

mkocher@kcballet.org

Parents
  • Hi Marie,

     

    One other thing you might want to check is if you are using a list element that is only for active constituencies, since your constituency is now inactive.  I know we have some elements that are only for active constituencies and others that will pull all constituencies whether they are active or inactive.  (I’m not sure if these were customized or not.)

     

    Hope that helps.

     

    T.C. Brown

    Database Administrator

    412.392.4834

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Marie Kocher
    Sent: Tuesday, August 27, 2013 5:27 PM
    To: TC Brown
    Subject: RE: [Tessitura Development Forum] Pulling Constituency withe End Date

     

    Yes, I did try different operators. Thanks for the suggestion. I think it is something on my end “behind the scenes.”

     

    Marie

     

    --

    Marie Kocher | Development Assistant

    Kansas City Ballet

    Todd Bolender Center for Dance and Creativity

    500 W Pershing Road

    Kansas City, MO 64108

    816-931-2232 x 1382 | 816-931-1172 (fax)

    mkocher@kcballet.org

     

    Buy tickets and enroll for classes: www.kcballet.org


    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Terry Stevens
    Sent: Tuesday, August 27, 2013 1:48 PM
    To: Marie Kocher
    Subject: Re: [Tessitura Development Forum] Pulling Constituency withe End Date

     

    Are you sure your constituency end date for all the records you are looking for is 5/16/13?  Maybe you want to use BETWEEN or GREATER THAN rather than equals.

    From: Marie Kocher <bounce-mariekocher5698@tessituranetwork.com>
    Sent: 8/27/2013 1:09:52 PM

    Hello All, 

    I have a constituency with a start and end date that has passed. I want to pull a list of those records. 

    My list criteria is as follows:

    Constituency - IN - student

    Constituency End Date - = - 5/16/13

    This is not giving me any results. What step am I missing?

    Thanks, 

    Marie Kocher

    Development Assistant

    Kansas City Ballet

    500 W Pershing Rd

    Kansas City, MO 64108

    (816) 931-2232 x 1382

    mkocher@kcballet.org




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Reply
  • Hi Marie,

     

    One other thing you might want to check is if you are using a list element that is only for active constituencies, since your constituency is now inactive.  I know we have some elements that are only for active constituencies and others that will pull all constituencies whether they are active or inactive.  (I’m not sure if these were customized or not.)

     

    Hope that helps.

     

    T.C. Brown

    Database Administrator

    412.392.4834

     

    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Marie Kocher
    Sent: Tuesday, August 27, 2013 5:27 PM
    To: TC Brown
    Subject: RE: [Tessitura Development Forum] Pulling Constituency withe End Date

     

    Yes, I did try different operators. Thanks for the suggestion. I think it is something on my end “behind the scenes.”

     

    Marie

     

    --

    Marie Kocher | Development Assistant

    Kansas City Ballet

    Todd Bolender Center for Dance and Creativity

    500 W Pershing Road

    Kansas City, MO 64108

    816-931-2232 x 1382 | 816-931-1172 (fax)

    mkocher@kcballet.org

     

    Buy tickets and enroll for classes: www.kcballet.org


    From: Tessitura Development Forum [mailto:forums-development@tessituranetwork.com] On Behalf Of Terry Stevens
    Sent: Tuesday, August 27, 2013 1:48 PM
    To: Marie Kocher
    Subject: Re: [Tessitura Development Forum] Pulling Constituency withe End Date

     

    Are you sure your constituency end date for all the records you are looking for is 5/16/13?  Maybe you want to use BETWEEN or GREATER THAN rather than equals.

    From: Marie Kocher <bounce-mariekocher5698@tessituranetwork.com>
    Sent: 8/27/2013 1:09:52 PM

    Hello All, 

    I have a constituency with a start and end date that has passed. I want to pull a list of those records. 

    My list criteria is as follows:

    Constituency - IN - student

    Constituency End Date - = - 5/16/13

    This is not giving me any results. What step am I missing?

    Thanks, 

    Marie Kocher

    Development Assistant

    Kansas City Ballet

    500 W Pershing Rd

    Kansas City, MO 64108

    (816) 931-2232 x 1382

    mkocher@kcballet.org




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Development Forum. You may reply to this message to post to the Development forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Children
No Data