Expression evaluation error at function a!forEach [line 51]: Error in a!forEach() expression during iteration 1: Expression evaluation error : Invalid index: Cannot index property 'therapeuticArea' of type Text into type DataSubset

Certified Associate Developer

Hi All, Please help me on this error

a!localVariables(
  local!listOfAmendments: if({
    index(
      index(
        rule!ISR_er_PopulateAmendmentsInExecuteMeetingDataSubset(meetingId: ri!meetingId),
        "data",
        {}
      ),
      "amdId",
      {}
    ) = index(rule!ISR_qry_GetISRAmendmentPrimaryReviewers(
      meetingId: ri!meetingId,
      primaryReviewer: ri!primaryReviewer,
      isActive: true
    ),"amdId",{})
  },rule!ISR_er_PopulateAmendmentsInExecuteMeetingDataSubset(meetingId: ri!meetingId ),{}),
  /*(Amendment Number, Amendment Reason, Proposal Reference Number, */
  /*Study Title, Primary Investigator, Medical Scientist/Proposal Champion (from GIL-134), */
  /*Currency, Budget, Slides (Slide for the Amendment) (GIL-263))*/
  local!tableAmendmentGridStart: "
<p> Amendments to be Reviewed: </p>
<table align=""left"" cellpadding=""0"" cellspacing=""0"" width=""100%"" bgcolor=""ffffff"" style=""border-top: 0.5px solid #414141; border-bottom: 0.5px solid #414141; border-left: 0.5px solid #414141; border-right: 0.5px solid #414141; table-layout: fixed; margin-bottom: 20px"" width=""1300"" border=""1"" >
<thead>

 

 

<tr>
<th align=""left"" width=""250"" style=""border-top: 0.5px solid #414141; border-bottom: 0.5px solid #414141; border-left: 0.5px solid #414141; border-right: 0.5px solid #414141; padding: 5px 5px 5px 5px; color: #414141; font-family: 'Calibri', Arial, sans-serif; font-size: 16px; font-weight: normal; line-height: 18px;"">
<b>TA</b>
</th>
<th align=""left"" width=""120"" style=""border-top: 0.5px solid #414141; border-bottom: 0.5px solid #414141; border-left: 0.5px solid #414141; border-right: 0.5px solid #414141; padding: 5px 5px 5px 5px; color: #414141; font-family: 'Calibri', Arial, sans-serif; font-size: 16px; font-weight: normal; line-height: 18px;"">
<b>Ref #</b>
</th>
<th align=""left"" width=""200"" style=""border-top: 0.5px solid #414141; border-bottom: 0.5px solid #414141; border-left: 0.5px solid #414141; border-right: 0.5px solid #414141; padding: 5px 5px 5px 5px; color: #414141; font-family: 'Calibri', Arial, sans-serif; font-size: 16px; font-weight: normal; line-height: 18px;"">
<b>PI</b>
</th>
<th align=""left"" width=""150"" style=""border-top: 0.5px solid #414141; border-bottom: 0.5px solid #414141; border-left: 0.5px solid #414141; border-right: 0.5px solid #414141; padding: 5px 5px 5px 5px; color: #414141; font-family: 'Calibri', Arial, sans-serif; font-size: 16px; font-weight: normal; line-height: 18px;"">
<b>Country</b>
</th>
<th align=""left"" width=""150""  style=""border-top: 0.5px solid #414141; border-bottom: 0.5px solid #414141; border-left: 0.5px solid #414141; border-right: 0.5px solid #414141; padding: 5px 5px 5px 5px; color: #414141; font-family: 'Calibri', Arial, sans-serif; font-size: 16px; font-weight: normal; line-height: 18px;"">
<b>Study Category</b>
</th>

 

 

</tr>
</thead>
<tbody>
",
  local!tableAmendmentGridEnd: "</tbody> </table>",
  local!amendmentsGrid: a!forEach(
    items: local!listOfAmendments,
    expression: "

 

 

<tr> 
<td align=""left"" style=""border-top: 0.5px solid #414141; border-bottom: 0.5px solid #414141; border-left: 0.5px solid #414141; border-right: 0.5px solid #414141; padding: 2px 2px 2px 2px;"">" & fv!item.therapeuticArea & "</td>" & "<td align=""left"" style=""border-top: 0.5px solid #414141; border-bottom: 0.5px solid #414141; border-left: 0.5px solid #414141; border-right: 0.5px solid #414141; padding: 2px 2px 2px 2px;"">" & rule!CMN_er_generateRecordLink(
      label: fv!item.amendmentNumber & " / " & fv!item.proposalNumber,
      recordType: cons!ISR_RECORD_GS_AMENDMENT,
      identifier: fv!item.amdId,
      siteUrl: cons!ISR_GS_AMENDMENT_RECORD_SITE_PAGE_URL
    ) & "</td>" & /*"<td align=""left"" style=""padding: 2px 2px 2px 2px;"">" & fv!item.proposalNumber & "</td>" & */
    "<td align=""left"" style=""border-top: 0.5px solid #414141; border-bottom: 0.5px solid #414141; border-left: 0.5px solid #414141; border-right: 0.5px solid #414141; padding: 2px 2px 2px 2px;"">" & fv!item.primaryResearcher & "</td>" & "<td align=""left"" style=""border-top: 0.5px solid #414141; border-bottom: 0.5px solid #414141; border-left: 0.5px solid #414141; border-right: 0.5px solid #414141; padding: 2px 2px 2px 2px;"">" & fv!item.countryName & "</td>" & "<td align=""left"" style=""border-top: 0.5px solid #414141; border-bottom: 0.5px solid #414141; border-left: 0.5px solid #414141; border-right: 0.5px solid #414141; padding: 2px 2px 2px 2px;"">" & index(
      rule!ISR_qry_GetReferenceValueByType(
        typeCode: cons!ISR_TEXT_TYPECODE_RESTYPE,
        code: index(
          rule!ISR_qry_GetStudyRequestsByReferenceNumber(
            referenceNumbers: fv!item.proposalNumber
          ),
          "researchType",
          {}
        ),
        isActiv: true()
      ),
      "name",
      {}
    ) & "</td>
</tr>"
  ),
  /*local!listOfAmendments*/
  concat(
    local!tableAmendmentGridStart,
    joinarray(local!amendmentsGrid, " "),
    local!tableAmendmentGridEnd
  )
)

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data