Editable Grid Interface -- Fetching data from Record Type
{
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
