5 Replies Latest reply on Oct 23, 2013 6:29 PM by andreml

    IR with dynamic pivot

    Denis Kishenko-Oracle

      Hi all

       

      We have been designing resource management system and want to provide flexible way to extend resource properties at runtime. So we are storing resource properties in a single table, e.g.

       

      select * from _kv

      ID K V
      ---- ----- -----
       
      1  name Bob
       
      1  age  30
       
      1  gender male
       
      2  name Susan
       
      2  status married

       

      convert to

      +-----+-------+--------+----------+
      | key | color | height | whatever |
      +-----+-------+--------+----------+
      | 1   | green | 15     | ---      |
      | 2   | ---   | ---    | lol      |
      +-----+-------+--------+----------+

      example of dynamic pivot Dynamic SQL Pivoting – Stealing Anton’s Thunder</title> //<title>AMIS Technology Blog…

       

      Is it possible to create interactive report with dynamic columns updated when _kv will be changed?

      Is it possible to create add/edit dynamic form depends on key set if we add value type description?

       

      Thanks