updating an attribute based on another SAP IDM

[pbadalinc]

Hi IDM ers

i have a custom text boolean(Presentation) attribute ZMX_CONTRACTOR whose value depends on if MX_FS_WORK_CONTRACT_ID is populated or not.

if populated value = 1 if empty value=0

I use it in the search user form as a checkbox for contractor search.

what would be best way to implement?

i tried below sql for attribute values >sql query . it doesnot update in IDM. the syntax is Oracle specific:

select count(*) from dual where exists (select * from idmv_VALlINK_EXT2 where MCATTRNAME = 'MXFS_WORK_CONTRACT_ID' )

any help would be appreciated

[pbadalinc]

I went ahead and created a job for inserting record for ZMX_contractor . need help with fine tuning job especially the deletion of the record when attribute MX_FS_WORK_CONTRACT_ID is reset to blank

should i use distinct?

should i use a different view? the insert part worked good

job type: To IdentityStore

pass: setContractorflag

source:

select A.MSKEY , A.AttrName, A.aValue from IDM_OPER.IDMV_VALUE_BASIC A where A.ATTRNAME= 'MX_FS_WORK_CONTRACT_ID' and not exists(select 1 from IDM_OPER.IDMV_VALUE_BASIC B where A.mskey = B.mskey and B.ATTRNAME = 'ZMX_CONTRACTOR' )

Destination:

MSKEYVALUE : %MSKEYVALUE%

ZMX_CONTRACTOR: 1 or %ZMX_CONTRACTOR%

Changetype : insert

pass: resetContractorflag( to delete the record when attribute MX_FS_WORK_CONTRACT_ID is reset to blank)

source:

select distinct A.MSKEY , A.AttrName, A.aValue from IDM_OPER.IDMV_VALUE_BASIC A where A.ATTRNAME='ZMX_CONTRACTOR' and not exists(select 1 from IDM_OPER.IDMV_VALUE_BASIC B where A.mskey = B.mskey and B.ATTRNAME = 'MX_FS_WORK_CONTRACT_ID' )

Destination:

MSKEYVALUE : %MSKEYVALUE%

ZMX_CONTRACTOR: %ZMX_CONTRACTOR%

Changetype : delete

any input appreciated!!

Prasad