Records Vanished away from the Foundset

Classic Servoy
1

Hi All,

I am showing a list of records in a table view. Some of the fields in the list are related fields. If I am sorting based on a related field and some of the records does not have a value for that related field, then Servoy simply removes those records from the foundset. I have tried the same by creating a sample Servoy solution also filed a case for the same in Support System. Case ID : 225,859.

2

Set the relation type to outer join

Paul

3

Hi Paul,

Thanks for a quick response.

I have set, type to “left_outer_join”, still removing the records that have null values.

4

Mmm, are you sure?

If sorting on related records and there are no related records, if the join type is “outer join”, then the records should not disappear.

Which version are you on?

Paul

5

Hi Paul,

Yes, I am sure. I have I have set, type to “left_outer_join”.

I am running on Servoy Version: 4.1.3 - build 672.

6

Can you reproduce this in a simple solution? If so, please file a case in our support system.

Paul

7

ars:
Hi All,

I am showing a list of records in a table view. Some of the fields in the list are related fields. If I am sorting based on a related field and some of the records does not have a value for that related field, then Servoy simply removes those records from the foundset. I have tried the same by creating a sample Servoy solution also filed a case for the same in Support System. Case ID : 225,859.

I have this -old- issue also in 3.5.10.
(See: http://forum.servoy.com/viewtopic.php?f=8&t=10845&start=0&st=0&sk=t&sd=a&sid=3c6b4eaaaecdf26e2b6d6723dad9db8f)