Workview tables : mkXXX column in rmobjectinstanceXXX table: how to read text content

[Magali_Thomas]

Hi,

I have a text attribute in a workview class and would like to read the value stored in the database (SQL).

In the rmobjectinstance table of this class, I can see that the column for this attibute is not attrXXX but mkXXX.

How can I read the content/value of the attribute? I assume the value in mkXXX is a key to another table but which one? I have searched through the Database Reporting guide and Workview MRG but did not find the answer.

Thanks for your help!

[Mike_Walkuski · Accepted solution]

Hi @Magali Thomas  

mkXXXX refers to the hsi.rmmemo table. Can you check there for these? The value in the mkXXXX column will point to the ID in rmmemo

[Magali_Thomas]

Hi @Mike Walkuski !

Thank you very much! It's exactly the right table and I've been able to find the value with the id mentioned in mkXXXX column.

Kind regards