Custom filter icon on click!!!

[virksaabParticipant]

Hi Team,

Thanks for the great plugin. I just wanted to know is the below things are possible or not :

1. On filter icon click, change its colour (I’ve created an sprite image of 16×32) so that it looks like activated.
2. Custom date filter in custom filter menu (can i use another jquery date filter inside the custom filter menu).
3. Can I sort in the Show/Hide column also?
4. Can I align the filter menu to start from the left i.e. now when user click on the filter icon, the filter menu appears to be open in right column.

Thanks!!!

[HristoParticipant]

Hello virksaab,

1. I would like to suggest you look at this topic:
https://www.jqwidgets.com/community/topic/change-grid-filter-icon/

2. Yes, you could add what you want in this custom filter menu but will be better to clarify it? Do you have an issue with this?

3. Yes, it is possible to sort hidden column. You could use sort method with the datafield of the hidden column.
$('#jqxGrid').jqxGrid('sortby', 'hiddencolumndatafield', 'asc');

4. It is automatically open on left or right position depends on the space in the Grid. If you go to the most right column the menu will be open on the left side.
I would suggest you as a workaround you could use “createfilterwidget” to change the position but you should use it in ‘filterrow’.
Please, take a look the example in this topic (focus on “date” column):
https://www.jqwidgets.com/community/topic/custom-date-filter/#post-75199

Best Regards,
Hristo Hristov

jQWidgets team
http://www.jqwidgets.com

[virksaabParticipant]

2. I want to add options for today, this week, last week in calender
3. Here for sorting i’m refering to the panel, see the box which contains all the columns name with checkbox at the bottom of the table, https://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/index.htm#demos/jqxgrid/hideshowcolumns.htm, is it possible to sort this by creating two buttons for eg: Sort A-Z, Sort Z-A.
4. One thing, can it have wildcard searching like when i search Phrase it works flawlessly, but when I search like NSU*, it doesn’t show anything.

[HristoParticipant]

Hello virksaab,

2. You could create a custom filtering with one DropDownList with these options.

3. You could sort one particular column with “sortby” method. Please, take a look at this demo.

4. We do not have such option. I would suggest you again options of the custom menu filtering with your custom logic there.
Please, take a look at this tutorial, it could be useful:
https://www.jqwidgets.com/jquery-widgets-documentation/documentation/jqxgrid/jquery-grid-filtering.htm?search=grid
also, and this demo:
https://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/filtering-menu-custom-widgets.htm?light

Best Regards,
Hristo Hristov

jQWidgets team
http://www.jqwidgets.com

[Author]

Posts