Ammar, it works well so far!
Suggestions:
- As the default data label, use the display field if it exists (from libraries/relation.lib.php, PMA_getDisplayField() )
- For the title, instead of "Scatter Plot", give some indications (how to zoom, how to click, etc) or give a link to get such indications
- Is it possible to enlarge the size of the working zone? ideally, to drag it by one of its corners?
- You seem to prefetch the whole table and I'm concerned about response time and memory issues for big tables (try it with the payment table and no data restriction). When hovering over a dot, maybe fetch the rows one by one with Ajax? Or use Ajax if there are more than a certain number of rows.
- Clicking on a point shows the whole row; is it possible to show a pencil icon which would permit to bring another panel to edit the row?
- Still thinking about a panning mechanism?
- Any possibility of this feature for multi-tables?
On Fri, Jun 17, 2011 at 11:49 AM, Marc Delisle marc@infomarc.info wrote:
Ammar, it works well so far!
Suggestions:
- As the default data label, use the display field if it exists (from
libraries/relation.lib.php, PMA_getDisplayField() )
- For the title, instead of "Scatter Plot", give some indications (how
to zoom, how to click, etc) or give a link to get such indications
- Is it possible to enlarge the size of the working zone? ideally, to
drag it by one of its corners?
:) I'll try and look into it.
- You seem to prefetch the whole table and I'm concerned about response
time and memory issues for big tables (try it with the payment table and no data restriction). When hovering over a dot, maybe fetch the rows one by one with Ajax? Or use Ajax if there are more than a certain number of rows.
I was also very much concerned about this. This happens even with the 'Display chart' functionality in the browse tab. I pre-fetch the table for making the initial plot and store the data row for each point. One solution can be like: Now I'm generating query like 'Select * from table' which I'll change to 'Select x,y from table' and then when hovering or clicking over the plot, I'll fetch the data row.
- Clicking on a point shows the whole row; is it possible to show a
pencil icon which would permit to bring another panel to edit the row?
Still thinking about a panning mechanism?
Any possibility of this feature for multi-tables?
-- Marc Delisle http://infomarc.info
EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Le 2011-06-17 18:16, Ammar Yasir a écrit :
On Fri, Jun 17, 2011 at 11:49 AM, Marc Delisle marc@infomarc.info wrote:
Ammar, it works well so far!
Suggestions:
- As the default data label, use the display field if it exists (from
libraries/relation.lib.php, PMA_getDisplayField() )
- For the title, instead of "Scatter Plot", give some indications (how
to zoom, how to click, etc) or give a link to get such indications
- Is it possible to enlarge the size of the working zone? ideally, to
drag it by one of its corners?
:) I'll try and look into it.
- You seem to prefetch the whole table and I'm concerned about response
time and memory issues for big tables (try it with the payment table and no data restriction). When hovering over a dot, maybe fetch the rows one by one with Ajax? Or use Ajax if there are more than a certain number of rows.
I was also very much concerned about this. This happens even with the 'Display chart' functionality in the browse tab. I pre-fetch the table for making the initial plot and store the data row for each point. One solution can be like: Now I'm generating query like 'Select * from table' which I'll change to 'Select x,y from table' and then when hovering or clicking over the plot, I'll fetch the data row.
Your solution of fetching just the needed columns will help, but we'll need another safeguard for big tables. I'm thinking of a configurable maximum of rows to fetch. Think of it, showing millions (or even thousands) of dots won't make any sense.
- Clicking on a point shows the whole row; is it possible to show a
pencil icon which would permit to bring another panel to edit the row?
Still thinking about a panning mechanism?
Any possibility of this feature for multi-tables?
On Sat, Jun 18, 2011 at 4:42 PM, Marc Delisle marc@infomarc.info wrote:
Le 2011-06-17 18:16, Ammar Yasir a écrit :
On Fri, Jun 17, 2011 at 11:49 AM, Marc Delisle marc@infomarc.info
wrote:
Ammar, it works well so far!
Suggestions:
- As the default data label, use the display field if it exists (from
libraries/relation.lib.php, PMA_getDisplayField() )
- For the title, instead of "Scatter Plot", give some indications (how
to zoom, how to click, etc) or give a link to get such indications
- Is it possible to enlarge the size of the working zone? ideally, to
drag it by one of its corners?
I used the jquery-ui plugin and implemented this.
:) I'll try and look into it.
- You seem to prefetch the whole table and I'm concerned about response
time and memory issues for big tables (try it with the payment table and no data restriction). When hovering over a dot, maybe fetch the rows one by one with Ajax? Or use Ajax if there are more than a certain number of rows.
I was also very much concerned about this. This happens even with the 'Display chart' functionality in the browse tab. I pre-fetch the table
for
making the initial plot and store the data row for each point. One
solution
can be like: Now I'm generating query like 'Select * from table' which
I'll
change to 'Select x,y from table' and then when hovering or clicking over the plot, I'll fetch the data row.
Your solution of fetching just the needed columns will help, but we'll need another safeguard for big tables. I'm thinking of a configurable maximum of rows to fetch. Think of it, showing millions (or even thousands) of dots won't make any sense.
So like in table browse mode we can generate the plot for 500/250 rows.
Then if user wants we can replot with the next 500/250. Although I agree it will only complicate the plot and its hard to make sense from the plot. Or we can also ask the limit as input but I think the user might find it annoying or unnecessary.
- Clicking on a point shows the whole row; is it possible to show a
pencil icon which would permit to bring another panel to edit the row?
Still thinking about a panning mechanism?
Any possibility of this feature for multi-tables?
-- Marc Delisle http://infomarc.info
EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
On Sun, Jun 19, 2011 at 8:58 PM, Ammar Yasir ammaryasir.88@gmail.com wrote:
On Sat, Jun 18, 2011 at 4:42 PM, Marc Delisle marc@infomarc.info wrote:
Le 2011-06-17 18:16, Ammar Yasir a écrit :
On Fri, Jun 17, 2011 at 11:49 AM, Marc Delisle marc@infomarc.info wrote:
Ammar, it works well so far!
Suggestions:
- As the default data label, use the display field if it exists (from
libraries/relation.lib.php, PMA_getDisplayField() )
- For the title, instead of "Scatter Plot", give some indications (how
to zoom, how to click, etc) or give a link to get such indications
- Is it possible to enlarge the size of the working zone? ideally, to
drag it by one of its corners?
I used the jquery-ui plugin and implemented this.
:) I'll try and look into it.
- You seem to prefetch the whole table and I'm concerned about response
time and memory issues for big tables (try it with the payment table and no data restriction). When hovering over a dot, maybe fetch the rows one by one with Ajax? Or use Ajax if there are more than a certain number of rows.
I was also very much concerned about this. This happens even with the 'Display chart' functionality in the browse tab. I pre-fetch the table for making the initial plot and store the data row for each point. One solution can be like: Now I'm generating query like 'Select * from table' which I'll change to 'Select x,y from table' and then when hovering or clicking over the plot, I'll fetch the data row.
Your solution of fetching just the needed columns will help, but we'll need another safeguard for big tables. I'm thinking of a configurable maximum of rows to fetch. Think of it, showing millions (or even thousands) of dots won't make any sense.
So like in table browse mode we can generate the plot for 500/250 rows. Then if user wants we can replot with the next 500/250. Although I agree it will only complicate the plot and its hard to make sense from the plot. Or we can also ask the limit as input but I think the user might find it annoying or unnecessary.
for the 'Display chart' feature I thought of using a zoom feature like this: http://www.highcharts.com/demo/dynamic-master-detail
What if we make 2 sql queries to find out the min and max value of the 'x-axis', then select like 100-200 values that are equally distributed over the x-axis and display those?
Hope that was understandable.
- Clicking on a point shows the whole row; is it possible to show a
pencil icon which would permit to bring another panel to edit the row?
Still thinking about a panning mechanism?
Any possibility of this feature for multi-tables?
-- Marc Delisle http://infomarc.info
EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
On Mon, Jun 20, 2011 at 12:36 AM, Tyron Madlener tyronx@gmail.com wrote:
On Sun, Jun 19, 2011 at 8:58 PM, Ammar Yasir ammaryasir.88@gmail.com wrote:
On Sat, Jun 18, 2011 at 4:42 PM, Marc Delisle marc@infomarc.info
wrote:
Le 2011-06-17 18:16, Ammar Yasir a écrit :
On Fri, Jun 17, 2011 at 11:49 AM, Marc Delisle marc@infomarc.info wrote:
Ammar, it works well so far!
Suggestions:
- As the default data label, use the display field if it exists (from
libraries/relation.lib.php, PMA_getDisplayField() )
- For the title, instead of "Scatter Plot", give some indications
(how
to zoom, how to click, etc) or give a link to get such indications
- Is it possible to enlarge the size of the working zone? ideally, to
drag it by one of its corners?
I used the jquery-ui plugin and implemented this.
:) I'll try and look into it.
- You seem to prefetch the whole table and I'm concerned about
response
time and memory issues for big tables (try it with the payment table and no data restriction). When hovering over a dot, maybe fetch the rows one by one with Ajax? Or use Ajax if there are more than a certain number of rows.
I was also very much concerned about this. This happens even with the 'Display chart' functionality in the browse tab. I pre-fetch the table for making the initial plot and store the data row for each point. One solution can be like: Now I'm generating query like 'Select * from table' which I'll change to 'Select x,y from table' and then when hovering or clicking over the plot, I'll fetch the data row.
Your solution of fetching just the needed columns will help, but we'll need another safeguard for big tables. I'm thinking of a configurable maximum of rows to fetch. Think of it, showing millions (or even thousands) of dots won't make any sense.
So like in table browse mode we can generate the plot for 500/250 rows.
Then
if user wants we can replot with the next 500/250. Although I agree it
will
only complicate the plot and its hard to make sense from the plot. Or we can also ask the limit as input but I think the user might find it annoying or unnecessary.
for the 'Display chart' feature I thought of using a zoom feature like this: http://www.highcharts.com/demo/dynamic-master-detail
What if we make 2 sql queries to find out the min and max value of the
'x-axis', then select like 100-200 values that are equally distributed over the x-axis and display those?
Hope that was understandable.
Sampling is okay but only if we use a good sampling technique. There might be the case where we miss what the user is looking for. In partitioning we wont miss but might complicate matters.
- Clicking on a point shows the whole row; is it possible to show a
pencil icon which would permit to bring another panel to edit the
row?
Still thinking about a panning mechanism?
Any possibility of this feature for multi-tables?
-- Marc Delisle http://infomarc.info
EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Ammar Yasir a écrit :
On Sat, Jun 18, 2011 at 4:42 PM, Marc Delisle <marc@infomarc.info mailto:marc@infomarc.info> wrote:
Le 2011-06-17 18:16, Ammar Yasir a écrit : > On Fri, Jun 17, 2011 at 11:49 AM, Marc Delisle <marc@infomarc.info <mailto:marc@infomarc.info>> wrote: > >> Ammar, >> it works well so far! >> >> Suggestions: >> >> - As the default data label, use the display field if it exists (from >> libraries/relation.lib.php, PMA_getDisplayField() ) >> >> - For the title, instead of "Scatter Plot", give some indications (how >> to zoom, how to click, etc) or give a link to get such indications >> >> - Is it possible to enlarge the size of the working zone? ideally, to >> drag it by one of its corners? >>I used the jquery-ui plugin and implemented this.
Ammar, please push your repo.
> > :) I'll try and look into it. > > >> - You seem to prefetch the whole table and I'm concerned about response >> time and memory issues for big tables (try it with the payment table and >> no data restriction). When hovering over a dot, maybe fetch the rows one >> by one with Ajax? Or use Ajax if there are more than a certain number of >> rows. >> > > I was also very much concerned about this. This happens even with the > 'Display chart' functionality in the browse tab. I pre-fetch the table for > making the initial plot and store the data row for each point. One solution > can be like: Now I'm generating query like 'Select * from table' which I'll > change to 'Select x,y from table' and then when hovering or clicking over > the plot, I'll fetch the data row. Your solution of fetching just the needed columns will help, but we'll need another safeguard for big tables. I'm thinking of a configurable maximum of rows to fetch. Think of it, showing millions (or even thousands) of dots won't make any sense.So like in table browse mode we can generate the plot for 500/250 rows. Then if user wants we can replot with the next 500/250. Although I agree it will only complicate the plot and its hard to make sense from the plot. Or we can also ask the limit as input but I think the user might find it annoying or unnecessary.
On Mon, Jun 20, 2011 at 5:43 PM, Marc Delisle marc@infomarc.info wrote:
Ammar Yasir a écrit :
On Sat, Jun 18, 2011 at 4:42 PM, Marc Delisle <marc@infomarc.info mailto:marc@infomarc.info> wrote:
Le 2011-06-17 18:16, Ammar Yasir a écrit : > On Fri, Jun 17, 2011 at 11:49 AM, Marc Delisle <marc@infomarc.info <mailto:marc@infomarc.info>> wrote: > >> Ammar, >> it works well so far! >> >> Suggestions: >> >> - As the default data label, use the display field if it exists (from >> libraries/relation.lib.php, PMA_getDisplayField() ) >> >> - For the title, instead of "Scatter Plot", give some indications (how >> to zoom, how to click, etc) or give a link to get suchindications
>> >> - Is it possible to enlarge the size of the working zone? ideally, to >> drag it by one of its corners? >>I used the jquery-ui plugin and implemented this.
Ammar, please push your repo.
I made some changes and pushed my work.
- Put a limit on the number of rows retrieved (500). - Added two additional search criteria. - A link that provides some help regarding how to use. - The working area can be dragged by the bottom right corner to enlarge it. - Default label is taken from PMA_getDisplayField().
For the panning feature, I went through the forums at highcharts and they might be coming up with it by the end of this month (beta release) or next month ( http://highcharts.uservoice.com/forums/55896-general/suggestions/724254-scro... )
Regards, Ammar Yasir
> > :) I'll try and look into it. > > >> - You seem to prefetch the whole table and I'm concerned about response >> time and memory issues for big tables (try it with the payment table and >> no data restriction). When hovering over a dot, maybe fetch the rows one >> by one with Ajax? Or use Ajax if there are more than a certain number of >> rows. >> > > I was also very much concerned about this. This happens even withthe
> 'Display chart' functionality in the browse tab. I pre-fetch the table for > making the initial plot and store the data row for each point. One solution > can be like: Now I'm generating query like 'Select * from table' which I'll > change to 'Select x,y from table' and then when hovering or clicking over > the plot, I'll fetch the data row. Your solution of fetching just the needed columns will help, butwe'll
need another safeguard for big tables. I'm thinking of a configurable maximum of rows to fetch. Think of it, showing millions (or even thousands) of dots won't make any sense.So like in table browse mode we can generate the plot for 500/250 rows. Then if user wants we can replot with the next 500/250. Although I agree it will only complicate the plot and its hard to make sense from the
plot.
Or we can also ask the limit as input but I think the user might find it annoying or unnecessary.
-- Marc Delisle http://infomarc.info
EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Ammar Yasir a écrit :
On Mon, Jun 20, 2011 at 5:43 PM, Marc Delisle <marc@infomarc.info mailto:marc@infomarc.info> wrote:
Ammar Yasir a écrit : > > > On Sat, Jun 18, 2011 at 4:42 PM, Marc Delisle <marc@infomarc.info <mailto:marc@infomarc.info> > <mailto:marc@infomarc.info <mailto:marc@infomarc.info>>> wrote: > > Le 2011-06-17 18:16, Ammar Yasir a écrit : > > On Fri, Jun 17, 2011 at 11:49 AM, Marc Delisle > <marc@infomarc.info <mailto:marc@infomarc.info> <mailto:marc@infomarc.info <mailto:marc@infomarc.info>>> wrote: > > > >> Ammar, > >> it works well so far! > >> > >> Suggestions: > >> > >> - As the default data label, use the display field if it exists > (from > >> libraries/relation.lib.php, PMA_getDisplayField() ) > >> > >> - For the title, instead of "Scatter Plot", give some > indications (how > >> to zoom, how to click, etc) or give a link to get such indications > >> > >> - Is it possible to enlarge the size of the working zone? > ideally, to > >> drag it by one of its corners? > >> > > I used the jquery-ui plugin and implemented this. Ammar, please push your repo.I made some changes and pushed my work.
- Put a limit on the number of rows retrieved (500).
This should not be hardcoded; please create a new configuration directive.
- Added two additional search criteria.
OK.
- A link that provides some help regarding how to use.
Please put the new message in js/messages.php. I'm not sure about the line feeds, however.
- The working area can be dragged by the bottom right corner to
enlarge it.
OK.
- Default label is taken from PMA_getDisplayField().
I tested and it does not work for me (I have defined a display field for the film table and it does not show up as a default label).
For the panning feature, I went through the forums at highcharts and they might be coming up with it by the end of this month (beta release) or next month (http://highcharts.uservoice.com/forums/55896-general/suggestions/724254-scro...)
OK.
Regards, Ammar Yasir
On Tue, Jun 21, 2011 at 6:06 PM, Marc Delisle marc@infomarc.info wrote:
Ammar Yasir a écrit :
On Mon, Jun 20, 2011 at 5:43 PM, Marc Delisle <marc@infomarc.info mailto:marc@infomarc.info> wrote:
Ammar Yasir a écrit : > > > On Sat, Jun 18, 2011 at 4:42 PM, Marc Delisle <marc@infomarc.info <mailto:marc@infomarc.info> > <mailto:marc@infomarc.info <mailto:marc@infomarc.info>>> wrote: > > Le 2011-06-17 18:16, Ammar Yasir a écrit : > > On Fri, Jun 17, 2011 at 11:49 AM, Marc Delisle > <marc@infomarc.info <mailto:marc@infomarc.info> <mailto:marc@infomarc.info <mailto:marc@infomarc.info>>> wrote: > > > >> Ammar, > >> it works well so far! > >> > >> Suggestions: > >> > >> - As the default data label, use the display field if it exists > (from > >> libraries/relation.lib.php, PMA_getDisplayField() ) > >> > >> - For the title, instead of "Scatter Plot", give some > indications (how > >> to zoom, how to click, etc) or give a link to get such indications > >> > >> - Is it possible to enlarge the size of the working zone? > ideally, to > >> drag it by one of its corners? > >> > > I used the jquery-ui plugin and implemented this. Ammar, please push your repo.
Hi,
I was implementing the edit functionality for a data point. What I have done is that user selects the mode(browse / edit), mouse cursor changes accordingly to indicate what mode is on and in browse mode onClick, for now I just prompt/alert the data row. For the edit mode, I create a popup using jquery, where each field will be displayed just like the tbl_search page ( minus the field type, collation, operator elements) and the value field I will update from the clicked data row. Should I go through with this (creating a popup like tbl_search page) ? I've organized the tbl_search code into libraries so code wont be duplicated much.
I made some changes and pushed my work.
- Put a limit on the number of rows retrieved (500).
This should not be hardcoded; please create a new configuration directive.
Is it fine to put it in the config.default.php file? It says 'do not edit'
so just confirming.
- Added two additional search criteria.
OK.
- A link that provides some help regarding how to use.
Please put the new message in js/messages.php. I'm not sure about the line feeds, however.
- The working area can be dragged by the bottom right corner to
enlarge it.
OK.
- Default label is taken from PMA_getDisplayField().
I tested and it does not work for me (I have defined a display field for the film table and it does not show up as a default label).
For the panning feature, I went through the forums at highcharts and they might be coming up with it by the end of this month (beta release) or next month (
http://highcharts.uservoice.com/forums/55896-general/suggestions/724254-scro... )
OK.
Regards, Ammar Yasir
-- Marc Delisle http://infomarc.info
EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
On Sat, Jun 25, 2011 at 9:01 PM, Ammar Yasir ammaryasir.88@gmail.comwrote:
On Tue, Jun 21, 2011 at 6:06 PM, Marc Delisle marc@infomarc.info wrote:
Ammar Yasir a écrit :
On Mon, Jun 20, 2011 at 5:43 PM, Marc Delisle <marc@infomarc.info mailto:marc@infomarc.info> wrote:
Ammar Yasir a écrit : > > > On Sat, Jun 18, 2011 at 4:42 PM, Marc Delisle <marc@infomarc.info
<mailto:marc@infomarc.info> > <mailto:marc@infomarc.info <mailto:marc@infomarc.info>>> wrote: > > Le 2011-06-17 18:16, Ammar Yasir a écrit : > > On Fri, Jun 17, 2011 at 11:49 AM, Marc Delisle > <marc@infomarc.info <mailto:marc@infomarc.info> <mailto:marc@infomarc.info <mailto:marc@infomarc.info>>> wrote: > > > >> Ammar, > >> it works well so far! > >> > >> Suggestions: > >> > >> - As the default data label, use the display field if it exists > (from > >> libraries/relation.lib.php, PMA_getDisplayField() ) > >> > >> - For the title, instead of "Scatter Plot", give some > indications (how > >> to zoom, how to click, etc) or give a link to get such indications > >> > >> - Is it possible to enlarge the size of the working zone? > ideally, to > >> drag it by one of its corners? > >> > > I used the jquery-ui plugin and implemented this. Ammar, please push your repo.Hi,
I was implementing the edit functionality for a data point. What I have done is that user selects the mode(browse / edit), mouse cursor changes accordingly to indicate what mode is on and in browse mode onClick, for now I just prompt/alert the data row. For the edit mode, I create a popup using jquery, where each field will be displayed just like the tbl_search page ( minus the field type, collation, operator elements) and the value field I will update from the clicked data row. Should I go through with this (creating a popup like tbl_search page) ? I've organized the tbl_search code into libraries so code wont be duplicated much.
I made some changes and pushed my work.
- Put a limit on the number of rows retrieved (500).
This should not be hardcoded; please create a new configuration directive.
Is it fine to put it in the config.default.php file? It says 'do not edit'
so just confirming.
'Do not edit' there is meant for the end users, not for the developers.
End users are expected to change config.inc.php for the configurations.
Le 2011-06-25 11:31, Ammar Yasir a écrit :
On Tue, Jun 21, 2011 at 6:06 PM, Marc Delisle <marc@infomarc.info mailto:marc@infomarc.info> wrote:
Ammar Yasir a écrit : > > > On Mon, Jun 20, 2011 at 5:43 PM, Marc Delisle <marc@infomarc.info <mailto:marc@infomarc.info> > <mailto:marc@infomarc.info <mailto:marc@infomarc.info>>> wrote: > > Ammar Yasir a écrit : > > > > > > On Sat, Jun 18, 2011 at 4:42 PM, Marc Delisle <marc@infomarc.info <mailto:marc@infomarc.info> > <mailto:marc@infomarc.info <mailto:marc@infomarc.info>> > > <mailto:marc@infomarc.info <mailto:marc@infomarc.info> <mailto:marc@infomarc.info <mailto:marc@infomarc.info>>>> wrote: > > > > Le 2011-06-17 18:16, Ammar Yasir a écrit : > > > On Fri, Jun 17, 2011 at 11:49 AM, Marc Delisle > > <marc@infomarc.info <mailto:marc@infomarc.info> <mailto:marc@infomarc.info <mailto:marc@infomarc.info>> > <mailto:marc@infomarc.info <mailto:marc@infomarc.info> <mailto:marc@infomarc.info <mailto:marc@infomarc.info>>>> wrote: > > > > > >> Ammar, > > >> it works well so far! > > >> > > >> Suggestions: > > >> > > >> - As the default data label, use the display field if it > exists > > (from > > >> libraries/relation.lib.php, PMA_getDisplayField() ) > > >> > > >> - For the title, instead of "Scatter Plot", give some > > indications (how > > >> to zoom, how to click, etc) or give a link to get such > indications > > >> > > >> - Is it possible to enlarge the size of the working zone? > > ideally, to > > >> drag it by one of its corners? > > >> > > > > I used the jquery-ui plugin and implemented this. > > Ammar, > please push your repo. >Hi,
I was implementing the edit functionality for a data point. What I have done is that user selects the mode(browse / edit), mouse cursor changes accordingly to indicate what mode is on and in browse mode onClick, for now I just prompt/alert the data row. For the edit mode, I create a popup using jquery, where each field will be displayed just like the tbl_search page ( minus the field type, collation, operator elements) and the value field I will update from the clicked data row. Should I go through with this (creating a popup like tbl_search page) ? I've organized the tbl_search code into libraries so code wont be duplicated much.
Sounds good but why the need to select a mode? If always in edit mode, I can see the data and I edit if needed. Maybe it will become clearer when I see the implementation.
Also, there should be similarities between this kind of edit and what happens with a "normal" edit in table Browse. Similarities or better, the same interface (code sharing).
> I made some changes and pushed my work. > - Put a limit on the number of rows retrieved (500). This should not be hardcoded; please create a new configuration directive.Is it fine to put it in the config.default.php file? It says 'do not edit' so just confirming.
> - Added two additional search criteria. OK. > - A link that provides some help regarding how to use. Please put the new message in js/messages.php. I'm not sure about the line feeds, however. > - The working area can be dragged by the bottom right corner to > enlarge it. OK. > - Default label is taken from PMA_getDisplayField(). I tested and it does not work for me (I have defined a display field for the film table and it does not show up as a default label). > > For the panning feature, I went through the forums at highcharts and > they might be coming up with it by the end of this month (beta release) > or next month > (http://highcharts.uservoice.com/forums/55896-general/suggestions/724254-scrolling-charts) OK. > > Regards, > Ammar Yasir
Just found a code snippet that allows pan and zoom for highcharts - maybe something for Zoom Search?
On Sat, Jun 25, 2011 at 6:12 PM, Marc Delisle marc@infomarc.info wrote:
Le 2011-06-25 11:31, Ammar Yasir a écrit :
On Tue, Jun 21, 2011 at 6:06 PM, Marc Delisle <marc@infomarc.info mailto:marc@infomarc.info> wrote:
Ammar Yasir a écrit : > > > On Mon, Jun 20, 2011 at 5:43 PM, Marc Delisle <marc@infomarc.info mailto:marc@infomarc.info > <mailto:marc@infomarc.info mailto:marc@infomarc.info>> wrote: > > Ammar Yasir a écrit : > > > > > > On Sat, Jun 18, 2011 at 4:42 PM, Marc Delisle <marc@infomarc.info mailto:marc@infomarc.info > <mailto:marc@infomarc.info mailto:marc@infomarc.info> > > <mailto:marc@infomarc.info mailto:marc@infomarc.info <mailto:marc@infomarc.info mailto:marc@infomarc.info>>> wrote: > > > > Le 2011-06-17 18:16, Ammar Yasir a écrit : > > > On Fri, Jun 17, 2011 at 11:49 AM, Marc Delisle > > <marc@infomarc.info mailto:marc@infomarc.info <mailto:marc@infomarc.info mailto:marc@infomarc.info> > <mailto:marc@infomarc.info mailto:marc@infomarc.info <mailto:marc@infomarc.info mailto:marc@infomarc.info>>> wrote: > > > > > >> Ammar, > > >> it works well so far! > > >> > > >> Suggestions: > > >> > > >> - As the default data label, use the display field if it > exists > > (from > > >> libraries/relation.lib.php, PMA_getDisplayField() ) > > >> > > >> - For the title, instead of "Scatter Plot", give some > > indications (how > > >> to zoom, how to click, etc) or give a link to get such > indications > > >> > > >> - Is it possible to enlarge the size of the working zone? > > ideally, to > > >> drag it by one of its corners? > > >> > > > > I used the jquery-ui plugin and implemented this. > > Ammar, > please push your repo. >
Hi,
I was implementing the edit functionality for a data point. What I have done is that user selects the mode(browse / edit), mouse cursor changes accordingly to indicate what mode is on and in browse mode onClick, for now I just prompt/alert the data row. For the edit mode, I create a popup using jquery, where each field will be displayed just like the tbl_search page ( minus the field type, collation, operator elements) and the value field I will update from the clicked data row. Should I go through with this (creating a popup like tbl_search page) ? I've organized the tbl_search code into libraries so code wont be duplicated much.
Sounds good but why the need to select a mode? If always in edit mode, I can see the data and I edit if needed. Maybe it will become clearer when I see the implementation.
Also, there should be similarities between this kind of edit and what happens with a "normal" edit in table Browse. Similarities or better, the same interface (code sharing).
> I made some changes and pushed my work. > - Put a limit on the number of rows retrieved (500).
This should not be hardcoded; please create a new configuration directive.
Is it fine to put it in the config.default.php file? It says 'do not edit' so just confirming.
> - Added two additional search criteria.
OK.
> - A link that provides some help regarding how to use.
Please put the new message in js/messages.php. I'm not sure about the line feeds, however.
> - The working area can be dragged by the bottom right corner to > enlarge it.
OK.
> - Default label is taken from PMA_getDisplayField().
I tested and it does not work for me (I have defined a display field for the film table and it does not show up as a default label).
> > For the panning feature, I went through the forums at highcharts and > they might be coming up with it by the end of this month (beta release) > or next month > (http://highcharts.uservoice.com/forums/55896-general/suggestions/724254-scro...)
OK.
> > Regards, > Ammar Yasir
-- Marc Delisle http://infomarc.info
All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense.. http://p.sf.net/sfu/splunk-d2d-c1 _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
On Tue, Jul 5, 2011 at 3:10 PM, Tyron Madlener tyronx@gmail.com wrote:
Just found a code snippet that allows pan and zoom for highcharts - maybe something for Zoom Search?
I also got a reply from Highcharts support about the highchart-stock
"Hello, We don't have a definite release date but highcharts-stock will be out in beta soon (a week or two). "
On Sat, Jun 25, 2011 at 6:12 PM, Marc Delisle marc@infomarc.info wrote:
Le 2011-06-25 11:31, Ammar Yasir a écrit :
On Tue, Jun 21, 2011 at 6:06 PM, Marc Delisle <marc@infomarc.info mailto:marc@infomarc.info> wrote:
Ammar Yasir a écrit : > > > On Mon, Jun 20, 2011 at 5:43 PM, Marc Delisle <marc@infomarc.info
<mailto:marc@infomarc.info> > <mailto:marc@infomarc.info <mailto:marc@infomarc.info>>> wrote: > > Ammar Yasir a écrit : > > > > > > On Sat, Jun 18, 2011 at 4:42 PM, Marc Delisle <marc@infomarc.info <mailto:marc@infomarc.info> > <mailto:marc@infomarc.info <mailto:marc@infomarc.info>> > > <mailto:marc@infomarc.info <mailto:marc@infomarc.info> <mailto:marc@infomarc.info <mailto:marc@infomarc.info>>>> wrote: > > > > Le 2011-06-17 18:16, Ammar Yasir a écrit : > > > On Fri, Jun 17, 2011 at 11:49 AM, Marc Delisle > > <marc@infomarc.info <mailto:marc@infomarc.info> <mailto:marc@infomarc.info <mailto:marc@infomarc.info>> > <mailto:marc@infomarc.info <mailto:marc@infomarc.info> <mailto:marc@infomarc.info <mailto:marc@infomarc.info>>>> wrote: > > > > > >> Ammar, > > >> it works well so far! > > >> > > >> Suggestions: > > >> > > >> - As the default data label, use the display field if it > exists > > (from > > >> libraries/relation.lib.php, PMA_getDisplayField() ) > > >> > > >> - For the title, instead of "Scatter Plot", give some > > indications (how > > >> to zoom, how to click, etc) or give a link to get such > indications > > >> > > >> - Is it possible to enlarge the size of the working zone? > > ideally, to > > >> drag it by one of its corners? > > >> > > > > I used the jquery-ui plugin and implemented this. > > Ammar, > please push your repo. >Hi,
I was implementing the edit functionality for a data point. What I have done is that user selects the mode(browse / edit), mouse cursor changes accordingly to indicate what mode is on and in browse mode onClick, for now I just prompt/alert the data row. For the edit mode, I create a popup using jquery, where each field will be displayed just like the tbl_search page ( minus the field type, collation, operator elements) and the value field I will update from the clicked data row. Should I go through with this (creating a popup like tbl_search page) ? I've organized the tbl_search code into libraries so code wont be duplicated much.
Sounds good but why the need to select a mode? If always in edit mode, I can see the data and I edit if needed. Maybe it will become clearer when I see the implementation.
Also, there should be similarities between this kind of edit and what happens with a "normal" edit in table Browse. Similarities or better, the same interface (code sharing).
> I made some changes and pushed my work. > - Put a limit on the number of rows retrieved (500). This should not be hardcoded; please create a new configuration directive.Is it fine to put it in the config.default.php file? It says 'do not edit' so just confirming.
> - Added two additional search criteria. OK. > - A link that provides some help regarding how to use. Please put the new message in js/messages.php. I'm not sure aboutthe
line feeds, however. > - The working area can be dragged by the bottom right corner to > enlarge it. OK. > - Default label is taken from PMA_getDisplayField(). I tested and it does not work for me (I have defined a display fieldfor
the film table and it does not show up as a default label). > > For the panning feature, I went through the forums at highchartsand
> they might be coming up with it by the end of this month (beta release) > or next month > (http://highcharts.uservoice.com/forums/55896-general/suggestions/724254-scro... )
OK. > > Regards, > Ammar Yasir-- Marc Delisle http://infomarc.info
All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense.. http://p.sf.net/sfu/splunk-d2d-c1 _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
All of the data generated in your IT infrastructure is seriously valuable. Why? It contains a definitive record of application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-d2d-c2 _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
-
Ammar Yasir -
Madhura Jayaratne -
Marc Delisle -
Tyron Madlener