DataBase model decided by Ignition
|
||||||||||||||||||||||||||||||||||||||||||||
  |
Page 1 of 1 |
[ 3 posts ] |
| Print view | Previous topic | Next topic |
| Author | Message |
|---|---|
|
Cadet  Joined: Mon Apr 23, 2012 4:53 am Posts: 9 |
 DataBase model decided by IgnitionHi.
As I am going forward with the know-how of Ignition (great really) now it seems I do not have the control of the tables in my database to customize my historical data. I mean, first time I tried Ignition I just created a simulated OPC-Ua device and got it had its own historical table. But right now, in all my tests, the only tables I see are Code: sqlt_data_1_2012_06 sqlth_drv sqlth_partitions sqlth_sce sqlth_scinfo sqlth_te Is that the only way it works now or otherway, how can I control my DB model to have whatever I want, one table by OPC-Ua device, foreign keys between such tables ....whatever |
| Thu Jun 07, 2012 8:12 am |
 |
 |
|
|
Moderator  Joined: Fri Dec 04, 2009 9:02 am Posts: 169 |
Re: DataBase model decided by Ignition You'll want to look into transaction groups for historical logging. That will allow you to choose the table name and column names. You also get triggering ability, so you can log information only when a certain condition is met (time of day, plc value, etc...)
For getting started with transaction groups, check out the user manual entry. |
| Thu Jun 07, 2012 8:23 am |
|
|
|
|
Cadet Joined: Mon Apr 23, 2012 4:53 am Posts: 9 |
Re: DataBase model decided by Ignition  Tnx a lot! I'll go for it.
|
| Thu Jun 07, 2012 11:30 pm |
|
|
|
|
|
Page 1 of 1 |
[ 3 posts ] |
|
All times are UTC - 8 hours |
Who is online |
Users browsing this forum: No registered users and 4 guests |
| You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot post attachments in this forum |