Group by: no alias name when selected

[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

[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

[grzezoch]

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;

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