Find field of USER NAME and STATUS for INSIGHT TABLE.

[Oleksandr Muliar]

HI.

I have Insight tables in my JIRA where I need to find several fields linked to my object.

I have table AO_8542F1_IFJ_OBJ_TYPE_ATTR where I have fields:

ota.OBJECT_TYPE_ID

, ota.REFERENCE_OBJECT_TYPE_ID

, ota.REFERENCE_TYPE_ID

I take field AO_8542F1_IFJ_OBJ_TYPE_ATTR link to table AO_8542F1_IFJ_OBJ_TYPE after I go to table [AO_8542F1_IFJ_OBJ] selecting my [OBJECT_TYPE_ID] from which I get my required object_id.

Assuming my object id = 123456.

In my table AO_8542F1_IFJ_OBJ_TYPE_ATTR column NAME I can see 2 fields:

• ACTIVE ( meaning status)
• Process owner ( eventualy should lead to user name)

Where can I find values of both fields full filled? ?? PLEASE HELP!

I do not have them in table AO_8542F1_IFJ_OBJ_ATTR. As well for field “Process owner” in table AO_8542F1_IFJ_OBJ_TYPE_ATTR can see two fields- ota.REFERENCE_OBJECT_TYPE_ID

And  ota.REFERENCE_TYPE_ID are filled in with integer values, but DB research had led me only to tables with parameterization of objects in another schema.

Thank you very much.

Best regards

Alexander.

[Oleksandr Muliar]

In my case i made a connection via table [AO_8542F1_IFJ_OBJ_ATTR_VAL] field REFERENCED_OBJECT_ID.