Public Interface Export Function › Internal Design Objects › Access and Connection Objects › FLD_ENTPT_VALUE (Field Entry Point Value) › Task

Task

Select all the limit values for a partitioned entry point.

SELECT EP.NAME, FIELD.NAME, EPF.SEQ, VAL.VALUE
  FROM
  MODEL M,
  ENTRY_POINT EP,
  FLD_ENTRY_PT_USE EPF,
  FIELD FLD,
  FLD_ENTPT_VALUE VAL
  WHERE
  M.NAME = 'my model name'
  AND EP.ID = M.ID
  AND EP.PARTITIONED = 'Y'
  AND EPF.ENTRY_POINT_ID = EP.ID
  AND EPF.FIELD_ID = FLD.ID
  AND VAL.FLD_ENTPT_US_ID = EPF.ID
ORDER BY EP.NAME, EPF.SEQ;