Question

getting null value when indexing the dictionary

Forum|Forum|2 years ago
June 6, 2024
5 replies
0 views

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
)

stefanhelzle0001

Brainy

Impossible to say anything without seeing the data in orionData.

P

pavitrad2763Author

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

stefanhelzle0001

Brainy

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.

mikes0011

Brainy

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.

The Expression Guru

Sign up

Login with SSO

Login to the community

Login with SSO