Conversation:

Notices

1. kat (boneidol)'s status on Thursday, 09-Aug-2012 14:09:52 EDT kat

   Remote profile options...
   !vivalafederation !feds how can you tell which twitter import notice is associated with statusnet user account(s) ? #mysql
   • kat (boneidol)'s status on Thursday, 09-Aug-2012 14:10:26 EDT kat

     Remote profile options...
     eg. what mysql query would identify the indy.im user that imported this notice https://indy.im/notice/10496235 from twitter
   • kat (boneidol)'s status on Thursday, 09-Aug-2012 14:11:02 EDT kat

     Remote profile options...
     context.. have received a request to delete content pulled across twitter bridge
   • Chimo (chimo)'s status on Thursday, 09-Aug-2012 18:24:35 EDT Chimo

     Remote profile options...

     • kat
     @boneidol couldn’t figure out an SQL statement so I made a script: http://sn.chromic.org/url/12546
   • Chimo (chimo)'s status on Thursday, 09-Aug-2012 18:26:19 EDT Chimo

     Remote profile options...

     • kat
     @boneidol The only thing you need to change is the DB credentials (in theory anyway).
   • kat (boneidol)'s status on Thursday, 09-Aug-2012 20:17:36 EDT kat

     Remote profile options...

     • Chimo
     @chimo thanks, that works, but only for the most recent 1024 pieces of content per user timeline. Which is interesting by itself too.