current_date_Service.iqd 329 B

123456789101112131415
  1. COGNOS QUERY
  2. STRUCTURE,1,1
  3. DATABASE,O21
  4. DATASOURCENAME,C:\GAPS\Portal\System\IQD\Serv_Teile\current_date_Service.imr
  5. TITLE,current_date_Service.imr
  6. BEGIN SQL
  7. select distinct (@CURRENT_DATE) as c1,
  8. T1."STATUS" as c2
  9. from "deop02"."dbo"."VEH_ORDER_HEADER" T1
  10. where (T1."STATUS" = '18')
  11. END SQL
  12. COLUMN,0,Heute
  13. COLUMN,1,Status