Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Inverter-temperature alarm error en valors frontera #13

Open
catbru opened this issue Nov 9, 2021 · 1 comment
Open

Inverter-temperature alarm error en valors frontera #13

catbru opened this issue Nov 9, 2021 · 1 comment
Labels
good first issue Good for newcomers

Comments

@catbru
Copy link
Contributor

catbru commented Nov 9, 2021

La funció lag() provoca que es comparin valors d'inversors diferents.
Cal filtrar les comparacions de manera que quedin només les del mateix inversor.

commit hash: 125d76d

@polmonso polmonso added the good first issue Good for newcomers label Nov 9, 2021
@polmonso
Copy link
Collaborator

polmonso commented Nov 9, 2021

tot i estar ordenat per inversor, les primeres 12 lectures les compararà amb les de l'inversor precedent enlloc de marcar-les com a NULL.

Com a possible solució o es fa un CASE o bé s'amplia el rang de la query interna dues hores i després es filtra out amb un where del rang demanat

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
good first issue Good for newcomers
Projects
None yet
Development

No branches or pull requests

2 participants