Home › Reply › Reply To: Filter Conversational Explorer by time

Reply To: Filter Conversational Explorer by time

Home › Forums › Feature request › Filter Conversational Explorer by time › Reply To: Filter Conversational Explorer by time

October 19, 2016 at 3:51 am #819
mhawksey
Keymaster

been meaning to add this for a while. There is a url hack you can do mentioned in this post

For example here is a TAGSExplorer for tweets less than 2015-11-30:

https://hawksey.info/tagsexplorer/?key=1FwzkMe_lHqMS-MCvKFqo82GxLHk9wjjaLJdwgud1dh8&sheet=Archive&tq=SELECT+A,B,C,D,J,L+,M,N+WHERE+E+%3C%3D+date+%272015-11-30%27&tqx=reqId:0

You can also do queries like the last 7 days using:

http://hawksey.info/tagsexplorer/?key=1FwzkMe_lHqMS-MCvKFqo82GxLHk9wjjaLJdwgud1dh8&sheet=Archive&tq=SELECT+A,B,C,D,J,L+,M,N+WHERE+DATEDIFF(NOW(),E)+%3C%3D7&tqx=reqId:0

  • This reply was modified 7 years, 6 months ago by mhawksey. Reason: formatting
  • This reply was modified 7 years, 6 months ago by mhawksey.