Skip to main content
March 21, 2025
Question

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

  • March 21, 2025
  • 2 replies
  • 0 views

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
March 21, 2025
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
March 21, 2025

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.