<div dir="ltr"><br><div class="gmail_extra">On Sat, May 31, 2014 at 9:01 PM, Ashutosh Dhundhara <span dir="ltr"><<a href="mailto:ashutoshdhundhara@yahoo.com" target="_blank">ashutoshdhundhara@yahoo.com</a>></span> wrote:<br>
<div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div><div style="color:rgb(0,0,0);background-color:rgb(255,255,255);font-family:Helvetica Neue-Light,Helvetica Neue Light,Helvetica Neue,Helvetica,Arial,Lucida Grande,Sans-Serif;font-size:10pt">
<div><div><div style="color:rgb(0,0,0);background-color:rgb(255,255,255)"><div style="font-size:10pt;font-family:'Helvetica Neue-Light','Helvetica Neue Light','Helvetica Neue',Helvetica,Arial,'Lucida Grande',sans-serif">
<span>Hi Smita,</span></div><div style="font-size:10pt;font-family:'Helvetica Neue-Light','Helvetica Neue Light','Helvetica Neue',Helvetica,Arial,'Lucida Grande',sans-serif"><span><br></span></div>
<div 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">
You can exempt particular columns from searching by not specifying them in the target columns. As an example :</div><div style="color:rgb(0,0,0);font-style:normal;background-color:transparent"><pre style="font-size:12px;font-family:Consolas,'Liberation Mono',Courier,monospace;margin-top:0px;margin-bottom:0px;color:rgb(51,51,51)">
<br></pre><pre style="font-size:12px;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 style="font-size:12px;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 style="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 style="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 style="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 style="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 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></div></blockquote><div style="color:rgb(0,0,0);background-color:rgb(255,255,255)">Hi<br>Thanks. But my issue is little different. In a particular column, I have some hidden text that I want to exempt from searching, while I need visible text to be searched as usual.<br>
<br></div><div style="color:rgb(0,0,0);background-color:rgb(255,255,255)">btw I got it working, I have modified the jquery.uitablefilter.js as per my need. <br>I have added a new argument to uiTableFilter function that takes exactly what element within "tr" tag, you want to search. So i can pass the visible element tag eg "td span" in my case. Default value will be "td", So wherever else this function has been used earlier will continue to work the same.<br>
<br></div><div style="color:rgb(0,0,0);background-color:rgb(255,255,255)">Marc, I wanted to ask if it is okay to modify the jQuery plugins being used ?<br><br></div><div style="color:rgb(0,0,0);background-color:rgb(255,255,255)">
- Smita<br></div><div style="color:rgb(0,0,0);background-color:rgb(255,255,255)"><br><div style="font-size:10pt;font-family:'Helvetica Neue-Light','Helvetica Neue Light','Helvetica Neue',Helvetica,Arial,'Lucida Grande',sans-serif">
Regards,
<br clear="none">Ashutosh Dhundhara</div> <div> <div style="font-family:Helvetica Neue-Light,Helvetica Neue Light,Helvetica Neue,Helvetica,Arial,Lucida Grande,Sans-Serif;font-size:10pt"> <div style="font-family:times new roman,new york,times,serif;font-size:12pt">
<div><div><div class="h5"><div dir="ltr"> <font face="Arial"> On Saturday, 31 May 2014 6:45 PM, Smita <<a href="mailto:kumarismita62@gmail.com" target="_blank">kumarismita62@gmail.com</a>> wrote:<br clear="none"> </font> </div>
<br clear="none"><br clear="none"> </div></div><div><div><div class="h5"><div><div dir="ltr"><div><div>Hi<br clear="none"><br clear="none"></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">
<br clear="none">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">
</div><div>Please help if anybody have any idea about how to fix it.<br clear="none">
<br clear="none"></div><div>Thanks and Regards<br clear="none"></div><div>- Smita<br clear="none"></div></div></div><br clear="none"></div></div><div class="">------------------------------------------------------------------------------<br clear="none">
Time is money. Stop wasting it! Get your web API in 5 minutes.<br clear="none"><a href="http://www.restlet.com/download" target="_blank">www.restlet.com/download</a><br clear="none"><a rel="nofollow" shape="rect" href="http://p.sf.net/sfu/restlet" target="_blank">http://p.sf.net/sfu/restlet</a><br clear="none">
_______________________________________________<br clear="none">Phpmyadmin-devel mailing list<br clear="none"><a rel="nofollow" shape="rect" href="mailto:Phpmyadmin-devel@lists.sourceforge.net" target="_blank">Phpmyadmin-devel@lists.sourceforge.net</a><br clear="none">
<a rel="nofollow" shape="rect" href="https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel" target="_blank">https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel</a><br clear="none"><br clear="none"><br clear="none">
</div></div> </div></div><div> </div></div><div> </div></div><div style="font-size:10pt;font-family:'Helvetica Neue-Light','Helvetica Neue Light','Helvetica Neue',Helvetica,Arial,'Lucida Grande',sans-serif">
</div></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><br>------------------------------------------------------------------------------<br>
Time is money. Stop wasting it! Get your web API in 5 minutes.<br>
<a href="http://www.restlet.com/download" target="_blank">www.restlet.com/download</a><br>
<a href="http://p.sf.net/sfu/restlet" target="_blank">http://p.sf.net/sfu/restlet</a><br>_______________________________________________<br>
Phpmyadmin-devel mailing list<br>
<a href="mailto:Phpmyadmin-devel@lists.sourceforge.net">Phpmyadmin-devel@lists.sourceforge.net</a><br>
<a href="https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel" target="_blank">https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel</a><br>
<br></blockquote></div><br></div></div>