How to select Distinct Values from TABLES in a Value set ? (to be used in system administrator respo

Method 1

Create the VIEW based on DISTINCT values; use the VIEW for creates the VALUESET.

Method 2

Paste the QUERY in TABLE field with alias name, and give the column name (with alias name).

(For an example)

Table : (SELECT DISTINCT PERIOD_NAME FROM GL_PERIODS) GL

Value : GL.PERIOD_NAME

find the attached picture  for more clarification please

- By Khaled Diab -