Prevent Blank Lines In Results

[Jeff]

When getting results returned back to the autocomplete control that will be displayed to the User, I'd like to filter out blank lines. Lines that are essentially whitespace, of no value to the User. I'd like to filter for that on the client side rather than the server. 

[Aleksandar]

Hello Jeff,

I am not sure I understand entirely the scenario. One way I can think of is by providing a dataSource.schema.parse function that would remove empty values.

If the above does not help please provide a runnable example where empty lines are returned, so I can suggest a possible approach. 

Regards,
Aleksandar
Progress Telerik

[Jeff]

This is the scenario. I have an autocomplete control that gets it's values from a DB table. So for example, if the DB table has ten entries (rows essentially), and two of the rows have blanks values or empty strings, when the values are displayed in the autocomplete dropdown list, I see two empty rows?  I wanted to eliminate those empty lines in the dropdown list from being displayed.  Originally I thought I'd just filter those lines client side.  

What I ended up doing was filtering those blank lines in the server side linq statement when getting the data with....

&& !string.IsNullOrWhiteSpace(x.Vendor))


Follow?

[Aleksandar]

Hello Jeff,

Thank you for the additional details. Indeed in this scenario, you can follow the suggestion from my previous post and configure the schema.parse function.

I created a sample to demonstrate the approach. A call to a mock API would return the following JSON, where the second object has an empty value:

[{"ProductName":"One"},{"ProductName":""},{"ProductName":"Three"}]

In this scenario you can update the function as:

            schema:{
              parse:function(response){
                var products = [];
                for (var i = 0; i < response.length; i++) {
                  if(response[i].ProductName !=""){
                    var product = {
                      ProductName: response[i].ProductName
                    };
                    products.push(product);
                  }
                }
                return products;
              }
            }

Here is the runnable example for you to review. I hope this helps.

Regards,
Aleksandar
Progress Telerik