It is currently Mon Sep 01, 2014 1:01 pm




Post new topic Reply to topic  [ 10 posts ] 
 datatype and querymode 
Author Message
General
General

Joined: Tue Feb 24, 2009 1:30 pm
Posts: 891
Location: Calgary
Post datatype and querymode
What are the possible values for these columns in the sqlth_te table?
And what do they mean?
:scratch:


Thu Nov 10, 2011 12:45 pm
Profile WWW
Moderator
Moderator

Joined: Thu Mar 30, 2006 10:08 pm
Posts: 1190
Post Re: datatype and querymode
I was hoping that this SQLTags Custom Driver Guide would help, but it was written prior to SQLTags History. So I guess I'm not much help with your question. Hopefully this guide is useful to someone, though.

_________________
Nathan Boeger, CISSP-ISSAP, CCNP Voice, VCP
Not Another Industrial Blog - My SCADA software blog
"Design Simplicity Cures Engineered Complexity"


Thu Nov 10, 2011 2:04 pm
Profile WWW
General
General

Joined: Tue Feb 24, 2009 1:30 pm
Posts: 891
Location: Calgary
Post Re: datatype and querymode
Thanks Nathan,

I have that on my desk :) Perhaps it could be expanded for tag history?


Thu Nov 10, 2011 2:39 pm
Profile WWW
Moderator
Moderator

Joined: Sun Apr 02, 2006 3:43 pm
Posts: 2495
Post Re: datatype and querymode
DataType - the "type class" of the tag, used to tell which column the data comes from.
0 - Int
1 - Float
2 - String
3 - Date/Time

QueryMode - another name for "interpolation" mode, or the "category" of data.
0 - Discrete/Digital
3 - Analog

How'd it go from 0 to 3? 1 used to be analog, but with 7.3 we had to change what analog meant (with compression), so 1=Old style analog, while 3=new compressed analog. 2 means the same as 1, but as a selectable option, which isn't actually selectable right now (it was used for testing/dev, but we didn't think it made sense in the release).

For what it's worth, I'll throw in a bonus note about what the different analog modes mean:
1 or 2, old style - simple deadband. With 2 values stored, the system only interpolates from V2.timestamp-SC_Exec_Rate.
3, new style - SLIM compression. With 2 values, the system interpolates across the full range from V1.timstamp->V2.timestamp.

The repercussions for this are that graphing the raw data looks more correct with the new system, but discrete values incorrectly classified look worse.

Ok, way more than you asked for.

_________________
Colby Clegg
Inductive Automation
Software Development


Thu Nov 10, 2011 2:55 pm
Profile
Moderator
Moderator

Joined: Sun Apr 02, 2006 3:43 pm
Posts: 2495
Post Re: datatype and querymode
Quote:
Perhaps it could be expanded for tag history?


Yes, I suppose we should update it. I also need to update it for the new option of writing to properties through the write queue table, instead of through config change. (Note: the write queue changes are backwards compatible, so don't worry if this is the first time you've heard of the change).

And of course, soon we'll have to add in better support for property value changes and custom properties...

Regards,

_________________
Colby Clegg
Inductive Automation
Software Development


Thu Nov 10, 2011 2:58 pm
Profile
General
General

Joined: Tue Feb 24, 2009 1:30 pm
Posts: 891
Location: Calgary
Post Re: datatype and querymode
Colby.Clegg wrote:
custom properties...


Oooo, you big tease. How long do I have to wait for this?


Thu Nov 10, 2011 3:12 pm
Profile WWW
Moderator
Moderator

Joined: Sun Apr 02, 2006 3:43 pm
Posts: 2495
Post Re: datatype and querymode
I really hope we can work it in to the changes we're making for 7.4. Can't say for sure yet, but we'll see.

Regards,

_________________
Colby Clegg
Inductive Automation
Software Development


Thu Nov 10, 2011 4:02 pm
Profile
General
General

Joined: Tue Feb 24, 2009 1:30 pm
Posts: 891
Location: Calgary
Post Re: datatype and querymode
I've lost track of this,

do we have the ability to directly reference custom tag properties? Do I have to wait for 7.5?


Fri Jun 08, 2012 10:20 am
Profile WWW
Moderator
Moderator

Joined: Sun Apr 02, 2006 3:43 pm
Posts: 2495
Post Re: datatype and querymode
Sorry, no, still no custom properties. The properties on UDTs can't be accessed from outside, and they don't exist yet in external tags either. We really looked at doing this, but ultimately couldn't work it in to the very limited schedule (5 weeks) we had for 7.5.

Regards,

_________________
Colby Clegg
Inductive Automation
Software Development


Thu Jun 14, 2012 9:22 am
Profile
General
General

Joined: Tue Feb 24, 2009 1:30 pm
Posts: 891
Location: Calgary
Post Re: datatype and querymode
Oh well, at least your still thinking about it.


Thu Jun 14, 2012 1:02 pm
Profile WWW
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 10 posts ] 


Who is online

Users browsing this forum: Yahoo [Bot] 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: