Hi all,
I want to add a button where the user clicks and it filters the cases based on the following conditions. What's the best way of doing it?
FILTER PROCESS EQUALS 'IC SB Purchase Order Created';
FILTER PROCESS EQUALS 'IC SB Billing Created';
FILTER PROCESS EQUALS 'IC SB Invoice Receipt';
FILTER DAYS_BETWEEN(
PU_LAST(
"EKPO",
Round_Day("ACTIVITIES"."DATE1"),
"ACTIVITIES"."ACTIVITY_EN" = 'IC SB Billing Created'
),
PU_FIRST(
"EKPO",
Round_Day("ACTIVITIES"."EVENTTIME"),
"ACTIVITIES"."ACTIVITY_EN" = 'IC SB Invoice Receipt'
)
) > 30;
Thank you.
Guilherme Luz