How to display grid field with CDT having nested CDT

I have a process backed record interface with a OMCAppointmentInfo CDT which has AppointeeTM CDT array. Each OMC Appointment will have multiple TMs. Trying to display TMs fullname for each Appointment and no data is being displayed. Below interface code doesn't display any data

a!gridTextColumn(
label: "TM Appointee",
field: "OMCAppointmentInfo.AppointeeTM",
data: index(index(index(local!datasubset.data.OMCAppointmentInfo,"AppointeeTM",{}),
"AppointeeTM",{}),"FullName",{})
)

here is the sample AppointmentInfo CDT data:

[AID=1241, AwardNumber=CORHQ-15-A-0022, VendorInfo=[AID=1259, Company=% OF COMPLETION INSPECTIONS, Address=12051 ANDES ST., City=RENO, State=NV, ZipCode=89506, POCName=Meena, POCEmailAddress=mrajagopalan@fdic.gov, PPID=268454006], AppointeeOM=[AID=1199, FullName=Meenakshi Rajagopalan, UserName=mrajagopalan, DateAppointed=1/6/2020, DateSigned=6/23/2015, DateApproved=6/23/2015, DateRemoved=, Signature=PS, APSModNumber=, AdditionalDuties=If you are appointed as a Task Order Oversight Manager (TOOM), you are required to communicate and work jointly with the individual appointed as Oversight Manager (OM) for the Agreement (i.e. Basic Ordering Agreement (BOA) Receivership Basic Ordering Agreement (RBOA), or Blanket Purchase Agreement (BPA)), to ensure consistency across the Agreement. Decisions or guidance that could impact other Task Orders will be coordinated through the Agreement’s OM., Deleted=, PPID=268454013], AppointeeTM=[AID=585, FullName=Mirek Kiczko, UserName=mkiczko, DateAppointed=5/15/2015, DateSigned=, DateApproved=, DateRemoved=, Signature=, AdditionalDuties=test2, Deleted=, PPID=268454043],[AID=586, FullName=Michael Chirlin, UserName=mchirlin, DateAppointed=5/14/2015, DateSigned=, DateApproved=, DateRemoved=, Signature=, AdditionalDuties=test3, Deleted=, PPID=268454027],[AID=587, FullName=Braden Jaeger, UserName=bjaeger, DateAppointed=5/15/2015, DateSigned=, DateApproved=, DateRemoved=, Signature=, AdditionalDuties=testing, Deleted=, PPID=268454037], AwardCO=mrajagopalan, Division=Division of Administration, EffectiveDate=5/31/2015, ExpirationDate=5/31/2015, ClosedOutDate=, Description=Test Solicitataion, APSObjectDBID=2427, APSObjectPPID=268453989, PPID=268454006]

It has to display the 3 TM Full names . Any ideas hot to achieve this?

Thanks,

Meena

  Discussion posts and replies are publicly visible

Parents Reply
  • Tried but returns error 

    Interface Definition: Expression evaluation error at function a!gridField [line 110]: A grid component [label=“My Active Milestone Schedules - CO”] has an invalid value for “columns” and “value”. All “data” arrays must not contain more items than the specified “batchSize”, but “batchSize” was 20 and the largest column data array had 22 items.

Children