This discussion has been locked.

You can no longer post new replies to this discussion. If you have a question you can start a new discussion

How to create single DB object of the table which has two primary keys

I am trying to create a single DB object of the table "PersonHasQERResource" as I want to update the custom attributes in the table for 1 record. How should I create the DB object in this case? Please help

0 Trevor Pike over 7 years ago

Hi Ruchita,

Are you saying you would like to extend this table to include custom columns? For that you need to use the Schema Extension wizard.

Trevor
Cancel
Up 0 Down

Cancel
0 ruchita.mantri over 7 years ago

No I want to write a vbdcript in which I am trying to instantiate specific DB object which I understand that I can do it using primary key but for "PersonHasQERResource" table, I can see two primary keys.
Cancel
Up 0 Down

Cancel
0 Markus Weiss-Ehlers over 7 years ago

To load an entity from the table PersonHasQERResource directly you can use the following code:

Dim myObjKey As New DbObjectKey("PersonHasQERResource", New String() {"<the UID_Person>", "<the UID_QERResource>"})

Dim myEntity As IEntity = Session.Source.Get(myObjKey)

Did you know that we have a YouTube Channel with many self study video around scripting and One Identity Manager in general? I think it's worth to subscribe to it. https://www.youtube.com/watch?v=UjZdOW8pbM4&list=PL242czeZwlAk0T2AcqpSFtBOXQfkP9f5J
Cancel
Up 0 Down

Cancel