On Sat, Mar 17, 2012 at 11:06 PM, Chanaka Dharmarathna <pe.chanaka.ck@gmail.com> wrote:

On Tue, Mar 13, 2012 at 1:57 AM, Marc Delisle <marc@infomarc.info> wrote:

Le 2012-03-12 13:53, Chanaka Dharmarathna a écrit :

> On Mon, Mar 12, 2012 at 10:26 PM, Marc Delisle <marc@infomarc.info> wrote:
>
>> Le 2012-03-12 05:55, Chanaka Dharmarathna a écrit :
>>> Hi All,
>>>
>>>   I'm interested on working the feature request [1]. As I understood, it
>> is
>>> requested to link each result, which shows after browsing (click brows)
>> any
>>> field in table structure, to relevant data row in that table. Please make
>>> me correct if I'm wrong.
>>>
>>> But if the browsing row is already a link, due to that field has a
>> relation
>>> with another table field, what should be the behavior of this feature. My
>>> suggestion is to without bothering the column already a link or not, add
>> a
>>> new link as 'show data row' after click on corresponding cells. If you
>> have
>>> any suggestions please inform me to make some improvements. As well it is
>>> very helpful for me if you can suggest some source files related to these
>>> feature.
>>>
>>> [1]
>>>
>> http://sourceforge.net/tracker/index.php?func=detail&aid=2998185&group_id=23067&atid=377411
>>>
>>> Regards !
>>
>> Hi,
>> first, are you aware that this feature request refers to the "browse
>> distinct value" action, not the browse action?
>>
>> Click on a table, then Structure, then under More, click Browse distinct
>> values.
>>
>> In the results panel, I could not find a situation where there are links.
>>
>>
>> --
>> Marc Delisle
>> http://infomarc.info
>>
>>

> Hi Marc,
>
>      I mean the same thing which you have described. I'll describe you what
> is the scenario I mentioned.
>
> * We have a Company which buys Car from several companies and sells to
> customers.
> * We have 5 tables in our database. company, car, customer, sales and
> source_of_supply.
> * Source of Supply table has n:m relationship (Company - Car)
> * Sales table has n:m relationship (Customer - Car)
>
> While browsing distinct values of car_id or company_id in structure of the
> source_of_supply table, each data appear as a link. If I click on it, a
> drop down appear with the possible values in a pop up, and the link for
> corresponding company or car can be appear in that pop up. Same thing for
> the sales table. Hope you can understand the described scenario and hoping
> any suggestions.
>
> Regards !

Hi Chanaka,
Your suggestion makes sense but it will be easier to decide when seeing
the implementation.

--
Marc Delisle
http://infomarc.info

------------------------------------------------------------------------------
Try before you buy = See our experts in action!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-dev2
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel

Hi Marc,

I implemented the feature request ID: 2998185 in sourceforge [1]. The patch is attached for this implementation in tracker:patches [2]. Please update me if there should be any improvements regarding to this.

Regards !

[1] https://sourceforge.net/tracker/index.php?func=detail&aid=2998185&group_id=23067&atid=377411
[2] https://sourceforge.net/tracker/?func=detail&aid=3507111&group_id=23067&atid=377410

--
____________________________________

Chanaka Indrajith
Bsc.Computer Engineering Undergraduate
Faculty of Engineering
University of Peradeniya
____________________________________

Hi Marc,

Sorry for little delay to respond. I got your suggestions to improve the patch [1] regarding the feature request [2].
I did those improvements and attached the modified patch and a sql file with some data on the same page [1].
Thanks for your valuable suggestions.  

[1] https://sourceforge.net/tracker/index.php?func=detail&aid=2998185&group_id=23067&atid=377411
[2] https://sourceforge.net/tracker/?func=detail&aid=3507111&group_id=23067&atid=377410

Regards !

--
____________________________________

Chanaka Indrajith
Bsc.Computer Engineering Undergraduate
Faculty of Engineering
University of Peradeniya
____________________________________