Login / Signup

Filter on deferred extended text attributes (#@*An)

 
Scripting
3 Posts
3 Users
0 Likes
27 Views
RSS
BO
 BO
(@b-olombelarcinfo-com)
Posts: 196
Reputable Member
Topic starter
 

Hi everybody,

Do you think it is possible to filter deferred extended text attributes ?
Such as AlarmDisplay("FILTER", "Alarmes", "", "Alarm2", "=(#@*A3 >= 22"); ?
If yes, how ? (the instruction above doesn't work).

thanks a lot.

xoxo

 
Posted : 25/10/2021 4:46 pm
e.mahaut
 e.mahaut
(@e-mahautarcinfo-com)
Posts: 270
Member Moderator
 

Hi Brice,

I don't think it is possible to filter with deferred text attributes using SCADA Basic .
Looking at the workaround with SQL filter directly in the Alarm viewer settings, it seems to work but not for TextIndAttrNN.
The reason why is that the comparison is not done on values but rather on string comparison (data type is string as documented).
Trying with fields as value work fine.

5324=874-c401f1e3612d471ab8203f532d69bbce

Downside is it will not be updated in real time but when the mimic is opened.

Edouard

 
Posted : 25/10/2021 5:56 pm
 Giulia Magnesa
(@admin_doc72)
Posts: 493
Member Admin
 

Hi

Did you try in SQL filter something like

 CAST(TextIndAttr03 AS NUMERIC)>=22

or

CONVERT(NUMERIC,TextIndAttr03)>=22
 
Posted : 02/11/2021 6:17 pm
Forum Jump:
  Previous Topic
Next Topic