Additional wastwater_nodes not exported with Limit to selection

[sjib]

Describe the bug
When using the option "Limit to selection" additional wastewater_nodes in a wastewater_structure (manhole, special_structure, ...) are not exported.

To Reproduce
Exact steps to reproduce the behavior:

1. Go to layer vw_qgep_wastewater_structure
2. Select some wastewater_structures with the Selection tool or a filter
3. Go to layer vw_qgep_reach
4. Add some reaches with the Selection tool or a filter
5. Click on the INTERLIS Export button
6. Choose Limit to selection
7. Check the exported xtf file

Expected behavior
All wastewater_nodes of a structure should be exported, else the network is not complete and cannot be correctly imported in e.g. hydraulic simulation software. A selection of e.g. only PAA network is a specific current use case for using the selection.

Screenshots / data
vw_ggep_reach contains only the information of one wastewater_node per wasterwater_structure (I guess the main_wastewater_node)

It looks like the the filter criteria only takes the id's of the wastewater_nodes in vw_qgep_reach

qgepqwat2ili/qgepqwat2ili/qgep/export.py

Line 504 in c749775

query = query.filter(QGEP.wastewater_networkelement.obj_id.in_(subset_ids))

Suggestion:
Change this criteria to select all connected wastewater_nodes of selected wastewater_structures:
new:
query = query.filter(QGEP.wastewater_networkelement.fk_wastewater_structure.in_(subset_ids))

to do:

• Check whether the same thing is true with channels that have several reaches. Then maybe the same approach could be used.

Current workaround
Use export without selection to get all wastewater_nodes

Desktop (please complete the following information):

• QGEP plugin version 1.5.6
• QGEP datamodel version 1.5.5
• QGEP project file version latest
• QGIS Version 3.23
• OS Windows 10