We have a requirement to filter the Dashboard grid based on child table data.
For each Company, multiple forms exist, categorized into different types (1, 2, 3). However, only one form is considered active.
To determine the active form, we refer to the Form Uploads table, where:
(Only these records should be considered.)
The following filter is not working, likely due to an issue with related records filtering:
a!queryFilter( field: Company.form.FormUploads.statusId, operator: "=", value: 2 ), a!queryFilter( field: Company.form.FormUploads.referenceId, operator: "=", value: 17 )
The query record type is Company, and we need to display Company data in the grid.
Discussion posts and replies are publicly visible
PavanSrihari said:The following filter is not working, likely due to an issue with related records filtering:
Please share more details and explain why you think that this might be the issue.
Do you need to return only rows where both the statusId=2 and the referenceId=17? If so, you might need to use the AND_ALL operator in your query logical expression.