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
You code is really hard to read. You try to address the field "therapeuticArea" in a data structure that is of type datasubset.
In general, this error message means something like: "Hey dude, this data structure does not have a field of that name!"
Is thee any solution for above error.Because therapeutic area is there in data sub set but still we are getting error