It is currently Wed Jul 23, 2014 1:50 am




Post new topic This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 
 DataBase model decided by Ignition 
Author Message
Cadet
Cadet

Joined: Mon Apr 23, 2012 4:53 am
Posts: 9
Post DataBase model decided by Ignition
Hi.
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
Profile
Moderator
Moderator

Joined: Fri Dec 04, 2009 9:02 am
Posts: 177
Post 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
Profile
Cadet
Cadet

Joined: Mon Apr 23, 2012 4:53 am
Posts: 9
Post Re: DataBase model decided by Ignition  Topic is solved
Tnx a lot! I'll go for it.


Thu Jun 07, 2012 11:30 pm
Profile
Display posts from previous:  Sort by  
Post new topic This topic is locked, you cannot edit posts or make further replies.  [ 3 posts ] 


Who is online

Users browsing this forum: No registered users and 2 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

Search for:
Jump to: