Skip to content

Elipse Knowledgebase

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

Category: E3Query

KB-33206: Filter by date not working with string values.

25 de March de 2019Elipse SoftwareLeave a Comment on KB-33206: Filter by date not working with string values.

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…

Read More

KB-33119: Query filter.

25 de March de 20194 de February de 2020Elipse SoftwareLeave a Comment on KB-33119: Query filter.

Autor
Mateus Machado

Read More

KB-32962: Grouping records returned by a query.

25 de March de 2019Elipse SoftwareLeave a Comment on KB-32962: Grouping records returned by a query.

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…

Read More

KB-32129: Syntax for creating variables in E3Query.

25 de March de 2019Elipse SoftwareLeave a Comment on KB-32129: Syntax for creating variables in E3Query.

Question: What is the syntax for creating variables in E3Query? Solution: To create a variable, just inform any name between these symbols:         for a numeric value. ‘‘       for a…

Read More

KB-28682: Retrieving a limited amount of data in the Query.

25 de March de 2019Elipse SoftwareLeave a Comment on KB-28682: Retrieving a limited amount of data in the Query.

Question: How can I set up a Query to display the last 15 records? Solution: To do so, you must enable SQL direct edition, and use SQL’s TOP command set…

Read More

KB-27977: Deleting the records stored in a database.

25 de March de 20197 de March de 2023Elipse SoftwareLeave a Comment on KB-27977: Deleting the records stored in a database.

Question: How can I delete all the records from a database via E3? Solution: To do so, you have to create a Query and, in it, set up the SQL…

Read More

KB-20214: SQL function to calculate maximum, minimum, and average values.

25 de March de 2019Elipse SoftwareLeave a Comment on KB-20214: SQL function to calculate maximum, minimum, and average values.

Question: How can I set an SQL query (Access database) to retrieve the tag’s maximum, minimum, and average values? Solution: To do so, you must use MAX, MIN, and AVG…

Read More

KB-28190: Filter in SQL Query using time value.

25 de March de 2019Elipse SoftwareLeave a Comment on KB-28190: Filter in SQL Query using time value.

Question: How can I query a certain period (initial and final date), while also adding filter it by hour within this period? (For example: the query must return data only…

Read More

KB-13180: SQL query returning values every 10 minutes.

25 de March de 201926 de April de 2019Pudi, Ricardo MeurerLeave a Comment on KB-13180: SQL query returning values every 10 minutes.

Question: How can I have an SQL query return values every ten minutes, even when the Historic keeps recording these values every second? Example: 4h 30min – tag1 = 1…

Read More

KB-29079: Excluding records from a database from a selection in E3Browser.

25 de March de 201923 de January de 2020Elipse SoftwareLeave a Comment on KB-29079: Excluding records from a database from a selection in E3Browser.

Question: How can I exclude a record from  the database from a selection in an E3Browser on the application’s screen? Solution: To delete the record, you can use a Query…

Read More

Posts navigation

Previous 1 … 4 5

Categories

Search by Category

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