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", ""), ", "))
What version of Appian are you currently using? If you have 19.2+, it would be far easier to get your grid working by using the modern paging grid component, as it works a lot more easily for certain things (like your case) than the legacy version which you're using.
it worked! Thanks for your help!
we are in 18.2. The solution from vimal worked.
Thanks for confirming - Vimal's solution was optimal for you I believe since you can't make use of the 19.2 style paging grid yet.