Filter Bar Filter Bar : Filter Expression

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Wolfgang
Posts: 2
Joined: Mon 17 Jan 2022 10:30

Filter Bar Filter Bar : Filter Expression

Post by Wolfgang » Sun 20 Feb 2022 11:40

How can show all [Not] Empty values in a Column ?

Somthing Like : = Nil or IS NIL

and otherwise : <> Nil or is not Nil

Wolfgang
Posts: 2
Joined: Mon 17 Jan 2022 10:30

Re: Filter Bar Filter Bar : Filter Expression

Post by Wolfgang » Tue 22 Feb 2022 07:39

Realy ?
Nobody ?

Isn't it the most usefull filter Expression at all ?

or is it so easy that noboby had a similar problem ?

pavelpd
Devart Team
Posts: 109
Joined: Thu 06 Jan 2022 14:16

Re: Filter Bar Filter Bar : Filter Expression

Post by pavelpd » Wed 02 Mar 2022 14:37

Hi,
To show all rows with existing column values, you can use the following filter entry: "[field] = NULL" (or "[field] IS NULL"), and to show rows with empty values: [field] <> NULL" (or "[field] IS NOT NULL")

Post Reply