ParamQuery

General Category => Help for ParamQuery Pro => Topic started by: hideki.yoshikura on June 25, 2020, 08:07:40 am

Title: How to filter integer type cells with Blanks when condition=equal is set
Post by: hideki.yoshikura on June 25, 2020, 08:07:40 am
Hi

Param query version is using 6.2.4.
I want to filter cells whose dataType is integer type with Blanks cells.
If condition=equal, is it possible to filter with Blanks?
If possible, please tell me how to set it up

[img][/screen.png]
Title: Re: How to filter integer type cells with Blanks when condition=equal is set
Post by: paramvir on June 25, 2020, 09:52:35 am
Please use "empty" condition for blank cells.
Title: Re: How to filter integer type cells with Blanks when condition=equal is set
Post by: hideki.yoshikura on June 26, 2020, 11:18:04 am
Thank you for your answer

OK. I was able to solve it by using condition = empty.
By the way,
If dateType is an integer type cell and condition = equal, is it impossible to filter Blanks cell?

Title: Re: How to filter integer type cells with Blanks when condition=equal is set
Post by: hideki.yoshikura on July 01, 2020, 02:46:49 pm
Excuse me, but could you answer?
Title: Re: How to filter integer type cells with Blanks when condition=equal is set
Post by: paramvir on July 01, 2020, 09:44:17 pm
Sorry for late reply.

Inbuilt equal condition doesn't work with blanks currently.

It's possible if you override the inbuilt compare function for equal condition.

Please follow this example on how to override the compare function for any condition.

https://paramquery.com/pro/demos/filter_custom
Title: Re: How to filter integer type cells with Blanks when condition=equal is set
Post by: hideki.yoshikura on July 02, 2020, 07:30:06 am
Thank you for your reply.

I understood the answer.