Extending found set using related values

Classic Servoy
1

I have a contacts table with related clients and related sites held in 2 other tables. I want to be able to find a set of contacts related to client 3, then extend the set with all contacts related to site 1.

If I first perform a find in the contacts table for contacts related to client 3 I get the correct found set. If I then start a new find for contacts related to site 1 followed by Extend Search I get ALL records rather than just the first set (contacts for client 3) plus the second set (contacts for site 1)

This method (which mimics the above) also returns ALL records:

controller.find();
contacts_to_client_sps.clientid = 3;
controller.search( true, false);
controller.find();
contacts_to_site_sps.siteid = 1;
controller.search( false, false);

What am I doing wrong?

2

Try this:

controller.find(); 
contacts_to_client_sps.clientid = 3; 
controller.search( true, true); 
controller.find(); 
contacts_to_site_sps.siteid = 1; 
controller.search( false, false);
3

(Sorry - thought I was logged in - original query was from drookwood)

HJK:
Try this:

controller.find();

contacts_to_client_sps.clientid = 3;
controller.search( true, true);
controller.find();
contacts_to_site_sps.siteid = 1;
controller.search( false, false);

I think I tried this before. Just checked again with same result - all records found!

4

Bug confirmed, will be fixed in Servoy 2.0 rc3 , thanks for reporting.