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