Right now we have a combobox inside a grid. We cannot load all the data and bind it to the combobox initially because there are hundreds of thousands of records so instead we just limit the number of records returned based on the value in that cell (combo box).
So for example if we have a combo box that has an ID13-28-038-1. I used aCellSelectHandler and called the following down below.
This will essentially get the values of the current line and call a query to pull a limit amount of data. If there is nothing in that line it will just return null. If the user wants to copy and paste a new ID in the combo box, i need an event it will call to make the API call to the database. I tried Filtering event and valuechanged, but unfortunately the filter method will not pick up the value that has been pasted in. Also until i click somewhere off the combo box, only then will valuechanged get called and then you have to click back on the combo box and click the drop down again. Is there a way where, If i click on the combo box and paste in a value, an event can be called and display the data with the combo box expanded to show the list of results. Thanks
List selectedRows = await GridInstance.GetSelectedRecords();
if (selectedRows.First().FSDeliveryLocationId != "")
{
string locationAddress = //API call to get addresses
}
else
locationAddresses = null;
public async Task onFiltering(FilteringEventArgs args)
{
if (comboboxObj.Value != null && comboboxObj.Value !="" && comboboxObj.Value.Length > 10)
{
string locationAddress = //API call to get addresses
await this.comboboxObj.Filter(locationAddresses, query);
comboboxObj.Refresh();
}