How to make record for array inside a CDT ?

Question

Dears, 
 
 I have a CDT which contains array of another CDT which also contains another CDT (3 levels) 
 So I have "Applicant" which contains list of "AppliedJobs" in which each element in "AppliedJobs" contains reference to two CDTs "Employer" & "JobPost"

And I want to make a record to display all "AppliedJobs" for a given applicant ID. 
 But unfortunately, I cannot find a way in records to select array field inside the "Applicant", so any ideas how to make it ???

ekanshj · Answer

Hi mahmoudd0001 You need to see if the data type is same of the field and the record field, if both are same you can define using like this.

Dude · Answer

If the field type and component type matches. That filed can be mapped and the value will appear. As per the best practices nested cdt must be avoided if it exceeding more than one level. Try to use different tables and make use of the database view concept.

Mike Schmitt · Answer

In general I think the best implementation for this use case would be to have the Applied Jobs be listed on the Record Dashboard for an individual Applicant, since presumably the list of Applied Jobs could get rather long for certain individuals.