svy search on a related foundset

Questions
1

I have 3 grids on a form, where every grid has its own form and a 1n relationship, so grandparent → parent → child

I’m using svy_search to do a deep search, but the result is not yet what I would like to have.

640×460 33.7 KB

When I search on “rookworst”, I only get the filter on the highest level, while I only want to show:

Title = 3 koel & diepvries
Hoofdstuk = 44 koeling
and
Assortiment = 564 rookworst

only title is filtered, not the rest.

Can this be done without removing the relations between the forms?

2

I’ve used the addSearchProvider to add related fields to search on.

var search = scopes.svySearch.createSimpleSearch(foundset);
search.addSearchProvider('a_to_b.b_to_c.description', 'description', false);
search.setSearchText(txtSearch);
search.loadRecords(foundset);