can we sort changedby username ?

0
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
asked
3 answers
1

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.

answered
0

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

Regards,

Ronald

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

answered
0

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

answered