Welcome, Guest
Username: Password: Remember me

TOPIC: Set Report Database to specific date

Set Report Database to specific date 9 months 3 weeks ago #3270

  • Anna
  • Anna's Avatar
  • Offline
  • Senior Member
  • Posts: 42
  • Karma: 0
Dear Ruslan,
I have created a history database and would like to save the db report with precise dates automatically, not by entering them by hand.
Would it be possible to do something like this?
Thank you in advance
Regards
The administrator has disabled public write access.

Set Report Database to specific date 9 months 3 weeks ago #3271

  • fatkhrus
  • fatkhrus's Avatar
  • Offline
  • Administrator
  • Posts: 984
  • Thank you received: 134
  • Karma: -103
Dear Anna,

It's possible to do by using ST scripts and functions from Date and time library: teslascada.com/HTML/date-and-time-library2.html
For saving User-defined reports use functions: teslascada.com/HTML/report-library.html
For saving Trend or Tables reports use property savereport for these objects. For example: Objects.Trend.savereport = true;

Best regards,
Ruslan
The administrator has disabled public write access.
The following user(s) said Thank You: Anna

Set Report Database to specific date 9 months 3 weeks ago #3272

  • Anna
  • Anna's Avatar
  • Offline
  • Senior Member
  • Posts: 42
  • Karma: 0
Thank you for your reply yesterday.
I was wondering if it would be possible that once the report has been saved, perhaps by clicking a button, the data could be cleaned up in the database, so that the old data would not be seen.
Is it possible to do something like that?
Alternatively, do you have any ideas to recommend me?

Thanks in advice

Regrads
The administrator has disabled public write access.

Set Report Database to specific date 9 months 3 weeks ago #3273

  • fatkhrus
  • fatkhrus's Avatar
  • Offline
  • Administrator
  • Posts: 984
  • Thank you received: 134
  • Karma: -103
Hello,

You can clear database by cleardbtable function: teslascada.com/HTML/database-library.html
Or you can filter by date if you don't want to delete data from DB.

Best regards,
Ruslan
The administrator has disabled public write access.

Set Report Database to specific date 9 months 3 weeks ago #3274

  • Anna
  • Anna's Avatar
  • Offline
  • Senior Member
  • Posts: 42
  • Karma: 0
OK, cleaning the database succeeded. I have two Tags containing two different dates and times, I would like to insert these times to save the database report in excel, how can I do this?
Could you tell me how I can enter the dates automatically without putting them in manually?

Thank you
The administrator has disabled public write access.

Set Report Database to specific date 9 months 3 weeks ago #3275

  • fatkhrus
  • fatkhrus's Avatar
  • Offline
  • Administrator
  • Posts: 984
  • Thank you received: 134
  • Karma: -103
You can use History DB Table properties begin, end, begindatetime or enddatetime in ST scripts and bind your time to these properties before creating report: teslascada.com/HTML/history-db-table.html

Best regards,
Ruslan
The administrator has disabled public write access.
The following user(s) said Thank You: Anna
Go to top