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
0 comments: