Ammar Yasir a écrit :
On Wed, May 18, 2011 at 9:10 PM, Marc Delisle <marc@infomarc.info mailto:marc@infomarc.info> wrote:
Marc Delisle a écrit : > Ammar Yasir a écrit : >> Hi, >> >> My first task is to have an interface for input criteria. We discussed >> earlier to make use of table search page or multi-table query generator >> for this. I was hoping for some comments regarding this. >> >> The aim is to let the user select _*exactly two*_ columns(along with >> some criteria) from a table. I prefer the table search page, it is less >> complicated ( simple form, advanced options ). Also we do not need to >> consider columns from multiple table so table search page will be more >> focused. But the selection also depends on where all we want to put the >> option of "Zoom search" in phpMyAdmin. So should this feature be a >> separate component or should it be available on table search page/ >> multi-table query generator (or both) ? >> >> Regards, >> Ammar Yasir >> http://ammaryasirr.blogspot.com/ > > Hi Ammar, > my answer is based on the assumption that the table Search page is more > known than the multi-table query generator -- it's been my experience so > far, anyway. > > I suggest to add in table Search, Options section a checkbox "Zoom > search"; when checked, another section would reveal itself, containing > particular options for this feature. Or the Zoom search checkbox could be always visible, to better promote it.
Maybe we could put two sub tabs on the table_select page. One will allow for table search and the other for zoom search.
You can try this, we'll see how it feels. Ensure to avoid duplicating code, for example in the list of columns in "query by example".
> > Also, when checked, the "Select columns" section could be changed to > guide the user into selecting exactly two columns. Not sure if the > current "select multiple" control is the best in this case, it's up to > you to propose something suitable. > > However I'm not sure how this would integrate with the multi-table query > generator. > -- Marc Delisle http://infomarc.info