Skip to main content
S
siddagangus0001
September 29, 2023
Solved

RE: Display UI

  • September 29, 2023
  • 13 replies
  • 0 views

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

    Best answer by rishikeshr4182

    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']
    )
    }
    )
    )

    13 replies

    rishikeshr4182
    rishikeshr4182
    September 29, 2023

    You can restructure the list in a dictionary format using different CDTs and make the grid run on a local variable.

    S
    siddagangus0001Author
    September 29, 2023

    Can I get reference code Please?

    rishikeshr4182
    rishikeshr4182Answer
    September 29, 2023

    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']
    )
    }
    )
    )

      Terms & ConditionsAccessibility statement