Author Topic: How to filter integer type cells with Blanks when condition=equal is set  (Read 2664 times)

hideki.yoshikura

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 35
    • View Profile
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]

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Please use "empty" condition for blank cells.
« Last Edit: June 26, 2020, 10:22:53 am by paramvir »

hideki.yoshikura

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 35
    • View Profile
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?


hideki.yoshikura

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 35
    • View Profile
Excuse me, but could you answer?

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
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 »

hideki.yoshikura

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 35
    • View Profile
Thank you for your reply.

I understood the answer.