J
Jeff Ledbetter
Guest
Cook, thanks. We will give that a try. In this case, all the data would have been fetched in a single batch so this may work. Jeff Ledbetter www.roundtable-software.com email: jeff.ledbetter@roundtable-software.com skype: jeff.ledbetter From: Håvard Danielsen [mailto:bounce-hdaniels@community.progress.com] Sent: Monday, March 9, 2015 4:39 PM To: TU.OE.Development@community.progress.com Subject: RE: [Technical Users - OE Development] ADM2 - Sort SmartBrowse by Calculated Field RE: ADM2 - Sort SmartBrowse by Calculated Field Reply by Håvard Danielsen The ADM2 can have calculated fields in the SmartBrowse or in the SDO. I don't think it is possible to sort on a calculated field defined in the SmartBrowse as it is is generated as an expression in the browse's DISPLAY statement. Unfortunately, it is not supported to sort on a calculated field in the SDO either. This is addressed in issue PSC00261588, which currently is not scheduled. You may call Support and let them know that you need/want this fixed, but be aware that one of the reasons this has not been fixed is that it is very unlikely that we could make it work nicely/seamlessly when batching. But we could fix the SDO to support sort on calculated fields when all the data is on the client. There are many ways to fix this with code, the simplest is probably to override newQuerySort in the SDO and override the last parameter before the call to super to force it to make the sort local when there is a calculated field as follows. function newQuerySort returns character ( input pcQuery as character, input pcSort as character, input plDBColumns as logical ): /*------------------------------------------------------------------------------ Purpose: Notes:
Continue reading...
Continue reading...