Skip to main content
Question

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

.
Level 4

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

mukesh.gupta11
Level 4
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.

.
Level 4

Sure , Thank you very much . This is helpful

Reply


Community Code of Conduct