New

Date Filter - Give the possibility to use "older then xxx days/weeks/months/years"

With the data archiver feature, I am getting more and more feedbacks from customer who were expecting the hability to clean data according to the last time the record was modified.

For instance, I want to clean Notes that where not modified since 2 years.

Currently, it can't be done. They have to set a specific date, and move it each time they want to clean

Frédéric Rinaldi
Parents

  • In the current data archiver you can only use the existing datetime widgets from Sugar.

    To add an additional filter handling like "older than x days" or "older than x years" you need a very expensive extension of the existimg dattime filter handling.

    But, as always in Sugar there are diffent ways to Rome (in Italy not US).

    The data archiver is implemented in the API module .../modules/DataArchiver/clinets/base/api/DataArchiverAPI.php.

    This module is customizable.

    So, if you create a custom extension which e.g.checks the name of the data archiver record and if this name is sth. like "#2yearsold" it could create the filter on the fly in your custom data archiver API coe. For that you only need an internal convention how to use it and yes, it's quick and dirty but it should be cheap and reliable also.

Comment

  • In the current data archiver you can only use the existing datetime widgets from Sugar.

    To add an additional filter handling like "older than x days" or "older than x years" you need a very expensive extension of the existimg dattime filter handling.

    But, as always in Sugar there are diffent ways to Rome (in Italy not US).

    The data archiver is implemented in the API module .../modules/DataArchiver/clinets/base/api/DataArchiverAPI.php.

    This module is customizable.

    So, if you create a custom extension which e.g.checks the name of the data archiver record and if this name is sth. like "#2yearsold" it could create the filter on the fly in your custom data archiver API coe. For that you only need an internal convention how to use it and yes, it's quick and dirty but it should be cheap and reliable also.

Children
No Data