This discussion is archived
7 Replies Latest reply: Nov 25, 2013 4:21 PM by scott.wesley RSS

nvl with select lists

newbi_egy Explorer
Currently Being Moderated

latest version of apex on the cloud , and firefox 24 ,

 

 

i have a report and there are some items above it to search with it , these items are of type select lists , but the problem is

when i write

select ........ from ..........

where staff_name = nvl(:p29_staff_name,staff_name) , and run the page successfully and try to search with the staff name list , i get no data found ,

although there are data with this staff name ??

 

this thing happens only with select lists , i have other text fields and the search is doing well with them .

 

 

thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points