123456789101112131415 |
- COGNOS QUERY
- STRUCTURE,1,1
- DATABASE,O21
- DATASOURCENAME,C:\GAPS\Portal\System\IQD\Serv_Teile\current_date_Service.imr
- TITLE,current_date_Service.imr
- BEGIN SQL
- select distinct (@CURRENT_DATE) as c1,
- T1."STATUS" as c2
- from "deop02"."dbo"."VEH_ORDER_HEADER" T1
- where (T1."STATUS" = '18')
- END SQL
- COLUMN,0,Heute
- COLUMN,1,Status
|