2 Replies Latest reply: Jan 27, 2013 2:11 AM by Ramani_apex RSS

    how to serach Decode value in IR report

    Ramani_apex
      I have IR report with
      Select doc_id ,Doc_name,Decode(doc_status,1,'Internal',2,'External') doc_ststus from Document
      when i search in normal search area as Internal or extaernal which is decoded value,
      Its not picking the data.
        • 1. Re: how to serach Decode value in IR report
          Keith Malay
          Hi,

          I tried to reproduce your problem but couldn't. I created an Interactive Report with the following query:
          select object_name,
                   object_type,
                   decode(object_type, 'PACKAGE BODY', 'This is a package body.', 'This is something else.') "remarks"
            from user_objects
           order by 1
          See the example here: http://apex.bhawke.com/apex/f?p=104:7
          user = demo
          pass = demo

          When you search for text in the "decode" column (Remarks) it works ok.

          Let me know if I'm missing something.

          Keith
          • 2. Re: how to serach Decode value in IR report
            Ramani_apex
            Thank you Keith Malay.its working fine ..by the way your sample application is not working constantly. plz retrieve it could be helpful to some one.