Sum total filtered by date with OVER(Transact-sql) clause.
This article shows how to retrieve the sum total of an estimated time period by using OVER clause alongside WHERE clause in Elipse E3. According to Microsoft’s documentation, the OVER…
Category: E3Query
KB-111510: Grouping data from a Query within a time interval.
Question: How can I group data from an Elipse E3 Query within certain time interval? For example, what can I do when I need the sampling time to show data…
KB-108744: Returning Elipse E3’s active alarms via database.
Question: How can I return the active alarms in Elipse E3 via database records? Solution: In order to return the active alarms in Elipse E3 (acknowledged or not), you must…
Returning the duration (in minutes) of an active alarm.
Question: How can I return the duration (in minutes) that the alarm was active? Solution: Alarm sources are Elipse E3‘s objects which set up all the information regarding to…
How to add/remove columns from an E3Browser.
Question: How can I add/remove columns from an E3Browser? Solution: E3Browser is an ActiveX control used for visualizing data stores in the database, be they generated by Elipse E3…
Transfering data between tables with Elipse E3.
Question: How can I transfer data between two different tables from a query with Elipse E3? Solution: The object E3Query helps setting up queries in the application’s database. This object…
KB-106987: Subtracting record values in a table Field.
Question: There is a table field that receives the tag whose value is the total sum of a certain variable in the system; however, I need to subtract these record…
Returning a value not recorded in the Database.
This article illustrates how to return a value that has not been recorded in the Elipse E3 Database yet. Many times, you will need to check if a certain value…
KB-93711: Return data from different tables with FULL OUTER JOIN.
Question: How can I join data from two different tables (on the same database) with FULL OUTER JOIN function? I need to join data from two tables that share a…
KB-86136: Displaying a Formula’s Value Set that transposes lines into columns.
Question: Can a Value Set, available on a Formula’s Values tab, be displayed on a table? The E3Browser will display the items in the following format: And the Formula’s Values…