[Phpmyadmin-devel] Shortcut to add columns from central list to a table
Hi I wanted to have some ideas about where and how should we keep option to add a column from central list while we are adding new columns to any table. I can think of two ways: 1. Add a drop down to select a column from central list. and on select of a column auto populate all the other attributes field. [see 1.png] 2. Make the current "Name" field as dropdown, which will have all the columns from central list as options plus one option that let user to write column name himself. [see 2.png, 3.png] Please suggest what should look good and if have any other ideas. Thanks and Regards - Smita
Smita a écrit :
Hi
I wanted to have some ideas about where and how should we keep option to add a column from central list while we are adding new columns to any table. I can think of two ways: 1. Add a drop down to select a column from central list. and on select of a column auto populate all the other attributes field. [see 1.png]
Hi Smita, I think we can reject #1 because AFAIK there would be no way to type a column name (which is not present in the central list).
2. Make the current "Name" field as dropdown, which will have all the columns from central list as options plus one option that let user to write column name himself. [see 2.png, 3.png]
This would work, but I am concerned about the number of columns in the dropdown if they are numerous. We had a similar problem with the foreign key selection, that's why we added $cfg['ForeignKeyMaxLimit'] = 100; and added a panel to browse the foreign values. Since RFE #1487, this panel is a modal dialog and if you go this way, I would expect a modal dialog as well.
Please suggest what should look good and if have any other ideas.
In the SQL query box, there is a "Columns" panel where you can pick a column and click on "<<"; however I'm not sure about the fate of this panel, you might talk with Edward Cheng about that. If this feature stays or is moved to the new SQL console, we'll have to see about integration with the central list. -- Marc Delisle (phpMyAdmin)
Hi, On Tue, Jun 3, 2014 at 7:37 PM, Marc Delisle <marc@infomarc.info> wrote:
Smita a écrit :
Hi
I wanted to have some ideas about where and how should we keep option to add a column from central list while we are adding new columns to any table. I can think of two ways: 1. Add a drop down to select a column from central list. and on select of a column auto populate all the other attributes field. [see 1.png]
Hi Smita, I think we can reject #1 because AFAIK there would be no way to type a column name (which is not present in the central list).
2. Make the current "Name" field as dropdown, which will have all the columns from central list as options plus one option that let user to
write
column name himself. [see 2.png, 3.png]
This would work, but I am concerned about the number of columns in the dropdown if they are numerous. We had a similar problem with the foreign key selection, that's why we added
$cfg['ForeignKeyMaxLimit'] = 100;
and added a panel to browse the foreign values. Since RFE #1487, this panel is a modal dialog and if you go this way, I would expect a modal dialog as well.
Please suggest what should look good and if have any other ideas.
In the SQL query box, there is a "Columns" panel where you can pick a column and click on "<<"; however I'm not sure about the fate of this panel, you might talk with Edward Cheng about that. If this feature stays or is moved to the new SQL console, we'll have to see about integration with the central list.
-- Marc Delisle (phpMyAdmin)
How about autocomplete feature on input box, as you type column name it can show few top matching columns names very much similar to google instant search? -- Regards, Chirayu Chiripal phpMyAdmin Intern - Google Summer of Code 2014 https://chirayuchiripal.wordpress.com/
On Tue, Jun 3, 2014 at 9:10 PM, Chirayu Chiripal <chirayu.chiripal@gmail.com
wrote:
Hi,
On Tue, Jun 3, 2014 at 7:37 PM, Marc Delisle <marc@infomarc.info> wrote:
Smita a écrit :
Hi
I wanted to have some ideas about where and how should we keep option to add a column from central list while we are adding new columns to any table. I can think of two ways: 1. Add a drop down to select a column from central list. and on select of a column auto populate all the other attributes field. [see 1.png]
Hi Smita, I think we can reject #1 because AFAIK there would be no way to type a column name (which is not present in the central list).
2. Make the current "Name" field as dropdown, which will have all the columns from central list as options plus one option that let user to
write
column name himself. [see 2.png, 3.png]
This would work, but I am concerned about the number of columns in the dropdown if they are numerous. We had a similar problem with the foreign key selection, that's why we added
$cfg['ForeignKeyMaxLimit'] = 100;
and added a panel to browse the foreign values. Since RFE #1487, this panel is a modal dialog and if you go this way, I would expect a modal dialog as well.
Please suggest what should look good and if have any other ideas.
In the SQL query box, there is a "Columns" panel where you can pick a column and click on "<<"; however I'm not sure about the fate of this panel, you might talk with Edward Cheng about that. If this feature stays or is moved to the new SQL console, we'll have to see about integration with the central list.
-- Marc Delisle (phpMyAdmin)
How about autocomplete feature on input box, as you type column name it can show few top matching columns names very much similar to google instant search?
In addition to giving an option to select from central columns, we can also have this autocomplete feature as well. This can help to use central columns even better. But we can't just have autocomplete only, I think we need a direct way to pick from the list instead of picking after start typing. -- Smita
-- Regards, Chirayu Chiripal phpMyAdmin Intern - Google Summer of Code 2014 https://chirayuchiripal.wordpress.com/
------------------------------------------------------------------------------ Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/NeoTech _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Smita a écrit :
On Tue, Jun 3, 2014 at 9:10 PM, Chirayu Chiripal <chirayu.chiripal@gmail.com
wrote:
Hi,
On Tue, Jun 3, 2014 at 7:37 PM, Marc Delisle <marc@infomarc.info> wrote:
Smita a écrit :
Hi
I wanted to have some ideas about where and how should we keep option to add a column from central list while we are adding new columns to any table. I can think of two ways: 1. Add a drop down to select a column from central list. and on select of a column auto populate all the other attributes field. [see 1.png] Hi Smita, I think we can reject #1 because AFAIK there would be no way to type a column name (which is not present in the central list).
2. Make the current "Name" field as dropdown, which will have all the columns from central list as options plus one option that let user to write column name himself. [see 2.png, 3.png] This would work, but I am concerned about the number of columns in the dropdown if they are numerous. We had a similar problem with the foreign key selection, that's why we added
$cfg['ForeignKeyMaxLimit'] = 100;
and added a panel to browse the foreign values. Since RFE #1487, this panel is a modal dialog and if you go this way, I would expect a modal dialog as well.
Please suggest what should look good and if have any other ideas. In the SQL query box, there is a "Columns" panel where you can pick a column and click on "<<"; however I'm not sure about the fate of this panel, you might talk with Edward Cheng about that. If this feature stays or is moved to the new SQL console, we'll have to see about integration with the central list.
-- Marc Delisle (phpMyAdmin)
How about autocomplete feature on input box, as you type column name it can show few top matching columns names very much similar to google instant search?
In addition to giving an option to select from central columns, we can also have this autocomplete feature as well. This can help to use central columns even better. But we can't just have autocomplete only, I think we need a direct way to pick from the list instead of picking after start typing.
I agree with Smita: the user might not even know or remember what's the exact name of the column. -- Marc Delisle (phpMyAdmin)
On Tue, Jun 3, 2014 at 7:37 PM, Marc Delisle <marc@infomarc.info> wrote:
Smita a écrit :
Hi
I wanted to have some ideas about where and how should we keep option to add a column from central list while we are adding new columns to any table. I can think of two ways: 1. Add a drop down to select a column from central list. and on select of a column auto populate all the other attributes field. [see 1.png]
Hi Smita, I think we can reject #1 because AFAIK there would be no way to type a column name (which is not present in the central list).
I didn't mean to have only dropdown for selecting column. User can type himself as well if they wish. choosing from central columns dropdown is optional. If user select from central columns dropdown then all the fields including name will be populated itself and which user can modify if needed. Also if user doesn't select anything from central columns then they can type all the fields himself same as before.
2. Make the current "Name" field as dropdown, which will have all the columns from central list as options plus one option that let user to
write
column name himself. [see 2.png, 3.png]
This would work, but I am concerned about the number of columns in the dropdown if they are numerous. We had a similar problem with the foreign key selection, that's why we added
$cfg['ForeignKeyMaxLimit'] = 100;
and added a panel to browse the foreign values. Since RFE #1487, this panel is a modal dialog and if you go this way, I would expect a modal dialog as well.
Yeah, we can keep model dialogue as well. Did you mean like pic 4.png ? Where on click of "Pick from central columns", a model dialogue to chose a column from the list will open.
Please suggest what should look good and if have any other ideas.
In the SQL query box, there is a "Columns" panel where you can pick a column and click on "<<"; however I'm not sure about the fate of this panel, you might talk with Edward Cheng about that. If this feature stays or is moved to the new SQL console, we'll have to see about integration with the central list.
Yeah, sure.
-- Marc Delisle (phpMyAdmin)
------------------------------------------------------------------------------ Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/NeoTech _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
participants (3)
-
Chirayu Chiripal -
Marc Delisle -
Smita