Skip to content

Elipse Knowledgebase

  • Home
  • Português do BrasilPortuguês do Brasil
    • English (US)English (US)

Categoria:

KB-49201: Using Log10 function and Case/Else commands in an SQL query.

25 de março de 2019Elipse SoftwareDeixe um comentário on 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…

Leia Mais

Retrieving averages of time (minutes, hours, and days) from an SQL Server database.

25 de março de 2019Elipse SoftwareDeixe um comentário on 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.…

Leia Mais

Setting up where E3 application’s queries will be executed.

25 de março de 2019Elipse SoftwareDeixe um comentário on 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…

Leia Mais

KB-37200: Displaying a single register with the InTime and OutTime information in E3 Browser.

25 de março de 2019Elipse SoftwareDeixe um comentário on 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…

Leia Mais

KB-37302: Setting a filter by date on an E3Storage’s Query.

25 de março de 2019Elipse SoftwareDeixe um comentário on 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…

Leia Mais

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

25 de março de 2019Elipse SoftwareDeixe um comentário on 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…

Leia Mais

KB-29734: SQL Query returning a single value.

25 de março de 2019Elipse SoftwareDeixe um comentário on 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…

Leia Mais

KB-26869: Alarm filter in an SQL query.

25 de março de 2019Elipse SoftwareDeixe um comentário on 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…

Leia Mais

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

25 de março de 2019Elipse SoftwareDeixe um comentário on 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…

Leia Mais

KB-34303: Grouping different tables on the same query

25 de março de 2019Elipse SoftwareDeixe um comentário on 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…

Leia Mais

Navegação por posts

1 2 Próximo

Categorias

Busca por Categoria

© 2025 Elipse Knowledgebase | Elipse Software - Todos os Direitos Reservados.