Hi,
Can someone tell is there any issue with my code here.. Im getting null value when I index as below. I get output of local!orionData as a dictionary(List of Variant).
a!localVariables( local!orionData: a!forEach( items: index( { 'recordType!{d1de8e89-4208-44d3-bb27-0306902c0671}RGRACSLBL Label Change Country'( 'recordType!{d1de8e89-4208-44d3-bb27-0306902c0671}RGRACSLBL Label Change Country.fields.{6c137b66-e39e-49a8-b443-3728d8ccd6a4}id': 20817, 'recordType!{d1de8e89-4208-44d3-bb27-0306902c0671}RGRACSLBL Label Change Country.fields.{d38471f1-b8d4-4a37-8bee-0f24c7dd7508}country': "Australia", 'recordType!{d1de8e89-4208-44d3-bb27-0306902c0671}RGRACSLBL Label Change Country.fields.{6ebd94a9-cdde-4846-b29c-4c833d6e80c3}requestId': 7757 ), 'recordType!{d1de8e89-4208-44d3-bb27-0306902c0671}RGRACSLBL Label Change Country'( 'recordType!{d1de8e89-4208-44d3-bb27-0306902c0671}RGRACSLBL Label Change Country.fields.{6c137b66-e39e-49a8-b443-3728d8ccd6a4}id': 20818, 'recordType!{d1de8e89-4208-44d3-bb27-0306902c0671}RGRACSLBL Label Change Country.fields.{d38471f1-b8d4-4a37-8bee-0f24c7dd7508}country': "United Kingdom", 'recordType!{d1de8e89-4208-44d3-bb27-0306902c0671}RGRACSLBL Label Change Country.fields.{6ebd94a9-cdde-4846-b29c-4c833d6e80c3}requestId': 7757 ), 'recordType!{d1de8e89-4208-44d3-bb27-0306902c0671}RGRACSLBL Label Change Country'( 'recordType!{d1de8e89-4208-44d3-bb27-0306902c0671}RGRACSLBL Label Change Country.fields.{6c137b66-e39e-49a8-b443-3728d8ccd6a4}id': 20822, 'recordType!{d1de8e89-4208-44d3-bb27-0306902c0671}RGRACSLBL Label Change Country.fields.{d38471f1-b8d4-4a37-8bee-0f24c7dd7508}country': "Austria", 'recordType!{d1de8e89-4208-44d3-bb27-0306902c0671}RGRACSLBL Label Change Country.fields.{6ebd94a9-cdde-4846-b29c-4c833d6e80c3}requestId': 7757 ), 'recordType!{d1de8e89-4208-44d3-bb27-0306902c0671}RGRACSLBL Label Change Country'( 'recordType!{d1de8e89-4208-44d3-bb27-0306902c0671}RGRACSLBL Label Change Country.fields.{6c137b66-e39e-49a8-b443-3728d8ccd6a4}id': 20823, 'recordType!{d1de8e89-4208-44d3-bb27-0306902c0671}RGRACSLBL Label Change Country.fields.{d38471f1-b8d4-4a37-8bee-0f24c7dd7508}country': "China", 'recordType!{d1de8e89-4208-44d3-bb27-0306902c0671}RGRACSLBL Label Change Country.fields.{6ebd94a9-cdde-4846-b29c-4c833d6e80c3}requestId': 7757 ) }, 'recordType!{d1de8e89-4208-44d3-bb27-0306902c0671}RGRACSLBL Label Change Country.fields.{6c137b66-e39e-49a8-b443-3728d8ccd6a4}id', {} ), expression: rule!RGRACSLBL_getOrionMilestoneDataForPLLs(labelChangeCountryId: fv!item) ), local!eventsList: index(local!orionData, "eventId_int", {}), local!eventsList )
Discussion posts and replies are publicly visible
Impossible to say anything without seeing the data in orionData.
Also it's impossible to tell what the output should be without knowing what "rule!RGRACSLBL_getOrionMilestoneDataForPLLs()" is supposed to output, especially considering you didn't expand the evaluated value of local!orionData in your screenshot.
output of orionData
{ { { reasonForWithdrawal_txt: "", associationsClosedAs_txt: "NOT APPROVED", closedDate_dt: fn!date(2018, 6, 21), labelUpdatePriority_txt: "Standard", haDue_dt: null, submissionOffHold_dt: null, procedureType_txt: "National", reasonForOnHold_txt: "", projectName_txt: "", projectId_int: fn!tointeger(null), applicationName_txt: "Trial Complete CTA 0431-061 AU", applicationId_int: 64553220, productName_txt: "9 Products In Application", mkv_txt: "MK-0431", status_txt: "HQ Released", approved_dt: null, submissionNotRequired_dt: null, submissionOnHold_dt: null, refCountryApproval_dt: null, submitted_dt: null, hqSMARelease_dt: fn!date(2007, 5, 4), ccdsUpdateApproval_dt: null, notificationLead_dt: null, lrn_txt: "NA", countryName_txt: "Australia", countryCode_txt: "AU", eventName_txt: "CIB and PRotocol currently only the planned agency dates are available", eventType_txt: "Original", eventId_int: 65303209, uniqueId_int: 438444 } }, { { reasonForWithdrawal_txt: "", associationsClosedAs_txt: "NOT APPROVED", closedDate_dt: fn!date(2018, 3, 5), labelUpdatePriority_txt: "Standard", haDue_dt: null, submissionOffHold_dt: null, procedureType_txt: "National", reasonForOnHold_txt: "", projectName_txt: "", projectId_int: fn!tointeger(null), applicationName_txt: "Trial Complete CTA 0431-061 GB", applicationId_int: 64553223, productName_txt: "sitagliptin phosphate : Investigational", mkv_txt: "MK-0431", status_txt: "HQ Released", approved_dt: null, submissionNotRequired_dt: null, submissionOnHold_dt: null, refCountryApproval_dt: null, submitted_dt: null, hqSMARelease_dt: fn!date(2007, 5, 4), ccdsUpdateApproval_dt: null, notificationLead_dt: null, lrn_txt: "N/A", countryName_txt: "United Kingdom", countryCode_txt: "GB", eventName_txt: "CMC info: 100-mg sitagliptin tablet and placebo, 30-mg pioglitazone and placebo", eventType_txt: "Original", eventId_int: 65303303, uniqueId_int: 438445 } }, { { reasonForWithdrawal_txt: "", associationsClosedAs_txt: "NOT APPROVED", closedDate_dt: fn!date(2018, 3, 5), labelUpdatePriority_txt: "Standard", haDue_dt: null, submissionOffHold_dt: null, procedureType_txt: "National", reasonForOnHold_txt: "", projectName_txt: "", projectId_int: fn!tointeger(null), applicationName_txt: "Trial Complete CTA 0431-061 AT", applicationId_int: 64553241, productName_txt: "sitagliptin phosphate : Investigational", mkv_txt: "MK-0431", status_txt: "HQ Released", approved_dt: null, submissionNotRequired_dt: null, submissionOnHold_dt: null, refCountryApproval_dt: null, submitted_dt: null, hqSMARelease_dt: fn!date(2007, 5, 4), ccdsUpdateApproval_dt: null, notificationLead_dt: null, lrn_txt: "N/A", countryName_txt: "Austria", countryCode_txt: "AT", eventName_txt: "CMC info: 100-mg sitagliptin tablet and placebo, 30-mg pioglitazone and placebo", eventType_txt: "Original", eventId_int: 65303301, uniqueId_int: 441057 } }, { { reasonForWithdrawal_txt: "", associationsClosedAs_txt: "", closedDate_dt: null, labelUpdatePriority_txt: "Not Applicable for Original Event", haDue_dt: null, submissionOffHold_dt: null, procedureType_txt: "National", reasonForOnHold_txt: "Pending Original Marketing Application Approval", projectName_txt: "", projectId_int: fn!tointeger(null), applicationName_txt: "CTA 0431-291 CN", applicationId_int: 64553946, productName_txt: "sitagliptin phosphate : Investigational", mkv_txt: "MK-0431", status_txt: "HQ Released", approved_dt: null, submissionNotRequired_dt: null, submissionOnHold_dt: null, refCountryApproval_dt: null, submitted_dt: null, hqSMARelease_dt: fn!date(2011, 12, 2), ccdsUpdateApproval_dt: null, notificationLead_dt: null, lrn_txt: "No applicable", countryName_txt: "China", countryCode_txt: "CN", eventName_txt: "CMC, PK, PD, Tox, Clin, IB 10, Section 4 (prot was provided previously via email)", eventType_txt: "Original", eventId_int: 65303321, uniqueId_int: 441101 }, { reasonForWithdrawal_txt: "", associationsClosedAs_txt: "NOT APPROVED", closedDate_dt: fn!date(2018, 3, 6), labelUpdatePriority_txt: "Standard", haDue_dt: null, submissionOffHold_dt: null, procedureType_txt: "National", reasonForOnHold_txt: "", projectName_txt: "", projectId_int: fn!tointeger(null), applicationName_txt: "Trial Complete CTA 0431-040 CN", applicationId_int: 64553017, productName_txt: "sitagliptin phosphate : Investigational", mkv_txt: "MK-0431", status_txt: "HQ Released", approved_dt: null, submissionNotRequired_dt: null, submissionOnHold_dt: null, refCountryApproval_dt: null, submitted_dt: null, hqSMARelease_dt: fn!date(2005, 10, 31), ccdsUpdateApproval_dt: null, notificationLead_dt: null, lrn_txt: "N/A", countryName_txt: "China", countryCode_txt: "CN", eventName_txt: "A. Baker sent via e-mail the protocol and CIB - Oct. 2005", eventType_txt: "Original", eventId_int: 65301613, uniqueId_int: 441777 } } }
This seems like a typical list-in-list issue.
You can use a!flatten to turn this into a uniform list. Then your indexing should work.
Yes tried this and it worked.. Thank you