Wednesday, March 16, 2011

How to get the Distinct Values in TABLE Value set?

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

3 comments:

  1. Yes.. it worked for me..thanks..

    ReplyDelete
  2. if i need to add multiple columns in the above query, can i do that and will it be displayed?

    ReplyDelete