• Replies 7 replies
  • Subscribers 337 subscribers
  • Views 47 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?

  • $organization

    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


  • Former Member
    Former Member $organization

    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!

  • $organization in reply to Former Member

    Hi Gloria,


    I found this extract in the documentation:

    Normal 0 false false false EN-GB X-NONE X-NONE MicrosoftInternetExplorer4

    The Ord Dt fields are used to limit the results to orders with order dates that fall within the range entered; orders which have a null order date (i.e. untouched rollover orders) will be retuned no matter the dates in the Ord Dt field.

    The start and end dates default to the earliest start date the latest end date among all active seasons as defined in TR_SEASON. 

    I guess if yours aren't following this, then you need to open a help ticket.

    Caryl

     

  • $organization in reply to Former Member

    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

  • Former Member
    Former Member $organization

    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!

  • $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!

  • Former Member
    Former Member $organization

    Yes, it is marked as inactive.

     

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

     

    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!




    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!