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…
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…
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…
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…
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…
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…
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…
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…
Question: Why is a filter by date, recorded as a string, not working? Solution: For the comparison logic to work (value higher than InitialDate, but lower than FinalDate), the value…
Question:How can I group the records returned by a query whose values were repeated in all the fields of that row? Solution: To do so, you need to use SQL’s…