Help on StatSortOrder parameter for EXPORT_LOG Mode GETSTATISTIC

6 Posts
3 Users
0 Likes
31 Views
(@admin_doc72)
Posts: 493
Member Admin
Topic starter
 

Hi all

Does anyone know the value for the parameter StatSortOrder in Scada Basic for EXPORT_LOG Mode GETSTATISTIC ?

Only 0 or 1 (but why a lonblong type ) ?

Nothing in the help about this N?

Thanks a lot

 
Posted : 08/07/2020 4:57 pm
LM
 LM
(@l-micaudarcinfo-com)
Posts: 383
Member Admin
 

Hello Nicolas,

I have never played with EXPORT_LOG nor EXPORT_TREND but I think we should add an example in QuickStart project. This could help promotion of exports licences.
If no one know we should make a documentation SPR.

See you

 
Posted : 09/07/2020 3:12 pm
b.lepeuple
(@b-lepeuplearcinfo-com)
Posts: 149
Estimable Member
 

The information in the online help seems to be accurate.

The description of the StatSortOrder argument says: "The statistic used to sort the results. Selected using one of the values used for StatFlag. 0 = no sorting"
So, if you do not want sorting: Put 0 for this argument.
If you want to sort by a certain stat column, then pass the value of the corresponding stat as described for StatFlag:
0x0000 0000 0001 if you want to sort by Total transition count (1)
0x0000 0000 0002 if you want to sort by Bit to 0 (Occurrences) (2)
0x0000 0000 0004 if you want to sort by Bit to 1 (Occurrences) (4)
0x0000 0000 0008 if you want to sort by Bit NS (Occurrences) (8)
0x0000 0000 0010 if you want to sort by Bit to 0 (Duration) (16)
0x0000 0000 0020 if you want to sort by Bit to 1 (Duration) (32)
0x0000 0000 0040 if you want to sort by Bit NS (Duration) (64)
0x0000 0000 0080 if you want to sort by Alarm off (Occurrences) (128)
0x0000 0000 0100 if you want to sort by Alarm on (Occurrences) (256)
0x0000 0000 0200 if you want to sort by Alarm off ack (Occurrences) (512)
0x0000 0000 0400 if you want to sort by Alarm off not ack (Occurrences) (1024)
0x0000 0000 0800 if you want to sort by Alarm on ack (Occurrences) (2048)
0x0000 0000 1000 if you want to sort by Alarm on not ack (Occurrences) (4096)
0x0000 0000 2000 if you want to sort by Alarm unavailable (Occurrences) (8192)
0x0000 0000 4000 if you want to sort by Alarm masked by expression (Occurrences) (16384)
0x0000 0000 8000 if you want to sort by Alarm inhibited (Occurrences) (32768)
0x0000 0001 0000 if you want to sort by Alarm not accessible (Occurrences) (65536)
0x0000 0002 0000 if you want to sort by Alarm masked by program (Occurrences) (131 072)
0x0000 0004 0000 if you want to sort by Alarm masked by user (Occurrences) (262 144)
0x0000 0008 0000 if you want to sort by Alarm masked by variable (Occurrences) (524 288)
0x0000 0010 0000 if you want to sort by Alarm off (Duration) (1 048 576)
0x0000 0020 0000 if you want to sort by Alarm on (Duration) (2 097 152)
0x0000 0040 0000 if you want to sort by Alarm off ack (Duration) (4 194 304)
0x0000 0080 0000 if you want to sort by Alarm off noack (Duration) (8 388 608)
0x0000 0100 0000 if you want to sort by Alarm on ack (Duration) (16 777 216)
0x0000 0200 0000 if you want to sort by Alarm on not ack (Duration) (33 554 432)
0x0000 0400 0000 if you want to sort by Alarm unavailable (Duration) (67 108 864)
0x0000 0800 0000 if you want to sort by Alarm masked by expression (Duration) (134 217 728)
0x0000 1000 0000 if you want to sort by Alarm inhibited (Duration) (268 435 456)
0x0000 2000 0000 if you want to sort by Alarm not accessible (Duration) (536 870 912)
0x0000 4000 0000 if you want to sort by Alarm masked by program (Duration) (1 073 741 824)
0x0000 8000 0000 if you want to sort by Alarm masked by user (Duration) (2 147 483 648)
0x0001 0000 0000 if you want to sort by Alarm masked by variable (Duration) (4 294 967 296)

I hope it helps

 
Posted : 10/07/2020 1:51 pm
b.lepeuple
(@b-lepeuplearcinfo-com)
Posts: 149
Estimable Member
 

And don't mind the emojii, our forums loves the figure eight in parenthesis 😉

 
Posted : 10/07/2020 1:52 pm
(@admin_doc72)
Posts: 493
Member Admin
Topic starter
 

Hi Benoit

Thanks for your answer. I did not understand the online help, read it too fast thinking what I want to do...

I want to know my top ten "longer" alarm on a period so
MaxValuesToProcess = 10
StatFlag 0x0000 0020 0000
StatSortOrder 0x0000 0020 0000

but what is the sort order : increasing or decreasing ?

 
Posted : 10/07/2020 3:47 pm
b.lepeuple
(@b-lepeuplearcinfo-com)
Posts: 149
Estimable Member
 

I am not sure if and how you can pass the desired sort order as an argument.
Ask Arnaud, and post feedback here. It is time to improve the doc if possible.

Regards

 
Posted : 10/07/2020 3:54 pm