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
Have you ensured that your record type is actually populated with data?
If you copy out just the "queryRecordType" call and run it from a blank Expression Editor, do you see resulting queried data there?
Hi Mike,
Yes, I have tried to put the queryRecordType in an Expression, and I was able to see the data. Please see attached screenshot for my test case.
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.
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.
The issue is that a!queryRecordType() returns data subset not data.Use ).data in line 22
Use a!queryRecordType().data or you can directly call a!recordData() to directly get the record data without .data paramter