Author Topic: Prolaborate - inconsistent report order in the dashboard  (Read 3749 times)

Guillaume

  • EA Practitioner
  • ***
  • Posts: 1076
  • Karma: +34/-2
    • View Profile
    • www.umlchannel.com
Prolaborate - inconsistent report order in the dashboard
« on: May 04, 2021, 12:30:22 am »
Hello,

Using the current 3.4.1.0 release, I created a dashboard with an EA Report widget. This report is using a SQL Query with results ordered by t_object.Name.
The preview on the dashboard doesn't show the classes in the correct order (the order is valid when the report is opened).

Guillaume

Blog: www.umlchannel.com | Free utilities addin: www.eautils.com


Prolaborate Support

  • Prolab Moderator
  • EA User
  • *
  • Posts: 295
  • Karma: +22/-0
    • View Profile
    • Visit us
Re: Prolaborate - inconsistent report order in the dashboard
« Reply #1 on: May 07, 2021, 07:00:00 pm »
Hi Guillaume,

Just to update,  the first column in the data table will come in ascending order by default since this default ordering in the script to order the reports generated using the designer.

Can you please try to apply t_object.Name as first column in query and check?

Guillaume

  • EA Practitioner
  • ***
  • Posts: 1076
  • Karma: +34/-2
    • View Profile
    • www.umlchannel.com
Re: Prolaborate - inconsistent report order in the dashboard
« Reply #2 on: May 07, 2021, 07:08:26 pm »
Hi,

I can confirm that adding starting the query with "Select t_object.Name as hide_name, ..." fixed the issue.
Thank you for your help.

Guillaume

Blog: www.umlchannel.com | Free utilities addin: www.eautils.com