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

Request for custom table template code

Hi All,

I am new to this tool and need a small help.

We have a custom attribute called CCC_GD_GUID in ADSContact table. We are filling this CCC_GD_GUID column from a contact import process. CCC_GD_GUID is a unique attribute.

(e.g. of CCC_GD_GUID 551eae1cf9721ec078e35585e41a36e7)

We need to write the value of CCC_GD_GUID in to the 'Alias' column of EX0MailConatct.The actual requirement is CCC_GD_GUID of ADSContact should present in the EX0MailConatct table as Alias.

I could see we can set a value calculation under below path.

Designer ->Identity manager Schema- > Customized Tables ->EX0Mailcontact-> Alias Column->Column Properties ->Value calculation.

However I am not sure how to write the code. Can I have the sample code for this.

Regards,

Top Replies

Markus Weiss-Ehlers over 5 years ago +2 verified

Hi Subash,

thing is, that there already is a template in place for the column EX0MailContact.Alias that tries to build the alias from the mail property of the assigned ADSContact.

Can you please clarify…

+1 Markus Weiss-Ehlers over 5 years ago

Hi Subash,

thing is, that there already is a template in place for the column EX0MailContact.Alias that tries to build the alias from the mail property of the assigned ADSContact.

Can you please clarify that the alias of the EX0MailContact should always be build based on the CCC_GD_GUID of the assigned ADSContact?

And by the way, what version of OneIM are you using?

As you have shared that you are a newbie, you might want to take a look at our YouTube channel as well. There are several technical tutorials available.

https://www.youtube.com/channel/UCCDrBomtYlPFM1coxYknuuA/playlists?sort=dd&shelf_id=5&view=50
Cancel
Up +2 Down

Cancel
0 subash sukumaran over 5 years ago in reply to Markus Weiss-Ehlers

Hi Markus,

Thanks for the swift reply.

We are using version 8.0.

Yes, EX0MailContact should always be build based on the CCC_GD_GUID of the assigned ADSContact

Regards,
Cancel
Up 0 Down

Cancel
0 Markus Weiss-Ehlers over 5 years ago in reply to subash sukumaran

As I have no plain 8.0 available I cannot give you a fully working template but just the bits and pieces you need to put this in place.

And please remember to test this in your dev. / QA environment, to ensure that you covered all the use cases. The code between the ... is the area of interest, the code change itself is just one line (and another commented out).

    ...

       'Commented the following line
       'myAlias = $FK(UID_ADSContact).Mail$

       ' Use your custom column to fill the alias
       myAlias = $FK(UID_ADSContact).CCC_GD_GUID$

       ...

The following links especially deal with the function and the coding of the value templates.

https://www.youtube.com/watch?v=zl9gEWIG6U4&list=PL242czeZwlAk0T2AcqpSFtBOXQfkP9f5J&index=18

https://www.youtube.com/watch?v=r3Lf7aKKS70&list=PL242czeZwlAk0T2AcqpSFtBOXQfkP9f5J&index=19

If you need more help, feel free to contact our support.
Cancel
Up 0 Down

Cancel

Endpoint Privilege Management

Request for custom table template code

Top Replies