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.
Discussion posts and replies are publicly visible
You are writing about various things here. What is your actual question?
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.
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 */ ) )
Hi Stefan,Thanks for this solution, but this is not working for my scenario.
I made it like this - a!queryFilter( field: 'recordType!{39912480-f504-4c6a-b988-5e3267682493}.fields.{createdDate_date}createdDate_date', operator: "<", value: a!subtractDateTime( startDateTime: 'recordType!{39912480-f504-4c6a-b988-5e3267682493}.fields.{createdDate_date}createdDate_date', hours: 10, useProcessCalendar: false /* Make this true to respect working time */ )
It's giving expression evalulaion error:
Expression evaluation error at function a!gridField [line 701]: Expression evaluation error at function a!queryFilter [line 722]: Could not cast from Record Field to Date and Time for the startDateTime parameter.
There is a reason I wrote "now()" for the startDateTime parameter. Why did you change this?
Hi Stefan,
Thanks for the help. The solution really worked. My bad. I thought of passing the createdDate_date here. Since we are subtracting so, should be now. Thanks again.