Derived field to concatenate a field based on one-to-many

tphakias

Hello,

I am attempting to create a derived field that builds a concatenated string of essential Job Credentials for a given Job.

In Config Console, I added the following

Job is a BusinessClass

    owned by hr

     Derived Fields

         DFJobCredEssential is a DerivedField

            type is AlphaUpper size 60

            default label is untranslatable:"Essential Job Credentials"

            for each ActiveEssentialCredentialRel.Credential

                DFJobCredEssential += each.Credential

            return DFJobCredEssential

 

When I try to use the field, I get the following error.

For Each rule related link must be an Iteration or end in a set relation: ActiveEsstentialCredentialRel.Credential

 

Any guidance or assistance would be greatly appreciated.

 

Thank you.

unknown

I think your for each statement should be the relation, thus should be "for each ActiveEssentialCredentialRel"