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!

[Isabel_Wendt]

Hi Magali! that is a valid question. Please, which version of OnBase are you using in order to see the schema?

[Magali_Thomas]

Hi Magda!

The version is EP3 (20.3.46).

Thanks

[Bill_Schoby]

Take a look at these tables:

rmformatlesstext
rmformattedtext
rmtext

[Magali_Thomas]

Hi Bill,

Thanks I looked at these tables and also at rmfulltextattribute table as well but did not find any items.