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

Add more SQL examples how to query database #209

Open
MRIIOT opened this issue Dec 17, 2022 · 2 comments
Open

Add more SQL examples how to query database #209

MRIIOT opened this issue Dec 17, 2022 · 2 comments
Labels
documentation Improvements or additions to documentation enhancement New feature or request

Comments

@MRIIOT
Copy link
Contributor

MRIIOT commented Dec 17, 2022

example:

SELECT
  substring(path,'$device/(.*)') as attribute,
  time,
  value,
  lower(units) as units
FROM history_all
WHERE
  path IN ('$device/Availability', '$device/LoadCondition', '$device/Message', '$device/FunctionalMode',
  '$device/SystemCondition', '$device/Controller/EmergencyStop', '$device/Axes/Rotary[C]/RotaryMode')

  and $__timeFilter("time")
order by time desc
limit 200
@bburns bburns changed the title Add more SQL examples (how to query database) docs - add more SQL examples (how to query database) Dec 17, 2022
@bburns bburns self-assigned this Dec 17, 2022
@tukusejssirs tukusejssirs added the documentation Improvements or additions to documentation label Dec 17, 2022
@MRIIOT
Copy link
Contributor Author

MRIIOT commented Dec 17, 2022

@bburns Proposed tasks have no assignees.

@tukusejssirs
Copy link
Contributor

@MRIIOT, we might want to configure GitHub Action to auto-remove all assignees when an issue is in proposed in the project.

@tukusejssirs tukusejssirs added the enhancement New feature or request label Dec 22, 2022
@tukusejssirs tukusejssirs changed the title docs - add more SQL examples (how to query database) Add more SQL examples how to query database Dec 22, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
documentation Improvements or additions to documentation enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

3 participants