RumDoodle Posted October 16, 2017 Share Posted October 16, 2017 It is possible to filter a DBComboBox on dropdown/expand? Quote Link to comment Share on other sites More sharing options...
Sherzod Posted October 16, 2017 Share Posted October 16, 2017 Hi, Can you clarify your question ?! Quote Link to comment Share on other sites More sharing options...
RumDoodle Posted October 16, 2017 Author Share Posted October 16, 2017 I have a combo box with 20 item. Of these 20 item Only 10 are "enabled", and want the drop down selection to be only these 10 items. The other 10 items are required in the list for legacy data display purposes. Quote Link to comment Share on other sites More sharing options...
Sherzod Posted October 17, 2017 Share Posted October 17, 2017 Hi, By what value do you want to filter, what is your filter condition ?! Quote Link to comment Share on other sites More sharing options...
RumDoodle Posted October 17, 2017 Author Share Posted October 17, 2017 The source dataset for the lookup is "code", "description", "enabled". "Code" is the key field, "description" is the value displayed. "enabled" is either 1 or 0, if 1 then make the record available in the drop down list. Quote Link to comment Share on other sites More sharing options...
Sherzod Posted October 17, 2017 Share Posted October 17, 2017 Hi, Can you try to analyze these demo examples ?: \FMSoft\Framework\uniGUI\Demos\Desktop\ComboBox Remote Data \FMSoft\Framework\uniGUI\Demos\Desktop\DBLookupComboBox - Custom Remote Query \FMSoft\Framework\uniGUI\Demos\Desktop\DBLookupComboBox - Custom Remote Query (CDS) OnRemoteQuery event Quote Link to comment Share on other sites More sharing options...
RumDoodle Posted October 17, 2017 Author Share Posted October 17, 2017 Thanks, but those appear to only work when entering a value into the ComboBox. If no value is entered then the list is empty, if a value has been selected previously and subsequently cleared the old value is used for the list filter. Is there no way to use the expand and collapse ExtEvents to set and clear a filter on the DBLookupComboBox store? Quote Link to comment Share on other sites More sharing options...
Sherzod Posted October 17, 2017 Share Posted October 17, 2017 Hi, I will try to give you a solution a bit later Quote Link to comment Share on other sites More sharing options...
Administrators Farshad Mohajeri Posted October 17, 2017 Administrators Share Posted October 17, 2017 Thanks, but those appear to only work when entering a value into the ComboBox. Well, it can not happen because it means that ALL data must be fetched which can be huge. Quote Link to comment Share on other sites More sharing options...
RumDoodle Posted October 18, 2017 Author Share Posted October 18, 2017 Well, it can not happen because it means that ALL data must be fetched which can be huge. Doesn't this already happen if I just expand the ComboBox without entering any text? Quote Link to comment Share on other sites More sharing options...
Administrators Farshad Mohajeri Posted October 18, 2017 Administrators Share Posted October 18, 2017 In local mode yes, but in remote mode data is provided by the user. Sent from my SM-N900 using Tapatalk Quote Link to comment Share on other sites More sharing options...
Administrators Farshad Mohajeri Posted October 18, 2017 Administrators Share Posted October 18, 2017 Thanks, but those appear to only work when entering a value into the ComboBox. If no value is entered then the list is empty, if a value has been selected previously and subsequently cleared the old value is used for the list filter. Is there no way to use the expand and collapse ExtEvents to set and clear a filter on the DBLookupComboBox store? Set RemoteQueryCache->False so previous data will not be shown. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.