can we sort changedby username ?

I have added changedby name in table .But when I am clicking on sorting from UI. I am getting below message even though I am using MxAdmin user Exception occurred while retrieving data. (SQL State: 42501, Error Code: -5501) Detail Message: org.hsqldb.HsqlException: user lacks privilege or object not found: sub3.system$changedby
3 answers

This error occurs in the following situation:

  • two entity types, A and B
  • B inherites from A
  • owner/changedBy are enabled on supertype A
  • a datagrid shows entity type B
  • you sort on owner/changedBy

Sorting on owner/changedBy works correctly if you show the supertype in the datagrid, but not if you show a type where owner/changedBy is defined on a supertype. Please file a ticket for this problem.


I am not sure, but this could be a constraint of the internal database. Did you try also in postgres?



[EDIT] Sorting on owner or changed by have been given problems. Even in Mx 4.8.9 doing an CSV or Excel export on a grid with these columns can get you in trouble. First I would try to see if the latest Mx4 still gives you these problems. If so file a ticket.


Caused by: org.postgresql.util.PSQLException: ERROR: column sub3.system$changedb y does not exist Position: 626