Filter Cases by due date (today) usingAdvanced filter

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

Hello,

Can anyone tell me how to save a filter, that, when selected, will show open cases for today only?

I know I can manually go in and select the Due Date as Today. I am wondering if there’s a way to save it so the due date always auto-fills today’s date?

Any help would be appreciated.

Thank you

Dan

2

This can’t be done without some custom code.

Where do you want this done? In the generic Cases List view, or perhaps in a sub-panel?

Here is an example of adding a second Cases sub-panel under Accounts, to execute a special SQL query:

https://suitecrm.com/suitecrm/forum/suitecrm-7-0-discussion/19222-subpanels-cases#66668

That query could easily be changed to give you Cases due “today” (with a dynamic “today”)