Removed QUERY_DEFAULT_CELL_VALUE, instead added has_long_period_of_inactivity (boolean) column to query.
If false, last activity date moment and the difference between this date and render date diff_from_last_activity_to_render_date is returned (diff_to_previous is set to NULL in this case).
If diff_from_last_activity_to_render_date exceeds 180 days, the certificate renders as expired;
if it doesn't exceed 180 days, the certificate is still valid.
If true, account has 180-day-inactivity after issue date (this query only shows inactivity periods over 180 days from receipts) (diff_from_last_activity_to_render_date is set to NULL in this case).
Removed
QUERY_DEFAULT_CELL_VALUE
, instead addedhas_long_period_of_inactivity
(boolean) column to query.If false, last activity date
moment
and the difference between this date and render datediff_from_last_activity_to_render_date
is returned (diff_to_previous
is set to NULL in this case).If
diff_from_last_activity_to_render_date
exceeds 180 days, the certificate renders as expired;if it doesn't exceed 180 days, the certificate is still valid.
If true, account has 180-day-inactivity after issue date (this query only shows inactivity periods over 180 days from receipts) (
diff_from_last_activity_to_render_date
is set to NULL in this case).