Home » Fusion Middleware & Colab Suite » WebCenter Suite & Portal » Wrong Data Pulled
Wrong Data Pulled [message #196232] Wed, 04 October 2006 10:16
deongee
Messages: 8
Registered: October 2006
Junior Member
This code works except it's not pulling the data for call_date3, how can I get the data that's stored in this field?


select to_char (call_date, 'MM-DD-YYYY') call_date2, call_num, clientname, dept_code, staff_id, status, decode (trunc(sysdate) - trunc(to_date (call_date)), 3,'<font color=red><b>' || call_date || '</b></font>' , 5, '<font color=blue><b>' || call_date || '</b></font>', '<font color=pink><b>' || call_date || '</b></font>') call_date3
from hd_call
where call_date between '01-May-06' and '02-May-07'
and staff_id = decode ('##Param1##', 'ALL', staff_id, '##Param1##')
and status = decode ('##Param2##', 'ALL', status, '##Param2##') 
and dept_code = decode ('##Param3##', 'ALL', dept_code, '##Param3##')
and not ('##Param1##' = 'ALL' and '##Param2##' = 'ALL' and '##Param3##' = 'ALL' )

[Updated on: Wed, 04 October 2006 10:18]

Report message to a moderator

Previous Topic: Drop Down Box - Default Values
Next Topic: Log on to Portal
Goto Forum:
  


Current Time: Thu Mar 28 05:32:44 CDT 2024