Use subdomain-aware SQL to match findByDomain JPQL logic

Shipped

April 18, 2026 at 7:44 PM UTC

Author

Kamo

Commit

0e56965

Org domain lookup in resendVerification was doing an exact-match query that failed for subdomains stored as child records (e.g. 'api' with parent 'kamocrm.com'). Mirror the **************** JPQL by joining parent domain and matching d.domain || '.' || parent.domain.