How to get display value of choice fields and reference fields from Sys Audit Table

[AbdulRahim Shai]

Hello Developers,

Hope everyone is doing good!

I need help with scripting to achieve the requirement

We are trying to migrate Sys audit data from one instance to another so the challenge is Sys audit table stores sys_ids for reference fields and choice values for Choice fields.

So now whats happening is when we are migrating to new instances in activity field changes it showing sys_ids , and choice values which is not readable.

Screenshot:

How can I make display values appear in field changes need help in scripting.
Thanks,
AbdulRahim

[Mohan raj]

Hi @AbdulRahim Shai ,

use getDisplayValue() method in transform map script 

if this answer is helpful, please mark it as helpful

[AbdulRahim Shai]

Hello Mohan,

Thanks for taking interest in my query.
  getDisplayValue()  is not enough since multiple tables are involved .
I can query single table and get display value