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" ) ) }
Discussion posts and replies are publicly visible
Hi maheshg821223
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.
queryRecordType()
DataSubset
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.