We have a custom field called "Process Date"
I want to create a view if the date is on or before "Yesterday" but it doesn't seem to have this option.
The only way i have got this kind of working is to use the within the previous 100 days, but this also adds tickets with process date as today.
Has anyone got any ideas on how i can do this?
Hey Zac,
Have you tried using a Automation/Trigger combination to add a tag to these tickets?
Your Automation would look like this:
Meet ALL Conditions
Ticket: Process date | is within the previous | 2 days
Ticket: Tags | Contains none of the following | process_date_overdue
Action
Ticket: Add tags | process_date_overdueYou would then add the following Trigger to remove this tag if/when the process date is changed to a future date:
Meet ALL Conditions
Ticket | is | Updated
Status | Less than | Solved
Process Date | is within the next | 100 days
Tags | Contains at least one of the following | process_date_overdue
Action
Remove tags | process_date_overdueYou can then make a View that only displays tickets with the process_date_overdue tag.
Would this not result in the same issue?
I want everything this today date to go into my Process | Today view. Where the process date automatically changes every 24 hours.
If a process date is set to any date before "Today" I want it to go overdue.
I want to be able to do something like blow
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
If you're using a custom date ticket field as a View condition, the only values you can come close utilizing are these two :
- Is within the previous
- Is within the next
These conditions are further explained in this article here.