Skip to main content
Inspiring
Mar 21, 2025 6:57 AM UTC
Question

Based on Child table (One to Many) can we filter parent table data ?

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:

  • Status ID = 2
  • Source ID = 17

(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.

2 replies

stefanhelzle0001
Brainy
Mar 21, 2025 7:53 AM UTC
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.

peter.lewis
Employee
Mar 21, 2025 6:14 PM UTC

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.