[Phpmyadmin-devel] Need some suggestions for a feature request

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=23... Regards ! -- ____________________________________ Chanaka Indrajith Bsc.Computer Engineering Undergraduate Faculty of Engineering University of Peradeniya ____________________________________

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=23...
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

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=23...
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
------------------------------------------------------------------------------ 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 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 ! -- ____________________________________ Chanaka Indrajith Bsc.Computer Engineering Undergraduate Faculty of Engineering University of Peradeniya ____________________________________

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=23...
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

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=23...
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=2... [2] https://sourceforge.net/tracker/?func=detail&aid=3507111&group_id=23067&atid... -- ____________________________________ Chanaka Indrajith Bsc.Computer Engineering Undergraduate Faculty of Engineering University of Peradeniya ____________________________________

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=23...
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=2... [2] https://sourceforge.net/tracker/?func=detail&aid=3507111&group_id=23067&atid...
-- ____________________________________
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=2... [2] https://sourceforge.net/tracker/?func=detail&aid=3507111&group_id=23067&atid... Regards ! -- ____________________________________ Chanaka Indrajith Bsc.Computer Engineering Undergraduate Faculty of Engineering University of Peradeniya ____________________________________

On Thu, Mar 22, 2012 at 1:25 AM, Chanaka Dharmarathna < pe.chanaka.ck@gmail.com> wrote:
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=23...
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=2... [2] https://sourceforge.net/tracker/?func=detail&aid=3507111&group_id=23067&atid...
-- ____________________________________
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=2... [2] https://sourceforge.net/tracker/?func=detail&aid=3507111&group_id=23067&atid...
Regards !
-- ____________________________________
Chanaka Indrajith Bsc.Computer Engineering Undergraduate Faculty of Engineering University of Peradeniya ____________________________________
Hi, Including the suggestions of Marc, I improved the patch for feature request [0] , and attached at [1]. If anyone can review it, I can do the needed modifications to that if needed. Regards ! [0]: https://sourceforge.net/tracker/index.php?func=detail&aid=2998185&group_id=2... [1]: https://sourceforge.net/tracker/?func=detail&aid=3507111&group_id=23067&atid... -- ____________________________________ Chanaka Indrajith Bsc.Computer Engineering Undergraduate Faculty of Engineering University of Peradeniya ____________________________________

On Fri, Mar 30, 2012 at 10:27 AM, Chanaka Dharmarathna < pe.chanaka.ck@gmail.com> wrote:
On Thu, Mar 22, 2012 at 1:25 AM, Chanaka Dharmarathna < pe.chanaka.ck@gmail.com> wrote:
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=23...
> > 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=2... [2] https://sourceforge.net/tracker/?func=detail&aid=3507111&group_id=23067&atid...
-- ____________________________________
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=2... [2] https://sourceforge.net/tracker/?func=detail&aid=3507111&group_id=23067&atid...
Regards !
-- ____________________________________
Chanaka Indrajith Bsc.Computer Engineering Undergraduate Faculty of Engineering University of Peradeniya ____________________________________
Hi,
Including the suggestions of Marc, I improved the patch for feature request [0] , and attached at [1]. If anyone can review it, I can do the needed modifications to that if needed.
Regards !
[0]: https://sourceforge.net/tracker/index.php?func=detail&aid=2998185&group_id=2... [1]: https://sourceforge.net/tracker/?func=detail&aid=3507111&group_id=23067&atid...
-- ____________________________________
Chanaka Indrajith Bsc.Computer Engineering Undergraduate Faculty of Engineering University of Peradeniya ____________________________________
Hi Marc, I update my patch [0] , to support latest code base. [0]: https://sourceforge.net/tracker/?func=detail&aid=3507111&group_id=23067&atid... Regards ! -- ____________________________________ Chanaka Indrajith Bsc.Computer Engineering Undergraduate Faculty of Engineering University of Peradeniya ____________________________________
participants (2)
-
Chanaka Dharmarathna
-
Marc Delisle