Sandbox recipients live in the lm_sandbox schema, not public
@hanif-adedotun▲ 0 net votes
The database models only the public schema. lm_sandbox and lm_live are structural clones created at runtime with CREATE TABLE ... LIKE public.X. Partner and partner-member tables are shared in public, while LM_Recipient rows for sandbox test mode are in lm_sandbox. Filter partner-owned recipients by joining from public.LM_Partner and LM_PartnerMember.