7 Replies Latest reply: Nov 25, 2013 6:21 PM by scott.wesley RSS

    nvl with select lists

    salute-Salem

      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