[Phpmyadmin-devel] Table search using uiTableFilter help

[Smita]

On Sat, May 31, 2014 at 11:18 PM, Marc Delisle <marc at infomarc.info> wrote:

> 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.
>
> Sure, Thanks. I'll send them a pull request :-)


> 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.
>
> gregwebs [2] also have the same copy, the one we have . so it seems he has
merged the pull request from natinusala.


> [0] http://www.gnu.org/licenses/gpl-2.0.html
>
> [1] https://github.com/natinusala/jquery-uitablefilter
>

 [2]
https://github.com/gregwebs/jquery-uitablefilter/blob/master/jquery.uitablefilter.js

>
> >
> > - 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
>
>
> ------------------------------------------------------------------------------
> Time is money. Stop wasting it! Get your web API in 5 minutes.
> www.restlet.com/download
> http://p.sf.net/sfu/restlet
> _______________________________________________
> Phpmyadmin-devel mailing list
> Phpmyadmin-devel at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20140601/b134be37/attachment.html>