Public Interface Export Function › Design Objects › Screen Design Tool Objects › SCRN_FLD_LIT (Screen Field Literal) › Task

Task

Select all literal fields that appear on a specific screen.

SCRN_FLD_LIT.SCREEN_DEF_ID = SCREEN_DEF.ID

Note: Literals can also be included on screens indirectly through the use of a template. For example, see the next task.

Select all literal fields that appear on a screen.

SELECT PS.NAME, FL.ROW, FL.COL, FL.TEXT
  FROM
  MODEL,
  BUS_PROC_STEP PS,
  SCREEN_DEF SCRN,
  SCRN_FLD_LIT FL
  WHERE
  MODEL.NAME = 'my model name'
  AND PS.MODEL_ID = MODEL.ID
  AND SCRN.BUS_PROC_STEP_ID = PS.ID
  AND FL.SCREEN_DEF_ID = SCRN.ID;