StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>In my old answers <a href="http://www.trirand.com/blog/?page_id=393/help/searching-on-text-field-with-accentued-chars-on-local-datas/" rel="nofollow noreferrer">here</a> and <a href="https://stackoverflow.com/questions/5822302/how-to-do-local-search-on-formatted-column-value-in-jqgrid/5822685#5822685">here</a> I described how one can implement custom filtering.</p> <p>If you in <a href="http://www.ok-soft-gmbh.com/jqGrid/CustomSearchAndSortWithFilter.htm" rel="nofollow noreferrer">the demo</a> type for example "ev" in the filter for 'Client' column you will see the following:</p> <p><img src="https://i.stack.imgur.com/vNbKg.png" alt="enter image description here"></p> <p>You can easy modify the demo to make for example 'Stephan' and 'Stefan' equivalent.</p> <p>I personally use mostly <code>defaultSearch: 'cn'</code> in the <code>filterToolbar</code> options. Together with the usage of <code>ignoreCase: true</code> it follow to very good user experience. In my personal opinion such filtering is good enough. More advanced user can use Advanced Searching to create the filter like 'begin with' "Ste" AND 'contains' "an" instead of <code>Ste*an*</code>.</p> <p>Nevertheless you can use idea from <a href="http://www.ok-soft-gmbh.com/jqGrid/CustomSearchAndSortWithFilter.htm" rel="nofollow noreferrer">my old demo</a> to overwrite some <a href="https://github.com/tonytomov/jqGrid/blob/v4.1.2/js/grid.base.js#L90" rel="nofollow noreferrer">internal searching methods</a> used by jqGrid.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload