CA Service Management

We would like to create a Site-Defined Condition Macro that would check if a Change Order's Risk Survey had been completed or not.

We are using r12.6 and the only attribute on the chg that relates to this is the submittedSurvey BREL (which of course is an array that will have 0 or more items)

On a form definition we would code something like if($chg.submittedSurvey,length > 0) ... but we can't put that in an Activity Association so we can reference it in a Site-Defined Condition, can we?

I tried just creating an Activity Association for the attribute submittedSurvey and then in the Condition Macro seeing if it was Empty/NULL or not, but that doesn't seem to have worked.

Any ideas?

Alan, with this schema"

submittedSurvey BREL <- risk_svy.chg_id {chg_id = ?}

"

I don't think you can use it in condition macro.Not sure why you would need a condition for this. Maybe you can consider

modifying the form using $chg.submittedSurvey.length for some chg logic? Thanks _Chi

You could simply check the risk attribute on the Change Order. If there is a value in it then the Risk Survey has been completed.