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

Custom Tab Dropdown Sort Order

Former Member
Former Member $organization

I've noticed that if you include the inactive or inactive_select object in a dropdown data window then any other sort order you have applied in your datasource is ignored.

Does anyone know of any workaround to resolve this? Ideally I would want to sort by inactive then another column in my datasource. I've tried adding inactive to the ORDER BY clause, but it still doesn't work correctly.

Thanks for your help.

Parents
  • $organization

    Try specifying a sort in the dropdown datawindow, which overrides the sort in a SQL statement/procedure.  The inactive/inactive_select should then be applied BEFORE the sort defined in the dropdown datawindow.

    -Ryan

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Christine Chester
    Sent: Wednesday, December 22, 2010 4:47 AM
    To: Ryan Creps
    Subject: [Tessitura Technical Forum] Custom Tab Dropdown Sort Order

     

    I've noticed that if you include the inactive or inactive_select object in a dropdown data window then any other sort order you have applied in your datasource is ignored.

    Does anyone know of any workaround to resolve this? Ideally I would want to sort by inactive then another column in my datasource. I've tried adding inactive to the ORDER BY clause, but it still doesn't work correctly.

    Thanks for your help.




    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

    Try specifying a sort in the dropdown datawindow, which overrides the sort in a SQL statement/procedure.  The inactive/inactive_select should then be applied BEFORE the sort defined in the dropdown datawindow.

    -Ryan

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Christine Chester
    Sent: Wednesday, December 22, 2010 4:47 AM
    To: Ryan Creps
    Subject: [Tessitura Technical Forum] Custom Tab Dropdown Sort Order

     

    I've noticed that if you include the inactive or inactive_select object in a dropdown data window then any other sort order you have applied in your datasource is ignored.

    Does anyone know of any workaround to resolve this? Ideally I would want to sort by inactive then another column in my datasource. I've tried adding inactive to the ORDER BY clause, but it still doesn't work correctly.

    Thanks for your help.




    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