Home/Questions/Q 4736
Answered
SM Hasem
SM Hasem

SM Hasem

  • Dhaka, Bangladesh
View Profile
  • 0
Contributor
Asked: 2021-01-26T16:27:01+05:30

How to insert item data with default IG in IG table?

  • 0

I have one item with default Interactive Grid. I want to insert item value with default Interactive Grid. Is it Posible? How?

question

    2 Answers

    1. goto150

      goto150

      • Wroclaw, Poland
      View Profile
      Best Answer
      Professional

      Let say you have a page, page item P_ITEM and Interactive Grid having column DEPENDANT.

      Depending on what you want to achieve you may either set a default source(1) for this column or default value in case of new row(2).

      Expand columns of your interactive grid end click on the column name you whish to modify, follow either option 1 or 2.

      1. Default Source (page item is source for the column)
        1.  Go to Source:
          1. Type = SQL expression
          2. SQL Expression = :P_ITEM
      2. Default new entry (page item is default entry for new items)
        1. Go to Default:
          1. Type = Expression
          2. PL/SQL Expression = :P_ITEM

       

      • 2

    You must login to add an answer.