Skip to main content
Question

How to compare the activity time with reference time present in case table ?

  • March 30, 2023
  • 2 replies
  • 11 views

Hi Experts , Lets say i have to compare activity time lets say "Goods Receipt" time which is present in activity table with Expected delivery date which is present in case table. Should i be directly substracting activity time on Olap table and fiter table by activity == "Goods receipt" OR

Is there a good way using PQL ?

 

Thanks - Shaif

2 replies

mukesh.gupta11
Level 7
Forum|alt.badge.img+15

Hello Shaif,

 

Try This, PU_FIRST("CASE TABLE", ACTIVITY_EVENTTIME, ACTIVTY_NAME = 'Goods Receipt') = "CASE TABLE"."DELIVERY DATE TIME" with the case when statment.


  • Author
  • Level 6
  • March 31, 2023

Sure , Thank you very much . This is helpful