• Replies 7 replies
  • Subscribers 337 subscribers
  • Views 49 views
  • Users 0 members are here
Related

Order Date Parameter in Order Seach

Former Member
Former Member $organization

When you use Order Search from the order screen, the system defaults the order date to dates that I cannot make sense of. We want all order searches to default to all order dates. Anyone know the logic behind how it picks the date range for Order Date?

Parents
  • $organization

    Is the season marked as inactive(checked in TR_SEASON.inactive)?  The start/end dates don’t control whether a season is active or not.

    -Ryan

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Gloria Ormsby
    Sent: Friday, November 05, 2010 11:21 AM
    To: Ryan Creps
    Subject: RE: [Tessitura Technical Forum] Order Date Parameter in Order Seach

     

    No, this isn’t the case because the first order date it displays is for a season that is not active. I’m stumped.

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jonathan Smillie
    Sent: Thursday, November 04, 2010 1:32 PM
    To: Gloria Ormsby
    Subject: RE: [Tessitura Technical Forum] Order Date Parameter in Order Seach

     

    Just a quick double-check and clarification - the "active seasons" refers to all seasons in TR_SEASON that do not have the "inactive" checkbox checked. A season that is past its end_dt value, but not marked inactive, can still have an effect on these values if its start_dt and end_dt values are early or late enough.


    Jonathan

    From: Gloria Ormsby <bounce-gloriaormsby5026@tessituranetwork.com>
    Sent: 11/4/2010 11:52:58

    I don’t think so because the start dates default to dates other than in the active seasons.

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Caryl Jones
    Sent: Thursday, November 04, 2010 12:12 PM
    To: Gloria Ormsby
    Subject: Re: [Tessitura Technical Forum] Order Date Parameter in Order Seach

     

    I think that the order start and end dates come from TR_SEASON. So that they show the dates for the currently active Seasons start and end dates; taking the earliest start date and latest end date if you have more than one season.

    Caryl

     

    From: Gloria Ormsby <bounce-gloriaormsby5026@tessituranetwork.com>
    Sent: 11/4/2010 10:41:33

    When you use Order Search from the order screen, the system defaults the order date to dates that I cannot make sense of. We want all order searches to default to all order dates. Anyone know the logic behind how it picks the date range for Order Date?




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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 Technical Forum. You may reply to this message to post to the Technical 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 Technical Forum. You may reply to this message to post to the Technical 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
  • $organization

    Is the season marked as inactive(checked in TR_SEASON.inactive)?  The start/end dates don’t control whether a season is active or not.

    -Ryan

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Gloria Ormsby
    Sent: Friday, November 05, 2010 11:21 AM
    To: Ryan Creps
    Subject: RE: [Tessitura Technical Forum] Order Date Parameter in Order Seach

     

    No, this isn’t the case because the first order date it displays is for a season that is not active. I’m stumped.

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Jonathan Smillie
    Sent: Thursday, November 04, 2010 1:32 PM
    To: Gloria Ormsby
    Subject: RE: [Tessitura Technical Forum] Order Date Parameter in Order Seach

     

    Just a quick double-check and clarification - the "active seasons" refers to all seasons in TR_SEASON that do not have the "inactive" checkbox checked. A season that is past its end_dt value, but not marked inactive, can still have an effect on these values if its start_dt and end_dt values are early or late enough.


    Jonathan

    From: Gloria Ormsby <bounce-gloriaormsby5026@tessituranetwork.com>
    Sent: 11/4/2010 11:52:58

    I don’t think so because the start dates default to dates other than in the active seasons.

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Caryl Jones
    Sent: Thursday, November 04, 2010 12:12 PM
    To: Gloria Ormsby
    Subject: Re: [Tessitura Technical Forum] Order Date Parameter in Order Seach

     

    I think that the order start and end dates come from TR_SEASON. So that they show the dates for the currently active Seasons start and end dates; taking the earliest start date and latest end date if you have more than one season.

    Caryl

     

    From: Gloria Ormsby <bounce-gloriaormsby5026@tessituranetwork.com>
    Sent: 11/4/2010 10:41:33

    When you use Order Search from the order screen, the system defaults the order date to dates that I cannot make sense of. We want all order searches to default to all order dates. Anyone know the logic behind how it picks the date range for Order Date?




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical 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 Technical Forum. You may reply to this message to post to the Technical 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 Technical Forum. You may reply to this message to post to the Technical 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