[jira] [Created] (JAMES-4176) Retire email_query_view_sent_at

Benoit Tellier created JAMES-4176:
-------------------------------------

             Summary: Retire email_query_view_sent_at
                 Key: JAMES-4176
                 URL: https://issues.apache.org/jira/browse/JAMES-4176
             Project: James Server
          Issue Type: Improvement
          Components: cassandra, JMAP
            Reporter: Benoit Tellier
            Assignee: Antoine Duprat


h3. Why ?

 - JMAP do not propose efficient sorting on sentAt property
 - sentAt is controled by the sender: thi can be used to not display mails by received date and is overall counter intuitive.

All this makes email_query_view_sent_at useless.

We can simplify our cureent code and reclame some tables by retiring (removing) it.

h3. Outcome

percent Cassandra DB size decrease

Email/query would still be served but by OpenSearch index

h3. Alternatives

An alternative is to define JMAP EMailQueryOverrides in a finner grain and compose them (along with their data definition) via module chooser but this looks overall overkill for the problem at hand.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)