Arquivos E3Query - Page 4 of 5 - Elipse Knowledgebase

KB-32470: Enabling or disabling a Query’s filters

25 de March de 201914 de January de 2022Elipse SoftwareLeave a Comment

Autor
Mateus Machado

Saving the content of a Database’s table in a text file.

25 de March de 20198 de January de 2020Elipse SoftwareLeave a Comment

Question: How can I save a Database’s table in a text file? Solution: To do so, you can create a Report, configure a Query, and use the Export() method; or…

KB-27768: E3Query retrieving data from an Oracle view.

25 de March de 20197 de March de 2023Elipse SoftwareLeave a Comment

Question: How can I set up an E3Query to retrieve data from an Oracle view? Solution: To do so, just use the SQL SELECT command to select the data the…

KB-27338: Filtering alarms starting with a given text.

25 de March de 2019Elipse SoftwareLeave a Comment

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.

25 de March de 2019Elipse SoftwareLeave a Comment

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.

25 de March de 2019Elipse SoftwareLeave a Comment

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-29125: Firing several queries simultaneously.

25 de March de 20194 de September de 2020Elipse SoftwareLeave a Comment

Question: Does Elipse E3 allow firing several queries at the same time? Solution: Yes, it does. To do this, you will need to use the Execute method, that executes a…

KB-35064: Converting an EventTimeDbl field into Date/Time format and displaying it on E3Browser

25 de March de 2019Elipse SoftwareLeave a Comment

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

25 de March de 2019Elipse SoftwareLeave a Comment

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…

KB-33740: Converting Storage’s E3 TimeStamp field into DateTime.

25 de March de 201922 de May de 2019Elipse SoftwareLeave a Comment

Question: Can I create a query converting the E3TimeStamp field from the E3Storage‘s table into DateTime? Solution: Yes, you can do this. If you are using Oracle, you must use…