Business Rule is not setting the reference field value

[aagman4]

I am trying to populate the field 'SAD Assessment'(u_sad_assessment) with a value(suppose RASMT00100092) but it's not populating, it remains blank.

This field is of simple reference type on table - sn_risk_advanced_risk_assessment_instance.

Business Rule script - 

SAD Assessment Dictionary Configuration - 

Please help me on this.

[Harish KM · Accepted solution]

Hi, Reference field will look for sysid but here your passing sadAssess.number as a value to set. You need to pass the sysId

[NaveenGN · Accepted solution]

Check the display value of the table and try to use getUniquevalue() instead of sadAssess.number; in setValue

[Jaydee1 · Accepted solution]

Hi @aagman4 ,

Instead of setting number can you try setting sys_id. try following code on line number 9 : 

current.setValue('u_sad_assessment', sadAssess.getUniqueValue());

Please mark helpful and accept solution if it resolves your issue.

Thanks,

Jaydee

[Harish KM · Accepted solution]

Hi, Reference field will look for sysid but here your passing sadAssess.number as a value to set. You need to pass the sysId

[NaveenGN · Accepted solution]

Check the display value of the table and try to use getUniquevalue() instead of sadAssess.number; in setValue

[Jaydee1 · Accepted solution]

Hi @aagman4 ,

Instead of setting number can you try setting sys_id. try following code on line number 9 : 

current.setValue('u_sad_assessment', sadAssess.getUniqueValue());

Please mark helpful and accept solution if it resolves your issue.

Thanks,

Jaydee

[Rahul Talreja · Accepted solution]

Hi @aagman4 ,

Try Using,

current.setValue('u_sad_assessment', sadAssess.getUniqueValue());

current.update();