jdvoet
November 8, 2018, 9:48am
6
SLB:
((unique values of (it * second + “01 Jan 1970 00:00:00 -0000” as local time) of (it as integer) of (preceding texts of firsts “,” of it)), (following texts of firsts “,” of it)) of (rows of statements “SELECT IssuedTime,ActionName, IssuerName FROM ACTION_HISTORY where IssuedTime > strftime(‘%25s’, ‘now’) - 1296000 AND IssuerName not like ‘%25ServerSigningCertificate%25’ AND IssuerName not like ‘%25C074_%25’ AND ActionName not like ‘%25Subscribe to Site%25’” of sqlite databases of files “ActionHistory.db” of folders “__Global” of data folders of client as string)
Hi SLB, this is good as well, - 1296000 = 15 days in seconds so to decrease that I could do 60second * 60 minute * 24hour * x number day (5 for 5 days)? Yes?