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
Hi Meena,
Try index(index(local!datasubset.data.OMCAppointmentInfo,"AppointeeTM",{}),"FullName",{}) ?
It seems like in your expression you are indexing AppointeeTM twice which would return empty value.
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.
Got you. Your grid line item is based on the OMCAppointmentInfo.
The below expression should help you:
a!foreach(items: index(local!datasubset.data.OMCAppointmentInfo, expression: joinarray(index(index(fv!item, "AppointeeTM", ""), "FullName", ""), ", "))
it worked! Thanks for your help!