Skip to main content
Question

How can I add a button where the user clicks and it filters the cases based on the following query??

  • June 26, 2022
  • 4 replies
  • 19 views

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

4 replies

muthappan.alaga
Level 8
Forum|alt.badge.img+1

Hi Guilherme,

 

Are you using view or analysis?

 

Thanks

Muthappan


Hi Guilherme,

 

Are you using view or analysis?

 

Thanks

Muthappan

Hi Muthappan,

 

I'm using analysis.

 

Tks,

Guilherme


muthappan.alaga
Level 8
Forum|alt.badge.img+1

Save these filters as bookmarks and there is an option for button on lick action to Load bookmarks.


ward.brand
Level 3
Forum|alt.badge.img+7
  • Level 3
  • June 28, 2022

Save these filters as bookmarks and there is an option for button on lick action to Load bookmarks.

Hi Muthappan,

I'm facing a similar issue, but I don't know how to add the bookmark with the required filters. Do you know how to do this? (the filters I require are not present in the dashboard)

Thanks, Ward