Horizontal Dashboard has issue with ORDER BY

[MennaKassem]

Which OpenObserve functionalities are the source of the bug?

dashboards

Is this a regression?

Yes

Description

The horizontal dashboard has issue with the order by although it is working well with the vertical dashboard. here the ORDER BY requests DESC , should show as the vertical dashboards shows nymcard then zoho then lago and so on . it works fine with vertical as shown but not working with horizontal.

Please provide a link to a minimal reproduction of the bug

No response

Please provide the exception or error you saw

No response

Please provide the version you discovered this bug in (check about page for version information)

Version: v0.10.5
Commit Hash: 30d06f180da82120f75eb08b702eeb0e10438470
Build Date: 2024-04-30T09:31:56Z

Anything else?

No response

[gaby]

@ktx-abhay I seen this affect the Data Table too. When I use Order By and LIMIT the data changes every time I click "Run Query" when creating a visualization.

[ktx-abhay]

• When the ORDER BY clause is not used with LIMIT, the SQL query will return a random set of 'n' results.
• However, if you specify both ORDER BY and LIMIT, the query will return the top 'n' results based on the ordering specified in the ORDER BY clause.