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.
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 ChesterSent: Wednesday, December 22, 2010 4:47 AMTo: Ryan CrepsSubject: [Tessitura Technical Forum] Custom Tab Dropdown Sort Order
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!
Thanks for that, it now works perfectly.
I put that down to another corner of InfoMaker that I wasn't aware of!