Problem with distinct

Classic Servoy
1

Hello,

Is it possible to do a distinct on a search?

I use “Find and Search” method from Servoy. It work fine but I have 2times the same records.

I try to use, a loadRecord with query “Select distinct…” but I obtain the same problem.

Someone have a idea?

2

Which version of Servoy are you using?

Because this sounds like the behavior that was present in Servoy < 3.5. In the current 3.5 version, the behavior changed, so you have distinct values automatically.

Paul

3

Hi,

I use:

Servoy Developer
Version 3.1.6-build 410
Java version 1.6.0_01-b06 (Windows XP)

4

There is a problem with distinct selects in Servoy < 3.5…

5

The behavior prior to 3.5 was like you described. It’s altered in 3.5, so you do not get the double lines.

Best solution is to upgrade to 3.5.

Regards,

Paul

6

Oki thanks

7

Hi,

The distinct works fine on Servoy 3.5 but I saw something wrong in aggregation.

In list view, I show the “SelectedIndex / maxRecordIndex (total_ligne)”
Total_ligne is a aggregation, type count, on pkid.

example: 5 / 200 (3560)

When I search a record on related record, the distinct works fine, but the aggregation don’t care about this distinct.
So sometime, I have :

example: 1 / 3 (5)

I little be strange. Anyone have a idea?

Thanks