SUBSTRING & DESCRIPTOR_IDOF Conditions in OTBI

Summary

SUBSTRING & DESCRIPTOR_IDOF Conditions in OTBI

Content

Hi All,

Can some one explain to me that how does the below conditions work and what's the in detail meaning of them in OTBI?

1)  (SUBSTRING(CAST(MAX("Worker"."Employee Hire Date") AS CHAR) FROM 6 FOR 10)) 
BETWEEN 
(SUBSTRING(CAST(CURRENT_DATE AS CHAR) FROM 6 FOR 10)) AND (SUBSTRING(CAST((TIMESTAMPADD(SQL_TSI_DAY,14,CURRENT_DATE)) AS CHAR) FROM 6 FOR 10))

 

2)   DESCRIPTOR_IDOF("Workforce Management - Worker Assignment Event Real Time"."Worker"."Assignment Status") IN ( 6, 5)

 

Thanks,

Mahendra.

Version

20B