Feature Request: Enhanced EmailMessage QuerySet Filtering

[MohmdFo]

Description

First, I'd like to express my appreciation for this incredible package! It has streamlined email management and improved our workflows significantly. The well-structured models and filtering capabilities have been particularly useful.

As a contribution, I'd like to propose a new feature to enhance the functionality of filtering the EmailMessage queryset, allowing developers to perform more complex searches with a unified approach.

Feature Proposal

Proposed Functionality:
The addition of a "heavy search" filter that allows developers to:

1. Perform full-text searches (leveraging SearchVector and SearchQuery for PostgreSQL).
2. Conduct substring searches (case-insensitive and applicable across database backends).
3. Utilize trigram similarity search for approximate matching (where supported, such as PostgreSQL).

This filter combines multiple strategies to search across fields like subject, plain_body, and html_body for a comprehensive search experience.

Benefits

• A unified search mechanism, adaptable to multiple database backends.
• Enhanced user experience by allowing fallback searches when full-text or similarity searches are unavailable.
• Simplified API for developers to integrate complex search functionalities seamlessly.

Example Use Case

from sage_mailbox.models import EmailMessage
from sage_mailbox.filters import MailboxMessageFilter

email_queryset = EmailMessage.objects.all()
filterset = MailboxMessageFilter(
    {"search": "invoice payment due"}, queryset=email_queryset
)

results = filterset.qs  # Returns queryset filtered using the proposed "heavy search."

Next Steps

If this enhancement aligns with the package's roadmap, I would love to submit a pull request for this feature. Please assign this issue to me, and I'll ensure the feature is implemented with appropriate documentation and test coverage.

Thank you for considering this proposal, and I look forward to your feedback! 😊