Author Topic: How to use local header filtering when a condition is [Range].  (Read 5943 times)

Hidehiro Ishii

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 44
    • View Profile
Hi Team,

I want to use local header filtering with [Range] condition.
But I can not find out how to use what I want.
I will send a screenshot with a comment what I want.
Please let me know a way what I want.

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: How to use local header filtering when a condition is [Range].
« Reply #1 on: August 28, 2018, 10:11:07 am »
First you clear the header checkbox, then enter "ar" in the search box, then re-check the header checkbox.

Hidehiro Ishii

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 44
    • View Profile
Re: How to use local header filtering when a condition is [Range].
« Reply #2 on: August 29, 2018, 05:45:04 am »
Hi Team,

Thank you for your reply.
I have checked  a procedure that you said.
And I have got a result that I want.
But I think it is not friendly to the user.
Because it is hard for me to be image clearing the header checkbox before entering a search word into search box.
I hope it will change a user interface next version like a MS Excel.
By the way,
Can I customize a function of local header filtering(Shipping Via) like a PQGrid 5.1.0 ?
 

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: How to use local header filtering when a condition is [Range].
« Reply #3 on: August 29, 2018, 08:33:42 am »
There is no search box for range condition in Excel filtering, so I'm not sure what way you want it?

Filtering can be customized in v5.3.0:

https://paramquery.com/pro/demos/filter_custom

Hidehiro Ishii

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 44
    • View Profile
Re: How to use local header filtering when a condition is [Range].
« Reply #4 on: August 29, 2018, 12:06:44 pm »
Hi Team,

MS Excel has a function of filter.
I will show you a screenshot of a function of filter on MS Excel.
Please check attached file.
On MS Excel, a function of filter works correctly without clearing and re-checking the header checkbox.
I want same way to work a function of filter on v5.3.0.
On v5.3.0, after entering "ar" in the search box, it does NOT work correctly if clearing & re-checking the header checkbox.
I hope it works correctly this case.
And I will try to customize in v5.3.0.

Hidehiro Ishii

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 44
    • View Profile
Re: How to use local header filtering when a condition is [Range].
« Reply #5 on: August 31, 2018, 11:00:54 am »
Hi Team、

I have tried to customize to make a function of local header filter look like v5.1.0 on v5.3.0.
But I can not find out how to customize what I want.
I will show a screen shot image that I want.
Please let me know it is possible to customize on v5.3.0.
And if it is possible,let me know how to customize.

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: How to use local header filtering when a condition is [Range].
« Reply #6 on: August 31, 2018, 07:32:50 pm »
1. Please use filter.attr

Code: [Select]
attr: "placeholder='--Select--' readonly"

2. Checkboxes can't be removed.

3. Please use "equal" filter condition. That allows only single checkbox selection.
« Last Edit: September 01, 2018, 07:57:20 am by paramquery »

Hidehiro Ishii

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 44
    • View Profile
Re: How to use local header filtering when a condition is [Range].
« Reply #7 on: September 01, 2018, 03:40:09 pm »
Thank you for your reply.
I have one more question.
Can I configure to disappear a dropdown list automatically after selecting a item ?

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: How to use local header filtering when a condition is [Range].
« Reply #8 on: September 03, 2018, 04:33:44 pm »
Not currently.

Hidehiro Ishii

  • Pro Enterprise
  • Newbie
  • *
  • Posts: 44
    • View Profile
Re: How to use local header filtering when a condition is [Range].
« Reply #9 on: September 04, 2018, 09:45:21 am »
Hi Team,

Thank you for your reply.
I have understood it is not possible to customize V5.3.0 like V5.1.0.
I hope to guarantee compatibility of previous version
and to change a function of local header filtering like MS Excel.
Please close this case.

Thanks again.