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