[Phpmyadmin-devel] GSoG 2011: Reg Zoom-search idea

Marc Delisle marc at infomarc.info
Sun Mar 20 10:32:15 CET 2011

Le 2011-03-19 17:35, Ammar Yasir a écrit :
> On Sun, Mar 20, 2011 at 2:00 AM, Marc Delisle <marc at infomarc.info> wrote:
>> Le 2011-03-19 15:13, Ammar Yasir a écrit :
>>> Sir,
>>> I looked at the table search page. One problem I find is that a form such
>> as
>>> table search page consists of all the columns. I think in general a user
>> is
>>> interested in at most 2-3 criteria for searching at once. If number of
>>> columns are more(in a table eg. users table in mysql database), the
>> search
>>> table form will contain lot of irrelevant fields(to his query). Can the
>> page
>>> be something like it asks the user to select the column first, then its
>>> detail and then again a column if he wants to build the query further?
>> (Please do not top-post, conversations are difficult to follow).
>> I was referring to the Table Search page because we'll have to avoid
>> duplicating the same functionality on many pages.
>> You are right, the table Search page displays all the columns in "query
>> by example" but in its Options hidden panel you can choose the columns
>> that will be displayed. I think that this behavior could be improved by
>> adding a way to quickly hide or show which columns are to receive a
>> search criterion.
>> I think that we can reduce some fields by combining elements from the table
> search page and those from the options hidden pane. The table search form
> provides appropriate operations for each column and in options panel we can
> select columns but it just provides a textbox to enter the body of the WHERE
> clause.
> As in this case we are only interested in selecting one of the columns,
> initially we can just have a list of columns and then when a user clicks on
> one of the columns, the appropriate operations available for that column
> appear. This reduces some of the fields on the screen.

This should work but the user needs to select two columns, not just one.

> Try to avoid a behavior that would be too sequential.
>  and this will not be very sequential also. For example see: Initially ->
> http://web.iiit.ac.in/~yasir/IMG1.jpg , Selecting File_priv ->
> http://web.iiit.ac.in/~yasir/IMG2.jpg

Marc Delisle

More information about the Developers mailing list