[Phpmyadmin-devel] Table search using uiTableFilter help

[Smita]

On Sun, Jun 1, 2014 at 12:28 AM, Smita <kumarismita62 at gmail.com> wrote:

>
> 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.
>
gregwebs merged my pull request [3]. :-)

[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/cadd53e9/attachment.html>