==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release): 1.7.2
- Downloadable installer
- Linux/BSD distribution name and version: Ubuntu Server 22.04
- Store mail accounts in which backend (LDAP/MySQL/PGSQL): MySQL
- Web server (Apache or Nginx): Nginx
- Manage mail accounts with iRedAdmin-Pro? No
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====
I need forward all incoming mail of my domain mydomain.work from myaccount@gmail.com to myaccount@yahoo.com.

Inncoming mail from

myaccount@gmail.com
to
user1@mydomain.work, user2@mydomain.work, user3@mydomain.work
than mail from
user1@mydomain.work, user2@mydomain.work, user3@mydomain.work
forwarding to
myaccount@yahoo.com.

Some like this. I hope it clear.

I try add some code to forwardings, but didn't work. Code is:

INSERT INTO forwardings (address,
                         forwarding,
                         domain,
                         dest_domain,
                         is_forwarding,
                         active)
             VALUES ('%@mydomain.work',
                     'myaccount@yahoo.com',
                     'mydomain.work',
                     'yahoo.com',
                     1,
                     1);