svy search on a related foundset

Forum to discuss the new web client version of Servoy.

svy search on a related foundset

Postby onno » Tue Jul 12, 2022 3:16 pm

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.

Image

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?
onno
 
Posts: 2
Joined: Fri Jan 01, 2021 6:19 pm

Re: svy search on a related foundset

Postby Louis.Winter » Fri Jul 29, 2022 11:36 pm

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

Code: Select all
var search = scopes.svySearch.createSimpleSearch(foundset);
search.addSearchProvider('a_to_b.b_to_c.description', 'description', false);
search.setSearchText(txtSearch);
search.loadRecords(foundset);
Louis Winter
Journey Technology Solutions
Sioux Falls, SD USA
Louis.Winter
 
Posts: 24
Joined: Thu Dec 13, 2018 8:10 pm


Return to Servoy NGClient

Who is online

Users browsing this forum: No registered users and 7 guests

cron