Any way to search clipboard history by date?

[cutcopypaste]

If I think I may have copied something on a certain date, it would be pretty cool to be able to back and filter things that way. Is there any way to query stuff in the clipboard history by program/date etc?

 

Alternately is that data stored somewhere I can peak into it?

[Andrew]

It's not possible to search by date within Alfred itself, but the clipboard database is an SQLite database stored in

 

~/Library/Application\ Support/Alfred\ 3/Databses/clipboard.alfdb

 

It's pretty self explanatory if you take a look at the schema, so you should be able to find what you need

 

Cheers,

Andrew

 

[agierczyk]

Hi, so I pulled up the database but there is no datefield. How can we filter the SQL database by date? 

[Andrew]

@agierczyk ts is the timestamp column, this is in seconds since reference date (00:00:00 UTC on 1 January 2001).

 

Cheers,

Andrew

[agierczyk]

Thanks Andrew. What do you think about real date-time filters for Clipboard history, since this is a fairly tedious way to search?

[danielrasmuson]

This is exactly what I wanted. Thanks so much!