Page 1 of 1
Group by: no alias name when selected
Posted: Wed 04 Mar 2015 15:57
by grzezoch
Hello!
I use dbForge Studio for MySQL 6.2.280.
1.
I would like, a selected items in "group by" tab may shows not as number value but as alias. Now, it's no intuitive for me.
2.
"Expression" editbox in "group by" tab have not GUI for edit expressions. Typing manually is not comfortable.
Best regards.
--
Grzegorz Żochowski
Re: Group by: no alias name when selected
Posted: Wed 04 Mar 2015 17:06
by alexa
1.
I would like, a selected items in "group by" tab may shows not as number value but as alias. Now, it's no intuitive for me.
Could you please provide us an example of such a query?
2.
"Expression" editbox in "group by" tab have not GUI for edit expressions. Typing manually is not comfortable.
Unfortunately, implementing such a feature may cause some subsequent problems, so we left it on a user's responsibility to manually type this field.
Also, we noticed that you were using an obsolete product version. We recommend you to upgrade it to the latest version 6.3
http://www.devart.com/dbforge/mysql/stu ... nload.html
Re: Group by: no alias name when selected
Posted: Wed 04 Mar 2015 21:15
by grzezoch
alexa wrote:1.
I would like, a selected items in "group by" tab may shows not as number value but as alias. Now, it's no intuitive for me.
Could you please provide us an example of such a query?
It's a sample (more intuitive will be using 'month_abc' and 'year_abc' aliases, instead '1' and '2'):
Code: Select all
SELECT
MONTH(ps_order_history.date_add) AS month_abc,
YEAR(ps_order_history.date_add) AS year_abc
FROM ps_order_history
GROUP BY 2,
1;
Re: Group by: no alias name when selected
Posted: Thu 05 Mar 2015 12:15
by alexa
It's a sample (more intuitive will be using 'month_abc' and 'year_abc' aliases, instead '1' and '2'):
Thank you for the reply.
We will review this suggestion when developing future product versions.