4
Views
0
Comments
[DBCleaner] Export Table Sizes fails due to missing alias on the SQL Query
dbcleaner
Web icon
Forge asset by Ricardo Silva
Application Type
Traditional Web

Export Table Sizes fails due to missing alias on the SQL Query:

Fails in OutSystems cloud hosted environments because the subquery doesn't have an alias.

I've added one in the image and it then works.

It then attempts to append the totals query result to itself and fails!


It should be this:


Also, it only exports the current page which is useless, whoever created the export copied the page source query and forgot to remove the offset and fetch next restrictions:


Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.