<html><body><div style="color:#000; background-color:#fff; font-family:Helvetica Neue-Light, Helvetica Neue Light, Helvetica Neue, Helvetica, Arial, Lucida Grande, Sans-Serif;font-size:10pt"><div id="yiv2574061021" class="" style=""><div class="" style=""><div style="color: rgb(0, 0, 0); background-color: rgb(255, 255, 255);" class=""><div id="yiv2574061021yui_3_16_0_6_1401548466557_4" class="" style="font-size: 10pt; font-family: 'Helvetica Neue-Light', 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><span id="yiv2574061021yui_3_16_0_6_1401548466557_17" class="" style="">Hi Smita,</span></div><div id="yiv2574061021yui_3_16_0_6_1401548466557_4" class="" style="font-size: 10pt; font-family: 'Helvetica Neue-Light', 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><span class="" style=""><br style=""></span></div><div id="yiv2574061021yui_3_16_0_6_1401548466557_4"
style="font-size: 13px; font-family: 'Helvetica Neue-Light', 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: rgb(0, 0, 0); font-style: normal; background-color: transparent;" class="">You can exempt particular columns from searching by not specifying them in the target columns. As an example :</div><div id="yiv2574061021yui_3_16_0_6_1401548466557_4" style="color: rgb(0, 0, 0); font-style: normal; background-color: transparent;" class=""><pre class="" style="font-size: 12px; font-family: Consolas, 'Liberation Mono', Courier, monospace; box-sizing: border-box; margin-top: 0px; margin-bottom: 0px; color: rgb(51, 51, 51);"><br></pre><pre class="" style="font-size: 12px; box-sizing: border-box; margin-top: 0px; margin-bottom: 0px; color: rgb(51, 51, 51);"><span style="font-family: 'Courier New', courier, monaco, monospace, sans-serif;">$.uiTableFilter($target_table, phrase, target_columns);</span></pre><pre
class="" style="font-size: 12px; box-sizing: border-box; margin-top: 0px; margin-bottom: 0px; color: rgb(51, 51, 51);"><span style="font-family: 'Courier New', courier, monaco, monospace, sans-serif;"><br></span></pre><pre class="" style="box-sizing: border-box; margin-top: 0px; margin-bottom: 0px; color: rgb(51, 51, 51);"><span style="font-family: arial, helvetica, sans-serif; font-size: 13px;">the above code will consider searching the "phrase" only in the columns specified in target_columns array.</span></pre><pre class="" style="box-sizing: border-box; margin-top: 0px; margin-bottom: 0px; color: rgb(51, 51, 51);"><span style="font-family: arial, helvetica, sans-serif; font-size: 13px;">Same is done in PMA for filtering on-screen rows on "Browse" tab for a table.</span></pre><pre class="" style="box-sizing: border-box; margin-top: 0px; margin-bottom: 0px; color: rgb(51, 51, 51);"><span style="font-family: arial, helvetica, sans-serif; font-size:
13px;">You can see the code for it in sql.js from line number 413 as of current master.</span></pre><pre class="" style="box-sizing: border-box; margin-top: 0px; margin-bottom: 0px; color: rgb(51, 51, 51);"><span style="font-family: arial, helvetica, sans-serif; font-size: 13px;"><br></span></pre></div><div id="yiv2574061021yui_3_16_0_6_1401548466557_6" class="" style="font-size: 10pt; font-family: 'Helvetica Neue-Light', 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"></div><div id="yiv2574061021yui_3_16_0_6_1401548466557_8" class="" style="font-size: 10pt; font-family: 'Helvetica Neue-Light', 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"> </div><div id="yiv2574061021yui_3_16_0_6_1401548466557_10" class="" style="font-size: 10pt; font-family: 'Helvetica Neue-Light', 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Regards,
<br clear="none" style="" class="">Ashutosh Dhundhara</div> <div class="" id="yiv2574061021yui_3_16_0_6_1401548466557_13" style="display: none;"> <div class="" style="font-family:Helvetica Neue-Light, Helvetica Neue Light, Helvetica Neue, Helvetica, Arial, Lucida Grande, Sans-Serif;font-size:10pt;"> <div class="" style="font-family:times new roman, new york, times, serif;font-size:12pt;"> <div class="" id="yiv2574061021yqtfd68517" style=""><div dir="ltr" class="" style=""> <font size="2" face="Arial" class="" style=""> On Saturday, 31 May 2014 6:45 PM, Smita <kumarismita62@gmail.com> wrote:<br clear="none" class="" style=""> </font> </div> <br clear="none" class="" style=""><br clear="none" class="" style=""> <div class="" style=""><div id="yiv2574061021" class="" style=""><div dir="ltr" class="" style=""><div class="" style=""><div class="" style="">Hi<br clear="none" class="" style=""><br clear="none" class="" style=""></div>I'm using
uiTableFilter to search for table rows. If no hidden element is in table it works fine But if table has some hidden elements it also shows a particular row if text within a hidden element of a row/column matches the search text. <br clear="none" class="" style="">
<br clear="none" class="" style="">Within my table I have hidden form input/select elements and I don't to show the filter results based on hidden element match, as to user it will seem as search result being displayed is wrong. <br clear="none" class="" style=""></div><div class="" style="">Please help if anybody have any idea about how to fix it.<br clear="none" class="" style="">
<br clear="none" class="" style=""></div><div class="" style="">Thanks and Regards<br clear="none" class="" style=""></div><div class="" style="">- Smita<br clear="none" class="" style=""></div></div></div><br clear="none" class="" style="">------------------------------------------------------------------------------<br clear="none" class="" style="">Time is money. Stop wasting it! Get your web API in 5 minutes.<br clear="none" class="" style="">www.restlet.com/download<br clear="none" class="" style=""><a rel="nofollow" shape="rect" target="_blank" href="http://p.sf.net/sfu/restlet" class="" style="">http://p.sf.net/sfu/restlet</a><br clear="none" class="" style="">_______________________________________________<br clear="none" class="" style="">Phpmyadmin-devel mailing list<br clear="none" class="" style=""><a rel="nofollow" shape="rect" ymailto="mailto:Phpmyadmin-devel@lists.sourceforge.net" target="_blank"
href="mailto:Phpmyadmin-devel@lists.sourceforge.net" class="" style="">Phpmyadmin-devel@lists.sourceforge.net</a><br clear="none" class="" style=""><a rel="nofollow" shape="rect" target="_blank" href="https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel" class="" style="">https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel</a><br clear="none" class="" style=""><br clear="none" class="" style=""><br clear="none" class="" style=""></div> </div></div><div class="" id="yiv2574061021yqtfd12267" style=""> </div></div><div class="" id="yiv2574061021yqtfd13830" style=""> </div></div><div class="" id="yiv2574061021yqtfd84801" style="font-size: 10pt; font-family: 'Helvetica Neue-Light', 'Helvetica Neue Light', 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"> </div></div></div></div></div></body></html>