jqxgrid filter custom values

[dan123Participant]

I have grid and under the indicator column, the values in this column actually don’t has dashes between them since thats the way these will be stored. The actual value is without the dashes. But i am using a cellsrenderer to format a the existing value and placing ‘-‘ between the value to look like this 11111-1111-11

Original Value: 11111111111

Displayed value: 11111-1111-11

So the problem I have is in the filtering, since the value now has dashes now I can only filter the data if I remove the dashes. So trying to figure out a solution. I need an example if there is a way to ignore the dashes even if I input that in the filtering.with dashes.

Example output:

In the filter: 11111-1111-11

Result: Shows the filtered row:
11111-1111-11

Here is my jsfiddle:
https://jsfiddle.net/vopy8nup/11/

[HristoParticipant]

Hello dan123,

You could choose many options to resolve this. You could create a filter with dropdownlist and there you could collect this records.
I would like to suggest you create a custom filtering about this scenario.
Please, take a look at this demo:
https://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/filtering-menu-custom-widgets.htm?light
Also, you could find more useful information about it in this tutorial:
https://www.jqwidgets.com/jquery-widgets-documentation/documentation/jqxgrid/jquery-grid-filtering.htm?search=grid

Best Regards,
Hristo Hristov

jQWidgets team
http://www.jqwidgets.com

[dan123Participant]

Can i get a sort of direction or function that will let me skip ‘-‘ sign to be recognized in the filter? Not restrict the character but search past that character.

Example:
I typed in filter 11111-
Don’t recognize that ‘-‘ sign just check next character after it.

Here is my jsfiddle:
https://jsfiddle.net/vopy8nup/11/

[HristoParticipant]

Hello dan123,

You could implement your custom logic to filtering by this way.

Best Regards,
Hristo Hristov

jQWidgets team
http://www.jqwidgets.com

[dan123Participant]

Hi Hristo,

I created my custom logic for the filtering, but I can’t seem to apply the filtering. Check the doFilter function

Here is my jsfiddle:
https://jsfiddle.net/UbK74/1355/

[HristoParticipant]

Hello dan123,

Please, take a look our API Documentation (about the filter property).
filter: function(cellValue, rowData, dataField, filterGroup, defaultFilterResult) {}
It has other arguments, not as in the mentioned example.

Best Regards,
Hristo Hristov

jQWidgets team
http://www.jqwidgets.com

[Author]

Posts