ParamQuery Grid
Welcome,
Guest
. Please
login
or
register
.
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
Home
Help
Search
Login
Register
ParamQuery grid support forum
»
General Category
»
Help for ParamQuery Pro
»
How to filter integer type cells with Blanks when condition=equal is set
« previous
next »
Print
Pages: [
1
]
Author
Topic: How to filter integer type cells with Blanks when condition=equal is set (Read 2662 times)
hideki.yoshikura
Pro Enterprise
Newbie
Posts: 35
How to filter integer type cells with Blanks when condition=equal is set
«
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]
Logged
paramvir
Administrator
Hero Member
Posts: 6309
Re: How to filter integer type cells with Blanks when condition=equal is set
«
Reply #1 on:
June 25, 2020, 09:52:35 am »
Please use "empty" condition for blank cells.
«
Last Edit: June 26, 2020, 10:22:53 am by paramvir
»
Logged
hideki.yoshikura
Pro Enterprise
Newbie
Posts: 35
Re: How to filter integer type cells with Blanks when condition=equal is set
«
Reply #2 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?
Logged
hideki.yoshikura
Pro Enterprise
Newbie
Posts: 35
Re: How to filter integer type cells with Blanks when condition=equal is set
«
Reply #3 on:
July 01, 2020, 02:46:49 pm »
Excuse me, but could you answer?
Logged
paramvir
Administrator
Hero Member
Posts: 6309
Re: How to filter integer type cells with Blanks when condition=equal is set
«
Reply #4 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
«
Last Edit: July 01, 2020, 09:49:54 pm by paramvir
»
Logged
hideki.yoshikura
Pro Enterprise
Newbie
Posts: 35
Re: How to filter integer type cells with Blanks when condition=equal is set
«
Reply #5 on:
July 02, 2020, 07:30:06 am »
Thank you for your reply.
I understood the answer.
Logged
Print
Pages: [
1
]
« previous
next »
ParamQuery grid support forum
»
General Category
»
Help for ParamQuery Pro
»
How to filter integer type cells with Blanks when condition=equal is set