filter alarm table

Linear Mode

filter alarm table

Frank68 Offline

Offline

Senior Member

Posts: 327
Threads: 126
Joined: May 2020
Reputation: 0

#17

12.02.2021, 14:56

(12.02.2021, 14:40)admin Wrote: There's no date format in the database, UNIX timestamp (integer) is used to store date/time. Either the query is incorrect or you don't have alerts matching the requested time-frame.
Run this script once and post what got get in Logs tab:

Code:
data = db:getall('SELECT COUNT(1) total, MIN(alerttime) tmin, MAX(alerttime) tmax FROM alerts') log(data)
this is log

Find

Reply

« Next Oldest | Next Newest »

Messages In This Thread

filter alarm table - by Frank68 - 12.02.2021, 12:07

RE: filter alarm table - by admin - 12.02.2021, 12:14

RE: filter alarm table - by Frank68 - 12.02.2021, 12:41

RE: filter alarm table - by admin - 12.02.2021, 13:04

RE: filter alarm table - by Frank68 - 12.02.2021, 13:12

RE: filter alarm table - by admin - 12.02.2021, 13:20

RE: filter alarm table - by Frank68 - 12.02.2021, 13:35

RE: filter alarm table - by admin - 12.02.2021, 13:45

RE: filter alarm table - by Frank68 - 12.02.2021, 13:49

RE: filter alarm table - by admin - 12.02.2021, 14:00

RE: filter alarm table - by Frank68 - 12.02.2021, 14:07

RE: filter alarm table - by admin - 12.02.2021, 14:18

RE: filter alarm table - by Frank68 - 12.02.2021, 14:22

RE: filter alarm table - by admin - 12.02.2021, 14:25

RE: filter alarm table - by Frank68 - 12.02.2021, 14:30

RE: filter alarm table - by admin - 12.02.2021, 14:40

RE: filter alarm table - by Frank68 - 12.02.2021, 14:56

RE: filter alarm table - by admin - 12.02.2021, 15:14

RE: filter alarm table - by Frank68 - 12.02.2021, 15:21

RE: filter alarm table - by admin - 12.02.2021, 15:27

RE: filter alarm table - by Frank68 - 12.02.2021, 15:35

RE: filter alarm table - by admin - 12.02.2021, 15:41

RE: filter alarm table - by Frank68 - 12.02.2021, 15:56

RE: filter alarm table - by admin - 12.02.2021, 16:59

RE: filter alarm table - by Frank68 - 15.02.2021, 07:03

RE: filter alarm table - by admin - 15.02.2021, 07:49

RE: filter alarm table - by Frank68 - 15.02.2021, 08:03

View a Printable Version