How to use predefined sql in Synceditor scripts

Can you be a little bit more specific, please? You may want to take a look at this post here, to get some ideas what might be helpful to help other answer your question.

Standards when posting a question - Forum - Identity Manager Community - One Identity Community

Hi Markus,

Apologies for insufficient information and Thanks for picking this up.

version 9.0 LTS

context.

I created a virtual scripted attribute on one Im side 

value inside virtual attribute should be basically a result of predefined sql.

predefined sql takes uid_unsaccountb as input parameter.

regards,

Pradeep Pola.

Why do you need a pre-defined SQL statement in your mapping?

You need to understand, that the scripts only have access to the "synchronization objects" and not to the normal iEntity tape of objects provided by the object layer in scripts stored in DialogScripts.

Please provide more details about your use case. Maybe some member can help you out then.

Why do you need a pre-defined SQL statement in your mapping?

You need to understand, that the scripts only have access to the "synchronization objects" and not to the normal iEntity tape of objects provided by the object layer in scripts stored in DialogScripts.

Please provide more details about your use case. Maybe some member can help you out then.

Thanks for the update I was able to achieve the requirement  by updating unaccountb template in designer.

Regards,

Pradeep Pola