Is there a way to find out when a user subscribed to a list
Hi, We need to find out when a specific user joined a list. Is there a way to get this information?
Thanks!
You can query the mailman database ...
select email, registered_on,verified_on from mailman.public.address where email = 'mmasoudf@aaas.org'
On 2024-04-18 03:19, Mohsen Masoudfar wrote:
Hi, We need to find out when a specific user joined a list. Is there a way to get this information?
Thanks!
Mailman-users mailing list -- mailman-users@mailman3.org To unsubscribe send an email to mailman-users-leave@mailman3.org https://lists.mailman3.org/mailman3/lists/mailman-users.mailman3.org/ Archived at: https://lists.mailman3.org/archives/list/mailman-users@mailman3.org/message/...
This message sent to imark@posteo.net
On 4/17/24 15:14, Mark wrote:
You can query the mailman database ...
select email, registered_on,verified_on from mailman.public.address where email = 'mmasoudf@aaas.org'
On 2024-04-18 03:19, Mohsen Masoudfar wrote:
Hi, We need to find out when a specific user joined a list. Is there a way to get this information?
Querying the database in that way is not reliable. Yes, it is correct that the user has both a user record and an address record, and the user record has a created_on date and the address record has both registered_on and verified_on dates, but those are only the creation/verification dates for those records. They are not necessarily the date that that user/address subscribed to any list.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
participants (3)
-
Mark -
Mark Sapiro -
Mohsen Masoudfar