How to make record for array inside a CDT ?

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 ???

  

Parents
  • Thanks for all,

    I had to use a workaround solution by building interface with grids and query Entity as the following:

    a!localVariables(
    local!pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 5),
    local!appliedJobsData: a!queryEntity(
    entity: cons!ApplicantDS,
    query: a!query(
    selection: a!querySelection(columns: {
    a!queryColumn(
    field: "ID"
    ),
    a!queryColumn(
    field: "appliedJobs"
    )
    }),
    pagingInfo: local!pagingInfo,
    filter: a!queryFilter(
    field: "ID",
    operator: "=",
    value: tointeger(user(loggedInUser(),"customField1"))
    )
    ),
    fetchTotalCount: true
    ),
    a!gridField(
    label: "الوظائف التى تم التقديم عليها",
    labelPosition: "ABOVE",
    data: local!appliedJobsData,
    columns: {
    a!gridColumn(
    label: "العنوان",
    value: fv!row.appliedJobs.employer.Address
    ),
    a!gridColumn(
    label: "وصف الوظيفة",
    value: fv!row.appliedJobs.jobPost.JobDescription
    ),
    a!gridColumn(
    label: "الراتب",
    value: fv!row.appliedJobs.jobPost.Salary
    ),
    a!gridColumn(
    label: "الوظيفة",
    value: fv!row.appliedJobs.jobPost.Title
    ),
    a!gridColumn(
    label: "اسم الشركة",
    value: fv!row.appliedJobs.employer.Name
    )
    },
    pagingsaveinto: local!pagingInfo
    )
    )

Reply
  • Thanks for all,

    I had to use a workaround solution by building interface with grids and query Entity as the following:

    a!localVariables(
    local!pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 5),
    local!appliedJobsData: a!queryEntity(
    entity: cons!ApplicantDS,
    query: a!query(
    selection: a!querySelection(columns: {
    a!queryColumn(
    field: "ID"
    ),
    a!queryColumn(
    field: "appliedJobs"
    )
    }),
    pagingInfo: local!pagingInfo,
    filter: a!queryFilter(
    field: "ID",
    operator: "=",
    value: tointeger(user(loggedInUser(),"customField1"))
    )
    ),
    fetchTotalCount: true
    ),
    a!gridField(
    label: "الوظائف التى تم التقديم عليها",
    labelPosition: "ABOVE",
    data: local!appliedJobsData,
    columns: {
    a!gridColumn(
    label: "العنوان",
    value: fv!row.appliedJobs.employer.Address
    ),
    a!gridColumn(
    label: "وصف الوظيفة",
    value: fv!row.appliedJobs.jobPost.JobDescription
    ),
    a!gridColumn(
    label: "الراتب",
    value: fv!row.appliedJobs.jobPost.Salary
    ),
    a!gridColumn(
    label: "الوظيفة",
    value: fv!row.appliedJobs.jobPost.Title
    ),
    a!gridColumn(
    label: "اسم الشركة",
    value: fv!row.appliedJobs.employer.Name
    )
    },
    pagingsaveinto: local!pagingInfo
    )
    )

Children
No Data

 Discussion posts and replies are publicly visible