{ a!localVariables( local!data: a!recordData( recordType: 'recordType!{bdbacce6-755b-4a52-ab85-3ea4b00c7bfd}VWHIAP_DD_REVIEW_STG', filters: a!queryLogicalExpression( operator: "AND", filters: { a!queryFilter( field: 'recordType!{bdbacce6-755b-4a52-ab85-3ea4b00c7bfd}VWHIAP_DD_REVIEW_STG.fields.{1ce64732-409c-43eb-ad89-865ecbd09000}CURRENT_REVIEW_STAGE', operator: "=", value: "Initial Review" ) }, ignoreFiltersWithEmptyValues: true ), fields: { 'recordType!{bdbacce6-755b-4a52-ab85-3ea4b00c7bfd}VWHIAP_DD_REVIEW_STG.fields.{6aa0c857-afe2-486b-bdeb-6a01ff3ed63f}id', 'recordType!{bdbacce6-755b-4a52-ab85-3ea4b00c7bfd}VWHIAP_DD_REVIEW_STG.fields.{ef25fa56-4caa-4eed-bafa-10a295456244}LOAN_ID', 'recordType!{bdbacce6-755b-4a52-ab85-3ea4b00c7bfd}VWHIAP_DD_REVIEW_STG.fields.{1ce64732-409c-43eb-ad89-865ecbd09000}CURRENT_REVIEW_STAGE', 'recordType!{bdbacce6-755b-4a52-ab85-3ea4b00c7bfd}VWHIAP_DD_REVIEW_STG.fields.{7d1ad9d4-ec89-4e98-8949-6598cbc8083f}PROPERTY_LAST_INSPECTED', 'recordType!{bdbacce6-755b-4a52-ab85-3ea4b00c7bfd}VWHIAP_DD_REVIEW_STG.fields.{033100f2-5477-4443-bfe0-d79d8698aae8}PROPERTY_HAS_HOA' } ), a!gridLayout( label: "Editable Grid", labelPosition: "ABOVE", headerCells: { a!gridLayoutHeaderCell(label: "Id"), a!gridLayoutHeaderCell(label: "Loan ID"), a!gridLayoutHeaderCell(label: "Current Review Stage"), a!gridLayoutHeaderCell(label: "Property Last Inspected"), a!gridLayoutHeaderCell(label: "Property Has HOA") }, columnConfigs: { a!gridLayoutColumnConfig(width: "DISTRIBUTE"), a!gridLayoutColumnConfig(width: "DISTRIBUTE"), a!gridLayoutColumnConfig(width: "DISTRIBUTE"), a!gridLayoutColumnConfig(width: "DISTRIBUTE"), a!gridLayoutColumnConfig(width: "DISTRIBUTE") }, rows: a!forEach( items: local!data, expression: a!gridRowLayout( contents: { a!integerField( value: fv!item.id, saveInto: fv!item.id ), a!integerField( value: fv!item.loanId, saveInto: fv!item.loanId ), a!textField( value: fv!item.currentReviewStage, saveInto: fv!item.currentReviewStage ), a!dateField( value: fv!item.propertyLastInspected, saveInto: fv!item.propertyLastInspected ), a!textField( value: fv!item.propertyHasHOA, saveInto: fv!item.propertyHasHOA ) } ) ), selectionSaveInto: {}, validations: {}, shadeAlternateRows: true ) ) }
Hi,
I have an editable grid, and I am trying fetch data from the Record Type and show it on the Grid. But I am getting below error:
Could not display interface. Please check definition and inputs. Interface Definition: Expression evaluation error at function a!recordData [line 3]: The 'fields' parameter in a!recordData() can only be used to retrieve fields in the latest version of the read-only grid
I have attached code for your reference. Can you please let me know on how else can I get the data from Record Type and show it on this Editable Grid?
Regards,
Mahesh
Discussion posts and replies are publicly visible
a!recordData is meant to be used with the gridField (read-only grid) component. Doesn't work with the editable grid.
https://docs.appian.com/suite/help/24.4/fnc_system_recorddata.html#where-to-use-this-function
For the editable grid, you can just use the regular queryRecordType.
Thank you Mathieu Drouin , then could you please advise on possible ways to accomplish displaying data from a Table onto Editable Grid?
Just replace recordData with queryRecordType.