dragnilar / Databvase

A (sorta) lightweight query tool for MS Sql Server that makes usage of DevExpress to provide a rich user interface
3 stars 1 forks source link

Null/Empty String Columns Are Not Easily Distinguishable For Nvarchar/VarChar Type Columns In Grid Filters #10

Open dragnilar opened 6 years ago

dragnilar commented 6 years ago

The default DevExpress grid filters do not provide the user with the ability to easily distinguish nulls and empty strings.

As a result both are combined in a category called 'blank'. This isn't a humongous problem but it does hurt the overall usability to filter out nulls from empty strings in specific data shaping/researching scenarios. It appears to overcome this, a custom filter will have to be used.

It isn't known at this point if this will require overriding the filter feature for all types of columns or if DevExpress allows you to handle it more selectively.