[Phpmyadmin-devel] Table search using uiTableFilter help

[Marc Delisle]

Le 2014-05-31 13:04, Smita a écrit :
> 
> On Sat, May 31, 2014 at 9:01 PM, Ashutosh Dhundhara
> <ashutoshdhundhara at yahoo.com <mailto:ashutoshdhundhara at yahoo.com>> wrote:
> 
>     Hi Smita,
> 
>     You can exempt particular columns from searching by not specifying
>     them in the target columns. As an example :
> 
> 
>     $.uiTableFilter($target_table, phrase, target_columns);
> 
> 
>     the above code will consider searching the "phrase" only in the columns specified in target_columns array.
> 
>     Same is done in PMA for filtering on-screen rows on "Browse" tab for a table.
> 
>     You can see the code for it in sql.js from line number 413 as of current master.
> 
> 
> Hi
> 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.
> 
> btw I got it working, I have modified the jquery.uitablefilter.js as per
> my need.
> 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.
> 
> Marc, I wanted to ask if it is okay to modify the jQuery plugins being
> used ?

Hi Smita,
yes, this is the beauty of open-source licenses; see [0] at section 2.

Normally, you should contribute back your changes. Looking at the
header, we are using the "Multi-columns fork by natinusala", so please
fork [1] and send them a pull request containing your changes.

If natinusala does not merge your changes after a certain time, you
probably should keep your own fork containing your changes, and mention
this fork in the header of the js file, like natinusala did.

By the way, looks like natinusala did not send a pull request for his
changes, to gregwebs, so I'm not sure what's going on here.

[0] http://www.gnu.org/licenses/gpl-2.0.html

[1] https://github.com/natinusala/jquery-uitablefilter

> 
> - Smita
> 
> Regards,
> Ashutosh Dhundhara
> On Saturday, 31 May 2014 6:45 PM, Smita <kumarismita62 at gmail.com
> <mailto:kumarismita62 at gmail.com>> wrote:
> 
> 
> Hi
> 
> 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.
> 
> 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.
> Please help if anybody have any idea about how to fix it.
> 
> Thanks and Regards
> - Smita
> 
> ------------------------------------------------------------------------------


-- 
Marc Delisle | phpMyAdmin