• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • dddw/ddlb autocomplete mode - re-sorts the list after a search

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved dddw/ddlb autocomplete mode - re-sorts the list after a search

  1. Issue
0
Votes
Undo
  1. Glenn Scamman
    Glenn Scamman
  2. PowerBuilder
  3. Tuesday, 23 July 2024 21:51 PM UTC

I have noticed that when you have dddw or ddlb with the allow-editing attribute on and the autocomplete mode suggest/append (3) on, and then type in a value that partially matches one or more items in the dropdown list, and then backspace out of the editing, causing the full list to appear again, the values that were partially matched remain at the top of the list, and the rest of the list is not necessarily in the order they were in before the search.  This seems like a bug to me, but maybe it is by design?  I would expect the dropdown list to return to its original sort order after removing the edit-search.

 

drop down list before any searching

drop down list while searching

drop down list after backspacing out the search letters

Microsoft Graph API
PB application crashes when samAccountName is long...
Responses (2)
Kai Zhao @Appeon
Kai Zhao @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 24 July 2024 02:34 AM UTC
  2. PowerBuilder
  3. # 1

Hi Glenn,

For DDDW, as with your own filter implementation, the filter in PB is implemented using the filter function of datawindowchild, and the sorting is done using the sorting rules of the corresponding datawindow object. If you don't specify any sorting rules, you'll have this problem.

Please open the datawindow object corresponding to DDDW in PB IDE, and then go to Menu > Rows > Sort to set the sorting rules to solve this problem.


For DDLB, I did not reproduce the issue, please try going to the DDLB column > Properties > Edit tab to check the 'Sorted' option to see if it’s helpful. If there is still the issue, please open a Support Ticket and provide a simple PB case to us for more study, thanks.


Regards,
Kai

Comment
Glenn Scamman
  1. Glenn Scamman
  2. Wednesday, 24 July 2024 13:44 PM UTC
Thanks Kai. Yes, adding a sort to the dddw object does fix the problem. Most of our dw objects utilize ORDER BY in the SQL statements, so we did not need to add the sort property to the object. I will implement sorts on them now in addition to the order by clauses.
  1. Helpful
Glenn Scamman
  1. Glenn Scamman
  2. Wednesday, 24 July 2024 14:02 PM UTC
And to confirm, I do not see the same behavior with the DDLB...even without the sort box ticked. I just mentioned DDLB in the title because the autocomplete feature exists on both control types. Thanks again!
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 23 July 2024 22:08 PM UTC
  2. PowerBuilder
  3. # 2

Hi Glenn;

  If you are on PB 2022 R3 build 3356 and this is a reproducible issue, please open a Support Ticket. Thanks!

Regards ... Chris 

Comment
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.