Sort on null value in Tableview hides records

Classic Servoy
1

Hi again,

I have a tableview listing some people applying for a job. You can click on the column headings to sort the list, this is just standard built-in Servoy functionality.

Each person has had a number of interviews. These are stored in a separate table. I have a number of columns in my table view layout where I pull in the date of first, second and third interview from the related file using Servoy relationships.

If a user clicks on the column header of let’s say the third interview date, the people which have a third interview are sorted correctly, and the others vanish.

The only way you can get the records back is to go to another person and back. Sorting by another column does not bring them back.

Is this a limitation of table views or a bug?

Servoy 3.1.x, 3.5.5 Mac OS X 10.4 - 10.5.x

2

It is the result of a sort using an inner join. Not existing related records cannot be sorted using inner joins. Change the relation to an outer join and it will work as you expect.

3

patrick:
It is the result of a sort using an inner join. Not existing related records cannot be sorted using inner joins. Change the relation to an outer join and it will work as you expect.

Thanks Patrick,
That did the trick :slight_smile: