Henriqueb, There is a problem with the “sort” options that Scriptcase must address/fix.
here is a link to a screencast that will identify the problem as well as suggest a possible solution.
Please help
Thank you for this report, Stubuck. This issue is occurs because the internal value (the one stored in the database) of the select field you showed is the ID, and we use this value to sort the columns (the sorting is made through SQL). I’ll take it to the next development meeting and we will be deciding the most elegant way to fix this issue. I am not sure how much time it will take, because just last week we defined the road map for the next 3 months, but I’ll keep you posted. I’ll probably have to fix that myself, but it will be fixed.
I need to ask you something: You mentioned you have reported this issue before and you got no answer whatsoever. It is crucial to me to know through which channel the issue was reported. We need to make sure that no bug report channel is overseen. We have to understand why your request didn’t get to the development team and prevent such thing from happening again.
Henriqueb, Thank you very much for responding. The channels I’ve used to report this issue in the past is 1) use of this forum, 2) emails to Carlos (when he was working as the sales manager late 2015 or early 2016). 3) emails to Marcia 4) question section during “online/live presentations” 5)postings on youtube (screencast to explain the issue as early as May 2016) 6) emails with example links to Ramon Ranieri (Oct 2017)
As far as the way SC performs the sort (SQL using the ID value) I’ve spent at least ten to twelve hours going through source code (SC generated code) attempting to find the specific function that performs the ‘actual’ sort. Once I found the function, I was hoping I could create a “work-around” with no successful conclusion. When using a “symbolic” (dropdown/select) field it is vital to have the grid/multi-record form sort using the alpha of what is displayed in the field. I realize this will require significant work from SC, however, for the end user (such as a business/client/end user) when we show/demonstrate the strenght and flexibility of the grids, reports and forms and they cannot sort (for example) a list of employees or a list of products, or a list of inventory by ALPHA… it’s been a “deal-breaker”.
If necessary, I would be happy to have an online work session with you to show you the database (I use mySQL) structure as well as any suggestions/contributions I can offer. --FWIW I use TeamViewer or Google Hangout for online sessions.
Greetings Henriqueb!
Is there any information / update regarding the sort by issue?