KB-31594: Processing data from a Query.
Question: On a network containing a machine dedicated specifically to the Data Server and others to E3, where is the data from a Query inside the Viewer processed: in the…
Category: English
KB-26943: Viewing images from closed-circuit television (CCTV) in Elipse SCADA.
Question: How can I view images from closed-circuit television (CCTV) in Elipse SCADA? Solution: To do so, you must use the Watcher module with one of the options below: Sensoray…
KB-13968: Executing a StoredProcedure via E3.
Question: How can I execute an Oracle’s StoredProcedure via E3? Solution: In a Query, use the SQL command “call” + StoredProcedure name. For example: – E3 Query: call HourmeterIncrement(‘I724EMD1111’,1) –…
KB-30114: Data format error in a Query.
Question: Why is the data format being regarded as month/day instead of day/month in a Query’s filter by date when the day is a number lower than 13? Solution: This…
KB-31412: Converting the Query’s E3TimeStamp into UTC/GMT time zone.
Question: How can I convert a date returned in the Query (E3TimeStamp) into UTC/GMT time zone? Solution: To do so, you can use SQL’s DATEADD function. Example: SELECT DATEADD(minute, ,…
KB-31658: Recording the user logged in when the alarm went off.
Question: How can I record in the database which user was logged in when the alarm went off? Solution: To do so, one alternative is to use an internal tag…
KB-31657: Property that shows which alarm is currently selected.
Question: Is there any property that indicates which alarm is currently selected at E3Alarm? Solution: To do so you can use GetFocusedEvent() event, which has been a feature in E3…
KB-31553: Changing colors in E3Alarm.
Question: How can I change the text and background colors of the alarms in E3Alarm? Solution: This can be done in E3Alarm‘s properties, on Colors tab. At runtime, whenever a…
KB-31671: E3Alarm’s Operator field.
Question: Why is the name of the operator logged into the application not being displayed in E3Alarm‘s Operator field? Solution: This is because E3Alarm‘s Operator field shows the contents from…
KB-32267: Alarm filter with a ComboBox.
Question: How can I implement an alarm filter by type (Alarm or Event) by using a ComboBox? Solution: To do so, you must first insert a ComboBox onto the same…