Author Topic: Column filter on remote source override  (Read 317 times)

jplevene

  • Pro Ultimate
  • Full Member
  • *
  • Posts: 151
    • View Profile
Column filter on remote source override
« on: July 13, 2025, 07:46:19 pm »
I have a grid with multiple columns and different filter options that uses a remote data source.

One column filter (being a range drop down grid), when options are selected, I don't want to trigger a reload or even a filter, I want to call my own function that does it's own thing, does NOT request data to loaded remotely, that has nothing to do with the grid and does not affect the grid.

Is this possible and how can I do it?

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6410
    • View Profile
Re: Column filter on remote source override
« Reply #1 on: July 14, 2025, 03:27:05 pm »
beforeFilter event can be used to hook into filter for specific column(s). return false in this event cancels the remote filter request.

Code: [Select]
beforeFilter: (evt, ui)=>{
if(ui.rules.find(rule=> rule.dataIndx == 'ShipCountry')){
                //do your thing..
return false; //cancel filtering.
}
},

jplevene

  • Pro Ultimate
  • Full Member
  • *
  • Posts: 151
    • View Profile
Re: Column filter on remote source override
« Reply #2 on: Today at 02:30:20 am »
It doesn't work.  "return false" does not prevent the remote data call or even passing the parameters to the remote data call
« Last Edit: Today at 02:36:50 am by jplevene »

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6410
    • View Profile
Re: Column filter on remote source override
« Reply #3 on: Today at 06:19:11 am »
Setting return false in the beforeFilter event effectively prevents filtering by canceling the remote data request.

You can verify this behavior by using the above code in the example: https://paramquery.com/pro/demos/filter_header

If you're still encountering issues, feel free to share a JSFiddle for further assistance.