Forum Stats

  • 3,837,476 Users
  • 2,262,262 Discussions


How to add pl sql query into help text of an item.

Eva E
Eva E Member Posts: 42
edited Sep 11, 2013 6:42PM in APEX Discussions


In my database i have added comments to the colums. I would like to use this comments in the help text of the items of my application. I have the query but when I use it in the help text attribute it does not execute the query, it presents the query.

Any ideas?



  • Jeff E
    Jeff E Member Posts: 723 Bronze Trophy

    Not very elegant but one idea would be to create a hidden page item, use your query in a item computation, and then use the ampersand-item-period notation in the help text attribute. i.e. &P1_ITEM1_HELP.

  • Eva E
    Eva E Member Posts: 42

    Thanks but it does not work for me because my form has a more than 50 items and i should have to create 50 hidden items in order to do this.

  • fac586
    fac586 Senior Technical Architect Member Posts: 21,095 Red Diamond

    It is probably too late now, but note that if you create your application using the Create Application Wizard and Application Models, based on User Interface Defaults created in the SQL Workshop, any column comments will automatically become application help text.

This discussion has been closed.