Category: E3Query

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…

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…

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…

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…

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…

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…