Skip to content

  • Projects
  • Groups
  • Snippets
  • Help
    • Loading...
    • Help
    • Support
    • Submit feedback
    • Contribute to GitLab
  • Sign in / Register
D
datapoolOperational
  • Project
    • Project
    • Details
    • Activity
    • Releases
    • Cycle Analytics
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
    • Charts
  • Issues 12
    • Issues 12
    • List
    • Boards
    • Labels
    • Milestones
  • Merge Requests 0
    • Merge Requests 0
  • CI / CD
    • CI / CD
    • Pipelines
    • Jobs
    • Schedules
    • Charts
  • Packages
    • Packages
    • Container Registry
  • Wiki
    • Wiki
  • Snippets
    • Snippets
  • Members
    • Members
  • Collapse sidebar
  • Activity
  • Graph
  • Charts
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
  • andy.disch
  • datapoolOperational
  • Issues
  • #15

Closed
Open
Opened Feb 13, 2019 by andy.disch@andy.disch
  • Report abuse
  • New issue
Report abuse New issue

Unflagged sites?

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

Assignee
Assign to
None
Milestone
None
Assign milestone
Time tracking
None
Due date
None
0
Labels
None
Assign labels
  • View project labels
Reference: andy.disch/datapoolOperational#15