This is a migrated thread and some comments may be shown as answers.

Filter (Blanks) Programmatically

4 Answers 64 Views
DataFilter
This is a migrated thread and some comments may be shown as answers.
Matthew
Top achievements
Rank 1
Matthew asked on 17 Sep 2019, 02:22 PM

I am attempting to filter results in a RadGrid.

What I am looking for is the programmatic equivalent of selecting the all but (blanks) or not (blanks) option from the filtering area.

I will apply filters of " " and "" but still will get results of "   " or varying amounts of whitespace that I don't want in the results. I cannot do this with a composite filter as I cannot capture all of cases of whitespace, but removing (blanks) achieves the correct results.

Thanks

4 Answers, 1 is accepted

Sort by
0
Matthew
Top achievements
Rank 1
answered on 17 Sep 2019, 02:28 PM
Basically I want the equivalent filter of "All but (Blanks)"
0
Dimitar
Telerik team
answered on 18 Sep 2019, 07:43 AM

Hello Matthew,

This is not possible with the regular filter since it only has one value. When using the "Blanks" option from the drop-down the grid will iterate all rows and creates a composite filter (see attached). In this case, I would recommend doing the same. Another option is to use custom filtering

I hope this helps. Should you have any other questions, do not hesitate to ask.

Regards,
Dimitar
Progress Telerik

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
0
Matthew
Top achievements
Rank 1
answered on 18 Sep 2019, 02:48 PM

I appreciate pointing me in the right direction.

For my solution I iterated through the rows and marked all cells as "invalid". Then I applied a filter for the string "invalid" so I can hide them but also see all offending rows.

Thanks Dimitar,

 

0
Dimitar
Telerik team
answered on 19 Sep 2019, 08:11 AM

Hello Matthew, 

I am glad that you have found a solution to this. Do not hesitate to contact us if you have other questions.

Regards,
Dimitar
Progress Telerik

Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Tags
DataFilter
Asked by
Matthew
Top achievements
Rank 1
Answers by
Matthew
Top achievements
Rank 1
Dimitar
Telerik team
Share this question
or