Function nonSystemMessageCondition

packages/core/src/query/contact-queries.ts:500–503

(db: DatabaseAdapter, messageAlias: string, memberAlias: string)

}

function nonSystemMessageCondition(db: DatabaseAdapter, messageAlias: string, memberAlias: string): string {
  return `(${messageAlias}.type NOT IN (${SYSTEM_MESSAGE_TYPES_SQL})
    AND ${nonSystemMemberIdentityCondition(db, memberAlias)})`
}

function nonSystemMemberIdentityCondition(db: DatabaseAdapter, memberAlias: string): string {
  return `(LOWER(COALESCE(${memberAlias}.platform_id, '')) != 'system'