jqxgrid filter with or operator using two input text boxes

[dan123Participant]

Hi i have this grid, where I want to filter by name column based on the what I type in the two textboxes.

Example: Textbox 1: Typed as Nancy
Testbox 2: Typed as Michael

Click search and the grid will now only show rows with Nancy and Michael.

Its almost complete, any help will be awesome

Here is my jsfiddle:
https://www.jseditor.io/?key=custom-filtering-in-jqx-grid-1

[StanislavParticipant]

Hello Dan123,

The fiddle you have provided isn’t showing your example.
It is the default fiddle. Could you please re-send it?
Thanks.

Best Regards,
Stanislav

jQWidgets Team
http://www.jqwidgets.com/

[dan123Participant]

Sorry its not jsfiddle you have to click Run button on right.

[StanislavParticipant]

Hello Dan123,

Before you send the link, you should make sure that you have enabled the share with everyone property.
Only after doing that other people can see your example. By default, it just opens Hello :-).

Best Regards,
Stanislav
jQWidgets Team
http://www.jqwidgets.com/

[dan123Participant]

Just updated. Also i wanted to update what i said on my original post. I also want like a range filter so like only show rows 1 to 10.

[dan123Participant]

Basically I have two input fields and I want to filter based on what I enter in the two textboxes. The already created the logic but the filtering is not working.

Example: Filtering by Quantity column
First textbox value = 1
Second textbox value = 10

I want to show only rows within that range so only show rows from 1 to 10.

Hi here is my new updated link: https://jsfiddle.net/tkhgy/96/

[StanislavParticipant]

Hello Dan123,

Here is a fiddle. You can select ranges in the quantity column. If you want to change the filtered column, you need to specify it $("#jqxgrid").jqxGrid('addfilter', <strong>'quantity'</strong>, filtergroup);.

Best Regards,
Stanislav
jQWidgets Team
http://www.jqwidgets.com/

[dan123Participant]

Sorry your example does not even filter the quantity column

[StanislavParticipant]

Hello Dan123,

Sorry for the wrong fiddle. Here is a working example.

Best Regards,
Stanislav
jQWidgets Team
http://www.jqwidgets.com/

[Author]

Posts