AnsweredAssumed Answered

PI RDBMS Interface Tag configuration - Konfiguracja taga (pl)

Question asked by jag_69 on May 23, 2016
Latest reply on May 25, 2016 by jag_69

I set tag with SQL query. I would like to have query result written to the tag, if the result is present. If not it should be NoOutput(). Is it possible?

--

Założyłem taga z zapytaniem SQL. Chcę aby do taga były zapisany wynik zapytania jeśli jest, a w innym przypadku ma być NoOutput(). Czy jest to możliwe?

 

 

Selected(x)x
NameSPM_Wega_NieZamknietyRozladunek
ObjectTypePIPoint
DescriptionSPM Wega -nie zamknięty rozładunek
engunits
pointsource5
displaydigits-5
exdesc/SQL="SELECT DISTINCT GETDATE() AS PI_TIMESTAMP, (SELECT ('Zlecenie: ' + CAST(nr AS VARCHAR) + ' (' + CAST(id AS VARCHAR) + ') ' + 'na Placu nr ' + CAST(id_mag_magazyn AS VARCHAR) + ' - transport nie zakończony (' + CAST(status_ogolny AS VARCHAR) + '/ ' + CAST(status_transport AS VARCHAR) +')') AS wRozladunku FROM zlc_zlecenie WHERE status_transport=63 AND status_ogolny >=50),0 FROM zlc_zlecenie ;"
ptclassnameclassic
pointtypeString
sourcetag
digitalset
NewName
future0
instrumenttag
location1103
convers1
filtercode0
location21
location30
location42
location50
squareroot0
srcptid0
totalcode0
userint10
userint20
userreal10
userreal20
datasecuritypiadmin: A(r,w) | piadmins: A(r,w) | PIWorld: A(r)
ptsecuritypiadmin: A(r,w) | piadmins: A(r,w) | PIWorld: A(r)
span100
zero0
archiving1
compressing1
excmin0
excdevpercent0
scan1
shutdown1
step1
typicalvalue50
compdev0
compmax28800
compmin0
compdevpercent0
excdev0
excmax600
changedate2016-05-23 06:36:14
changerSWIECIE\Graczyk_Janusz
creationdate2016-05-23 06:12:46
creatorSWIECIE\Graczyk_Janusz
pointid57504

 

 

Message was edited by: Patrice Thivierge

Translation to english.  Thanks Wojciech Pribula!

Outcomes