Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>In my old <a href="http://www.trirand.com/blog/?page_id=393/help/searching-on-text-field-with-accentued-chars-on-local-datas/#p21529" rel="nofollow">answer</a> in the trirand forum I described how to implement custom local filtering and sorting. <a href="http://www.ok-soft-gmbh.com/jqGrid/CustomSearchAndSort.htm" rel="nofollow">The demo</a> shows accent free searching and sorting. If you use the same technique you can overwrite some jqGrid functions used for searching (<code>_toStr</code> and <code>_getStr</code> for example) and implement it so that in case of arrays you will use your own it's implementation.</p> <p>To make my answer more Google friendly I include small code fragment</p> <pre><code>function myAccentRemovement(s) { // the s parameter is always string s = s.replace(/[àáâãäå]/gi,'a'); s = s.replace(/[èéêë]/gi,'e'); s = s.replace(/[ìíîï]/gi,'i'); s = s.replace(/[òóôõöø]/gi,'o'); s = s.replace(/[ùúûü]/gi,'u'); s = s.replace(/[ýÿ]/gi,'y'); s = s.replace(/æ/gi,'ae'); s = s.replace(/œ/gi,'oe'); s = s.replace(/ç/gi,'c'); s = s.replace(/š/gi,'s'); s = s.replace(/ñ/gi,'n'); s = s.replace(/ž/gi,'z'); return s; } //... var oldFrom = $.jgrid.from; $.jgrid.from = function(source,initalQuery){ var result = oldFrom(source,initalQuery); var old_toStr = result._toStr; result._toStr=function(s) { return myAccentRemovement(old_toStr(s)); }; result._getStr=function(s) { var phrase=[]; if(this._trim){ phrase.push("jQuery.trim("); } phrase.push("myAccentRemovement(String("+s+"))"); if(this._trim){ phrase.push(")"); } if(!this._usecase){ phrase.push(".toLowerCase()"); } return phrase.join(""); } return result; } </code></pre> <p>It will be solve the problem. I can't gives you more exact suggestions because you posted no information about the exact structure of data which you use.</p>
    singulars
    1. This table or related slice is empty.
    1. POhow to do local search on formatted column value in jqgrid?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USOleg
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POhow to do local search on formatted column value in jqgrid?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThanks, Oleg. Your code doesn't quite work for me because it doesn't allow me to format values differently for different columns. Replacing _getStr() replaces it for *all* column filtering, not just the one that needs formatting. If all of my column used the same formatting, I could replace your "myAccentRemovement(String" with "my_formatter".
      singulars
      1. PO
      1. USadam-p
    2. CO@adampx: It's difficult to help you because you don't post the code which you use. For example [this.equals](https://github.com/tonytomov/jqGrid/blob/v4.0.0/js/grid.base.js#L498) and all other methods have the column name as the first parameter. The function `_getStr` (which I overwride in my demo) will be called inside of the `this.equals` or `this.contains`. The function `_getStr` will be called with the column name. So one do can implement all what you need, but you should make more changes in my demo.
      singulars
      1. PO
      1. USOleg
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

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