Populating predefined value in factors during Advanced Risk Assessment

[shanker1]

Hi,

I've a requirement to populate Availability Ratings prepopulated from Business Application table in the factor defined for assessment.

Can any one advise on the script to be used in group or manual factor?

I've created group factors for Confidentiality, Integrity and that are based on user selection. Where as, availability should populate from Business application table. I've configured a reference field in entity and tried using the below code in script in group factor but doesn't seems to work,

score = current.entity_1.u_business_application.u_availability;

Please advise

Regds,

Shanker

[GlideFather]

Olá @shanker1,

please, what are the tables that we are talking about?

can you please specify the scenario?

Is it: field 1 on table A to be pre-populated in a field 2 on table B? or from table A to table A (child-parent)?
(in case there are more fields, the approach will be the same, I simplified the example for a single field scenario)

For either one, check the possibilities that you can get from Relationships [sys_relationship] table.

If not helpful, let me know to discuss this further.

[shanker1 · Accepted solution]

Thanks, I was able to get the solution by using automated script factors querying the table through the entity field and using applies to field in entity.