Hello Everyone,
I have to show the UI like this(read-only), first two columns' data comes from different table (like collateral_cdt) and 3rd and 4th columns data comes from (cust_doc_cdt).How can I display this Ui?
Please suggest on priority
Discussion posts and replies are publicly visible
You can restructure the list in a dictionary format using different CDTs and make the grid run on a local variable.
Can I get reference code Please?
Here I have used two different record having some relation between them. I believe in your case also the tables must have some relation with each others.You can have a rough idea from here, if that helps you.
a!localVariables( local!tickets: rule!PM_QR( recordType: 'recordType!{5f0bd786-7684-4f3e-aff0-378836d403d9}PM Tickets', filters: a!queryFilter( field: 'recordType!{5f0bd786-7684-4f3e-aff0-378836d403d9}PM Tickets.fields.{2eb8bdc6-97a3-4a70-81ae-3fdbb1268306}projectId', operator: "=", value: 1 ) ), local!ticketAdditionaldetails: rule!PM_QR( recordType: 'recordType!{ee57e7bb-821c-4d98-8707-82bcf2fe8216}PM Tickets Additional Details', filters: a!queryFilter( field: 'recordType!{ee57e7bb-821c-4d98-8707-82bcf2fe8216}PM Tickets Additional Details.fields.{6cd53353-96fb-424f-afdf-34de7e66cbff}ticketId', operator: "IN", value: local!tickets['recordType!{5f0bd786-7684-4f3e-aff0-378836d403d9}PM Tickets.fields.{df9c3dbf-550e-4d8f-a54e-8f2d372d3eee}id'] ) ), a!gridField( data: local!tickets, columns: { a!gridColumn( label: "Ticket Id", value: fv!row['recordType!{5f0bd786-7684-4f3e-aff0-378836d403d9}PM Tickets.fields.{df9c3dbf-550e-4d8f-a54e-8f2d372d3eee}id'] ), a!gridColumn( label: "Title", value: fv!row['recordType!{5f0bd786-7684-4f3e-aff0-378836d403d9}PM Tickets.fields.{6b0b4ddd-a48f-4b11-b1f5-be442dd9ac82}title'] ), a!gridColumn( label: "Story Points", value: index( local!ticketAdditionaldetails, wherecontains( fv!row['recordType!{5f0bd786-7684-4f3e-aff0-378836d403d9}PM Tickets.fields.{df9c3dbf-550e-4d8f-a54e-8f2d372d3eee}id'], tointeger( local!ticketAdditionaldetails['recordType!{ee57e7bb-821c-4d98-8707-82bcf2fe8216}PM Tickets Additional Details.fields.{6cd53353-96fb-424f-afdf-34de7e66cbff}ticketId'] ) ), {} )['recordType!{ee57e7bb-821c-4d98-8707-82bcf2fe8216}PM Tickets Additional Details.fields.{0e12c3d6-ae60-4548-83b1-6b040b0cd93d}reporter'] ), a!gridColumn( label: "Status Id", value: index( local!ticketAdditionaldetails, wherecontains( fv!row['recordType!{5f0bd786-7684-4f3e-aff0-378836d403d9}PM Tickets.fields.{df9c3dbf-550e-4d8f-a54e-8f2d372d3eee}id'], tointeger( local!ticketAdditionaldetails['recordType!{ee57e7bb-821c-4d98-8707-82bcf2fe8216}PM Tickets Additional Details.fields.{6cd53353-96fb-424f-afdf-34de7e66cbff}ticketId'] ) ), {} )['recordType!{ee57e7bb-821c-4d98-8707-82bcf2fe8216}PM Tickets Additional Details.fields.{e30c84f7-1c08-4684-9fa5-53233700a3a4}status'] ) } ))
yes thanks.