Resolved RoCSVI Acymailing custom fields Export

Hello,

is there a way to export all Acymailing users with their custom fields, but only those that subscribed to the list id 123?

RO CSVI does not support Acymailing extension. As you mentioned you need to use RO CSVI custom table export but there is no filter option in this export.

I understood I need to use RoCSVI export with custom tables but I'm stuck with the query see attachments. I always get an empty XLSX

Do you see any error on export? Post the export debug log to check. To get the debug log see How to collect debug information? document.

And how to add the filter to export only the subscribed user to a list?

If you want add filter values to export then I suggest you use RO CSVI SQL export. In this export you write your own query to export Acymailing users with list ID you need.