Skip to main content
shobhits0002
shobhits0002
April 20, 2023
Solved

To display wait time which is waiting for more than a day.

  • April 20, 2023
  • 6 replies
  • 0 views

Hi All,

To display wait time which is waiting for more than a day.

We are converting createdDate(date time format) in days and hours. 
Now, ask is to display the WAIT TIME only when it is more than 1D 0H.
But, queryFilter field is createdDate(date time format). In that case how can we display this.

Query Filter which I'm using at present  (I know it's not correct), could anyone help me in getting this expression correct.

    Best answer by stefanhelzle0001

    Something like this should do it.

    a!queryFilter(
  field: 'recordType!{95faa2ae-87b5-4ff9-a70d-a308b0d956a4}.{createdAt_date}createdAt_date',
  operator: "<",
  value: a!subtractDateTime(
    startDateTime: now(),
    hours: 10,
    useProcessCalendar: false /* Make this true to respect working time */
  )
)

    6 replies

    stefanhelzle0001
    stefanhelzle0001
    April 20, 2023

    You are writing about various things here. What is your actual question?

    shobhits0002
    shobhits0002Author
    April 20, 2023

    Hi Stefen,
    Sorry for making it complex.
    Actually, I need to display any record which has WAIT TIME greater than 1D 0H from the createdAt_date. 

    stefanhelzle0001
    stefanhelzle0001Answer
    April 20, 2023

    Something like this should do it.

    a!queryFilter(
  field: 'recordType!{95faa2ae-87b5-4ff9-a70d-a308b0d956a4}.{createdAt_date}createdAt_date',
  operator: "<",
  value: a!subtractDateTime(
    startDateTime: now(),
    hours: 10,
    useProcessCalendar: false /* Make this true to respect working time */
  )
)

      Terms & ConditionsAccessibility statement