Refresh db or what else?

[ermancio]

Hi. I have a view column that shows dates if they are >= now where now = DateTime(). When I save the document, dates are shown correctly at that time. When the date passed (< now), I need to save the document again (or refresh db) to hide it in the column.

Do you have any solution? Luca

[djay]

Views always as a boolean field index saved at document save. so your idea won’t work.

The best way to implement this I think is to write a custom view catalog search formula.

On 8 Jun 2018, at 4:27 pm, ermancio notifications@github.com wrote:

Hi. I have a view column that shows dates if they are >= now where now = DateTime(). When I save the document, dates are shown correctly at that time. When the date passed (< now), I need to save the document again (or refresh db) to hide it in the column.

Do you have any solution? Luca

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or mute the thread.

[ermancio]

@djay Could you suggest me how to do it?

[djay]

@ermancio I'm not sure. There isn't a search formula on a view, just on a search form. There really needs to be a new formula put into a column to return a catalog criteria so it can handle dynamic filtering like that. @ebrehault

[ebrehault]

I would suggest to replace the view with a Page form containing a computed for display datagrid showing the wanted documents.

[ermancio]

Thank you very much!