[Phpmyadmin-devel] Table search using uiTableFilter help

[Smita]

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

>
> 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
>>
>

>    [3] https://github.com/gregwebs/jquery-uitablefilter/pull/12
>
>>  >
>>> > - 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/a6659e30/attachment.html>