7 Replies Latest reply: Nov 25, 2013 6:21 PM by swesley_perth RSS

    nvl with select lists


      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 .