[Phpmyadmin-devel] Shortcut to add columns from central list to a table

[Marc Delisle]

Smita a écrit :
> On Tue, Jun 3, 2014 at 9:10 PM, Chirayu Chiripal <chirayu.chiripal at gmail.com
>> wrote:
> 
>> Hi,
>>
>>
>>
>> On Tue, Jun 3, 2014 at 7:37 PM, Marc Delisle <marc at 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)