1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

To find Expression Names in Discoverer Reports

Discussion in 'Other Development Tools' started by malli_18arjun, Aug 5, 2009.

  1. malli_18arjun

    malli_18arjun Active Member

    Messages:
    36
    Likes Received:
    3
    Trophy Points:
    110
    Location:
    Hyderabad
    To find Expression Names in Discoverer Reports

    By using this query ,Expressions defined for object can be queried

    Code (SQL):

    SELECT   a.exp_name, b.obj_name, a.exp_formula1, c.fun_name
        FROM eul4_us.eul4_expressions a JOIN eul4_us.eul4_objs b
             ON b.obj_id = a.it_obj_id
             JOIN eul4_us.eul4_functions c
             ON c.fun_id =
                  SUBSTR (a.exp_formula1,
                          INSTR (a.exp_formula1, ',') + 1,
                          INSTR (a.exp_formula1, ']') - 4
                         )
       WHERE SUBSTR (a.exp_formula1,
                     INSTR (a.exp_formula1, '[') + 1,
                     INSTR (a.exp_formula1, ',') - 2
                    ) = '1'
    ORDER BY b.obj_name