Windows 10 will reach EOS (end of support) on October 14, 2025. For more information, see this article.

Kërkoni te Asistenca

Shmangni karremëzime gjoja asistence. S’do t’ju kërkojmë kurrë të bëni një thirrje apo të dërgoni tekst te një numër telefoni, apo të na jepni të dhëna personale. Ju lutemi, raportoni veprimtari të dyshimtë duke përdorur mundësinë “Raportoni Abuzim”.

Mësoni Më Tepër

finding a list of email authors, finding first and last?

  • Pa përgjigje
  • 0 e kanë hasur këtë problem
  • 2 parje
more options

I want to continue using TB but a few things really make me despair of it. But there may be workarounds. If I have a question, when did these people last send me an email, or have any of these people responded to something, there seems to be no way to get to a list. But. I found a way to do it. Using sqlite3.

I have been wanting a CLI for interacting with TB for a while. You know, that folder I have with 10k+ emails and if I click on it, the UI spins forever. What is even in that?

Now I can do this: 1) copy the global-messages-db.sqlite from the active profile to another place 2) run: sqlite3 global-messages-db.sqlite 3) ```sqlite> select m1.c3author, min(m2.date), max(m2.date) from messagesText_content m1, messages m2 where m1.docid = m2.id group by m1.c3author order by m1.c3author; ... ray kiddy <ray@ganymede.org>|1732124816000000|1759268233000000 ruby29@something undefined|1756740716000000|1756740716000000 salvatore@someother undefined|1758733831000000|1758733831000000 support@linode.com undefined|1755126295000000|1755126295000000 ... ```

Holy sender dates, Batman! Now I can see the earliest and latest email sent by any user. Now I can filter, sort, and see every person who sent me something in a time period. And whether it was 1 email or 1000, I just see the names and not an enormous amount of other information.

So, is this the only way to get this? Or the best? I have no idea. Please let me know if there is a better way, perhaps one using TB itself. It would be nice.

In the meantime, I will be wrapping this in a python call, doing some formatting and it will work and I can stop worrying about not seeing their email.

I want to continue using TB but a few things really make me despair of it. But there may be workarounds. If I have a question, when did these people last send me an email, or have any of these people responded to something, there seems to be no way to get to a list. But. I found a way to do it. Using sqlite3. I have been wanting a CLI for interacting with TB for a while. You know, that folder I have with 10k+ emails and if I click on it, the UI spins forever. What is even in that? Now I can do this: 1) copy the global-messages-db.sqlite from the active profile to another place 2) run: sqlite3 global-messages-db.sqlite 3) ```sqlite> select m1.c3author, min(m2.date), max(m2.date) from messagesText_content m1, messages m2 where m1.docid = m2.id group by m1.c3author order by m1.c3author; ... ray kiddy <ray@ganymede.org>|1732124816000000|1759268233000000 ruby29@something undefined|1756740716000000|1756740716000000 salvatore@someother undefined|1758733831000000|1758733831000000 support@linode.com undefined|1755126295000000|1755126295000000 ... ``` Holy sender dates, Batman! Now I can see the earliest and latest email sent by any user. Now I can filter, sort, and see every person who sent me something in a time period. And whether it was 1 email or 1000, I just see the names and not an enormous amount of other information. So, is this the only way to get this? Or the best? I have no idea. Please let me know if there is a better way, perhaps one using TB itself. It would be nice. In the meantime, I will be wrapping this in a python call, doing some formatting and it will work and I can stop worrying about not seeing their email.

Duhet të bëni hyrjen te llogaria juaj që t’i përgjigjeni postimeve. Ju lutemi, filloni me një pyetje të re, nëse nuk keni ende një llogari.