KB-49201: Using Log10 function and Case/Else commands in an SQL query.
Question: How can I have a Query’s Log10 function be executed only in rows different from 0 (zero), leaving rows equal to zero with value 0 (zero)? Solution: To apply…
Categoria:
Retrieving averages of time (minutes, hours, and days) from an SQL Server database.
In this article, we will show you how to retrieve the averages from the table fields in an SQL Server database of three different time units: minutes, hours, and days.…
Setting up where E3 application’s queries will be executed.
Question: Where are E3 application’s queries executed: in the Viewer or in the Server? Solution: This will depend on EnableLocalCreation property’s value. If EnableLocalCreation property is set as TRUE, the…
KB-37200: Displaying a single register with the InTime and OutTime information in E3 Browser.
Question: How can I display the InTime and OutTime information from an alarm occurrence a single register in E3 Browser? Solution: To do so, we suggest that you use the…
KB-37302: Setting a filter by date on an E3Storage’s Query.
Question: How can I set a filter by date on an E3Storage’s Query? Solution: To do so, you must use the CompressedDataStartEndTime query and set the dates in the respective…
KB-27338: Filtering alarms starting with a given text.
Question: In a Query, how can I filter alarms with areas starting with a given text? Solution: In order to filter alarms with areas starting with a given text (for…
KB-29734: SQL Query returning a single value.
Question: In an application, an SQL Query returns three values to a certain field. How can I set this Query up to return only one of them? Solution: To do…
KB-26869: Alarm filter in an SQL query.
Question: In the application, I have the following folder structure for alarms: alarms\general\se01\switch01 \switch02 \… \switch20 How can I set up the return all alarms from all switches of a…
KB-35064: Converting an EventTimeDbl field into Date/Time format and displaying it on E3Browser
Question: How can I convert an EventTimeDbl field into Date/Time format and display it in an E3Browser? Solution: To do so, use the SQL CONVERT command below in the SQL…
KB-34303: Grouping different tables on the same query
Question: How can I display the fields of different tables in the same SQL query? Solution: To do so, use SQL’s UNION command. Thus, you must enable the E3Query’s SQL…