SEW owner and operator: Sort by IDX

Problem

Why are the lookup values in the Owner and Operator combo box in GEONIS SEW not sorted by IDX?

Cause

It is the case that the owners and operators in GEONIS Urban Drainage are not correctly sorted by IDX by default. The reason for this is due to the data model, as the owners and operators are not classic lookup lists.

Since the owners can reference themselves due to the VSADSS model (e.g. "municipality" as part of "canton"), the relationship in GEONIS SEW is not done via the CODE column as usual, but via the GLOBALID.

Solution

There is a configuration that nevertheless allows sorting by GLOBALID. To do this, the following correction must be made in the FRM-XML:

- original: <select>.... order by awo_organisation.idx</select>

- adapted: <select>.... group by awo_organisation.idx</select>

The procedure would be to search across all FRM-XML for "select * from awo_organization, awos_art_organization" and make the appropriate group adjustment.

It is important to make sure that the IDX values are unique, otherwise entries will be merged.

No fix planned

Update 06/07/2019: The fix is scheduled for GEONIS SEW 2017 SP2 (fall 2019).