Is it possible to create one variable from archive?
Hello everyone!
Today I am developing a new functionality to existing project in zenon. I would like to store one archive value, from few days before today to new variable in zenon. The reason to do that is that I I have a project with about 50 water meters and I want to check if there were no consumption in few days (for eg. 3,4 or 7 days) which could indicates problems with meter (cause there is always some water consumption). Each meter actual reading is stored to archive every 24 hours. In SQL I will do that for example in that way:
SELECT Value from Table WHERE Date = dateadd(day,datediff(day,3,GETDATE()),0)
To explain problem more carrefully I will show an example:
Day of week - Meter Reading [m3]
Monday - 150
Tuesday - 150
Wednesday -150
Thursday - 150 [Check if Thursday(actual) value is = Monday value, if it is true show an error] - error
Friday -150 [Check if Friday(actual) value is = Tuesday value, if it is true show an error] - error
Saturday -165 [Check if Saturday(actual) value is = Wednesday value, if it is true show an error] - no error
Sunday - 165 [Check if Sunday(actual) value is = Thursday value, if it is true show an error] - no error
etc.
Is it possible in zenon or maybe I need to prepare VBA macro for that? Or maybe there is another solution for this?
Best regards!
michalt
This is a migrated post! Originally posted on 14.12.2018 by user michalt. Please be aware that information can be outdated.
Disclaimer
This document governs the use of our Community Forum. By registering and using the platform, you accept these conditions.
The COPA-DATA Community Forum serves to encourage the exchange of information and experience about the zenon software between forum users respectively zenon users.
Please mind that any published information on the Community Forum is the subjective opinion and view based on the experience and the level of knowledge of the author. COPA-DATA does not overtake any responsibility for the content and the accuracy of the shared information.
Users of the Community Forum are encouraged to share only well-founded experiences and to point out any risks associated with the implementation of proposed solutions to problems. COPA-DATA at its absolute discretion, reserves the right to moderate the forum. In this connection COPA-DATA may remove any information containing false facts, potentially dangerous solutions, bad language or content that may insult, degrade or discriminate others. COPA-DATA may block a non-complying user from forum access if the user violated this provision.
COPA-DATA reserves the right to change this document from time to time at own discretion.
Ing. Punzenberger COPA-DATA GmbH
Karolingerstraße 7b · 5020 Salzburg · Austria
www.copadata.com