Interface with Read Only Grid only displaying Headers and not the data

Question

Hi,
I am using Appian Version 25.4, I have created an Interface with Grid in it. Grid is just expected to read data from Record Type and display it on the Grid. But I only see headers on Interface when I am previewing it. What am I doing wrong here?
I am including code here and the output of the Preview. I am new to Appian and appreciate your help here.

{
  a!localVariables(
    local!pagingInfo: a!pagingInfo(
      startIndex: 1,
      batchSize: 20
    ),
    a!gridField(
      label: "Portfolio",
      labelPosition: "ABOVE",
      data: a!queryRecordType(
        recordType: 'recordType!{730d5dd7-5828-443c-89cf-89b097b856cb}TV Record Type loan..static_info_updated',
        fields:{
          'recordType!{730d5dd7-5828-443c-89cf-89b097b856cb}TV Record Type loan..static_info_updated.fields.{85555feb-8c36-4fce-9eff-2ef66aaab755}loanId',
          'recordType!{730d5dd7-5828-443c-89cf-89b097b856cb}TV Record Type loan..static_info_updated.fields.{c4b7627c-131b-475a-8901-54d34623f07f}servicerLoanId',
          'recordType!{730d5dd7-5828-443c-89cf-89b097b856cb}TV Record Type loan..static_info_updated.fields.{eefd35a7-2d68-4220-be87-84654d07c4c2}sellerLoanId',          
          'recordType!{730d5dd7-5828-443c-89cf-89b097b856cb}TV Record Type loan..static_info_updated.fields.{1f0535e8-e642-4961-9861-01f94896ddab}priorServicerLoanId',
          'recordType!{730d5dd7-5828-443c-89cf-89b097b856cb}TV Record Type loan..static_info_updated.fields.{4262d1b3-f3d0-4f8e-b405-42497445cbbc}propStreet',
          'recordType!{730d5dd7-5828-443c-89cf-89b097b856cb}TV Record Type loan..static_info_updated.fields.{5395535b-0578-4f00-84fc-2927c28296fb}propUnit',
          'recordType!{730d5dd7-5828-443c-89cf-89b097b856cb}TV Record Type loan..static_info_updated.fields.{7fbd17bb-9270-41b5-9889-cf8e62f1b408}propCity',
          'recordType!{730d5dd7-5828-443c-89cf-89b097b856cb}TV Record Type loan..static_info_updated.fields.{915d3c4d-e5e4-4eb9-9406-bd18c4b16a76}propState',
          'recordType!{730d5dd7-5828-443c-89cf-89b097b856cb}TV Record Type loan..static_info_updated.fields.{d5a7a19f-33e1-413f-a1df-915c45790a62}propZip',
          'recordType!{730d5dd7-5828-443c-89cf-89b097b856cb}TV Record Type loan..static_info_updated.fields.{cf1e3408-273f-4b67-912a-6a68e468c30e}propCounty',
          'recordType!{730d5dd7-5828-443c-89cf-89b097b856cb}TV Record Type loan..static_info_updated.relationships.{13f8ddba-0158-4034-8ec8-d16cc75df9a3}recordTypeMappingsdealNoMapping.fields.{d6fc1865-671a-4abd-afaf-27d484311afb}dealName',
          'recordType!{730d5dd7-5828-443c-89cf-89b097b856cb}TV Record Type loan..static_info_updated.fields.{3e326dab-c1ce-485c-b2b0-113608fea39a}borrowerFname',
          'recordType!{730d5dd7-5828-443c-89cf-89b097b856cb}TV Record Type loan..static_info_updated.fields.{377b31ae-a3da-41a6-abc2-d47d27847e7a}borrowerLname'
        },
        pagingInfo: local!pagingInfo
      ),
      columns: {
        a!gridColumn(
          label: "VWH Loan Id",
          value: fv!row['recordType!{730d5dd7-5828-443c-89cf-89b097b856cb}TV Record Type loan..static_info_updated.fields.{85555feb-8c36-4fce-9eff-2ef66aaab755}loanId']
        ),
        a!gridColumn(
          label: "Servicer Loan ID",
          value: fv!row['recordType!{730d5dd7-5828-443c-89cf-89b097b856cb}TV Record Type loan..static_info_updated.fields.{c4b7627c-131b-475a-8901-54d34623f07f}servicerLoanId']
        ),
        a!gridColumn(
          label: "Seller Loan ID",
          value: fv!row['recordType!{730d5dd7-5828-443c-89cf-89b097b856cb}TV Record Type loan..static_info_updated.fields.{eefd35a7-2d68-4220-be87-84654d07c4c2}sellerLoanId']
        ),        
        a!gridColumn(
          label: "Prior Servicer Loan ID",
          value: fv!row['recordType!{730d5dd7-5828-443c-89cf-89b097b856cb}TV Record Type loan..static_info_updated.fields.{1f0535e8-e642-4961-9861-01f94896ddab}priorServicerLoanId']
        ),
        a!gridColumn(
          label: "Property Address",
          value: fv!row['recordType!{730d5dd7-5828-443c-89cf-89b097b856cb}TV Record Type loan..static_info_updated.fields.{4262d1b3-f3d0-4f8e-b405-42497445cbbc}propStreet']
        ),
        a!gridColumn(
          label: "Property County",
          value: fv!row['recordType!{730d5dd7-5828-443c-89cf-89b097b856cb}TV Record Type loan..static_info_updated.fields.{cf1e3408-273f-4b67-912a-6a68e468c30e}propCounty']
        ),      
        a!gridColumn(
          label: "Deal Name",
          value: fv!row['recordType!{730d5dd7-5828-443c-89cf-89b097b856cb}TV Record Type loan..static_info_updated.relationships.{13f8ddba-0158-4034-8ec8-d16cc75df9a3}recordTypeMappingsdealNoMapping.fields.{d6fc1865-671a-4abd-afaf-27d484311afb}dealName']
        ),          
        a!gridColumn(
          label: "Borrower Name",
          value: fv!row['recordType!{730d5dd7-5828-443c-89cf-89b097b856cb}TV Record Type loan..static_info_updated.fields.{3e326dab-c1ce-485c-b2b0-113608fea39a}borrowerFname']
        )
      },
      refreshAfter: "RECORD_ACTION"
    )
  )
}

yashwantha0914 · Accepted Answer

Hi [mention:f715d2a5beee447f95815c5be14799c3:e9ed411860ed4f2ba0265705b8793d05]

Since you’re using queryRecordType() in a read-only grid, queryRecordType() returns a DataSubset (map). Please use the index on it to access only the data.

a!gridField(
  label: "Portfolio",
  labelPosition: "ABOVE",
  data: a!queryRecordType(
    recordType: 'recordType!{730d5dd7-5828-443c-89cf-89b097b856cb}',
    fields: {},
    pagingInfo: local!pagingInfo
  ).data,
  columns: {}
)

Hope it solves your issue.

harshas2775 · Answer

You are missing the data index after queryRecordType() code. queryRecordType returns a data subset but we want data in the grid so at the end of the queryRecordType() put data such as queryRecordType().data then check.

Sign up

Login with SSO

Login to the community

Login with SSO