knadh / listmonk

High performance, self-hosted, newsletter and mailing list manager with a modern dashboard. Single binary app.

https://listmonk.app

GNU Affero General Public License v3.0

14.54k stars 1.33k forks source link

query subscribers by confirmed / unconfirmed #1982

Closed mcgrue closed 1 month ago

mcgrue commented 1 month ago

Problem

I cannot do an advanced query on /admin/subscribers for if a user is confirmed or unconfirmed. I was hoping to be able to do a report on how effective our confirmation campaign was.

I looked at https://listmonk.app/docs/querying-and-segmentation/ and there's no mention of these states?

Preferred Solution

I'd like to be able to query via partial SQL expression to query subscriber attributes the confirmed/unconfirmed flag

mcgrue commented 1 month ago

The information I wanted was on the /admin/lists page.