Support both ID and XID in message lookups

Mark Chaorequested to merge
501150-message-xid into master

What does this MR do and why?

Support both ID and XID in message lookups

Change for_message_xid scope to support message lookup via:

  • message_xid (secure random string)
  • ActiveRecord id

This change improves flexibility when referencing messages across the application, allowing both identifier types to be used interchangeably. We plan to gradually switch to record id lookup, and phase out message_xid.

References

Screenshots or screen recordings

N/A

How to set up and validate locally

MR acceptance checklist

Evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.

Related to #501150 (closed)

Merge request reports