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

     [ https://issues.apache.org/jira/browse/JAMES-4176?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Benoit Tellier closed JAMES-4176.
---------------------------------
    Resolution: Fixed

This work is merged.

> 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
>            Priority: Major
>          Time Spent: 1h 20m
>  Remaining Estimate: 0h
>
> 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)