On Sun, Mar 20, 2011 at 3:02 PM, Marc Delisle <marc@infomarc.info> wrote:
Le 2011-03-19 17:35, Ammar Yasir a écrit :
> On Sun, Mar 20, 2011 at 2:00 AM, Marc Delisle <marc@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.

We can put a constant on the number of search criteria to 2, so you'll have to select exactly two columns.
 
One more thing, can the two columns be from different tables also. Like for example, for a house auction database:
There is a 'house' table (neighborhood,address,no_of_rooms,plot_size....)   and a sales table (selling_price,date_sold,....)
and the user might want to see a visualization of plot_size vs selling_price.

Do you think I am going off the project idea? This would involve using underlying relationship between the house table and sales table and it would be fairly complex to develop such system.

 
>
> 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
>
Fine.

--
Marc Delisle
http://infomarc.info

------------------------------------------------------------------------------
Colocation vs. Managed Hosting
A question and answer guide to determining the best fit
for your organization - today and in the future.
http://p.sf.net/sfu/internap-sfd2d
_______________________________________________
Phpmyadmin-devel mailing list
Phpmyadmin-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel