Hey all,
How do I query a view that was reverse engineered with the DB tool?
I created a native primary key built into the view by concatenating a long string of column values, but there is no way to tell the tool that the field can be considered a primary key.
When reverse engineered, it creates a composite ID made up of all the columns and I can’t work with the object in an HSQL statement since the Mapped entity has no fields… just an ID field.
Is there a way to do this?