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

Certified Senior Developer

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.

  Discussion posts and replies are publicly visible