Review all item help texts
The business analyst or QA wants to check all the help texts for all items in your apex application – don’t force them to navigate to each page and click on the labels, one by one; instead, give them a spreadsheet to review at their leisure.
Method 1: use the APEX data dictionary viewer
1. Open your application in the APEX application builder
2. Utilities -> Application Express Views
3. Choose APEX Application Page Items
4. Include PAGE_ID, PAGE_NAME, REGION, ITEM_NAME, LABEL, DISPLAY_AS, ITEM_HELP_TEXT
5. Click Filter >
6. Select APPLICATION_ID = <your app id>
7. Select ITEM_HELP_TEXT IS NOT NULL
8. Click Results >
9. Click Download
Method 2: query the data dictionary directly using your tool of choice
select page_id, page_name, region, item_name, label, display_as, item_help_text from apex_application_page_items where application_id = :my_app_id and item_help_text is not null order by page_id, region, display_sequence;