Hi Andy,

ich habe meine queries jetzt "in order" at least thats what I think^^

Jetzt hat sich folgende Frage ergeben:

Kann es sein, dass dein flagging nicht für alle site durchgeführt wird?

Hier mal ein Beispiel:

qq = "SELECT signal.timestamp, value, unit, parameter.name, source_type.name,
                source.name, signal_quality.quality_id
         FROM signal
           INNER JOIN site ON signal.site_id = site.site_id
           INNER JOIN parameter ON signal.parameter_id = parameter.parameter_id
           INNER JOIN source ON signal.source_id = source.source_id
           INNER JOIN source_type ON source.source_type_id = source_type.source_type_id
           INNER JOIN signals_signal_quality_association ON signals_signal_quality_association.signal_id = signal.signal_id
           INNER JOIN signal_quality ON signals_signal_quality_association.signal_quality_id = signal_quality.signal_quality_id
         WHERE site.name ='rohrbach_fehraltorferstr'
         GROUP BY signal.signal_id, parameter.name, unit, source_type.name, source.name,signal_quality.quality_id
         ORDER BY signal.timestamp ASC;"

qq_no_q = "SELECT signal.timestamp, value, unit, parameter.name, source_type.name,
                source.name
         FROM signal
           INNER JOIN site ON signal.site_id = site.site_id
           INNER JOIN parameter ON signal.parameter_id = parameter.parameter_id
           INNER JOIN source ON signal.source_id = source.source_id
           INNER JOIN source_type ON source.source_type_id = source_type.source_type_id
         WHERE site.name ='rohrbach_fehraltorferstr'
         GROUP BY signal.signal_id, parameter.name, unit, source_type.name, source.name
         ORDER BY signal.timestamp ASC;"

Die erste query gibt jedoch leider nix wieder.

Die zweite query gibt mir daten für die site wieder.

Betroffene sites und damit verbundene sources sind:

 sites 
-------
450a_usterstr
rohrbach_fehraltorferstr
rubmorg_inflow
164_luppmenweg
outflow_ara


 sources 
---------
bt_plsABL1301_outflow_ara
bl_dl311_rubmorg_inflow
bl_lm076_rohrbach_fehraltorferstr
bl_ce465_rohrbach_fehraltorferstr
bf_plsABL1101_outflow_ara
bt_dl928_165_luppmenweg
bl_plsRKBM1201_rubmorg_inflow
bt_dl927_164_luppmenweg
bt_dl929_164_luppmenweg
bq_plsABL3701_outflow_ara
bx_ce792_450a_usterstr
bt_dl926_rubmorg_inflow

Grüße!

Christian