Hi Maria,
What I did to try and reproduce you problem is create a orders form and a order_detail form. To reduce the ammount of records I put the order form in find mode and filtered on just one order. Then I used the following code to create and bind the converted foundset:
- Code: Select all
var convertedFoundSet = databaseManager.convertFoundSet(foundset, orders_to_order_details);
forms.orderdetails.controller.showRecords(convertedFoundSet);
This then shows the order_detail records for the selected order. When I invert:
- Code: Select all
var fs = forms.orderdetails.foundset;
fs.invertRecords();
then it shows all orderdetail records except the orignally selected one which is what you would expect.
So the question is how do you filter the 6 records out from the 8? Because that's what Servoy probably needs to succesfully do an invert. I am guessing it's not with a find/search?
Also note that Servoy does not literally invert. If the table has 300 records and 200 records are available in the foundset. Then an invert will not show the other 100 records from the table. So it actually only inverts your filtering criteria.
Hope this helps a bit.