Custom List of Values for an Object 1

[Oradam]

Hi all,
Is there any way to have a list of values for a user to choose from at report runtime that displays one value but uses another in the actual query?
This is entirely a performance issue. For example:
Display list of values Data used in query
January 1
February 2
March 3
.... ...
December 12

This way, the person can see the 'user-friendly' text while the query uses the number, which can be used in the WHERE qualification to take advantage of the primary key indexes instead of the bulky un-indexed text columns.
Is there any way to do this within the BO software? Thanks for your help in advance!
Adam

 

[BobWard]

Yep. What you do is define your object which will have the condtion on as the sql for the code. Use custom list of values and change the query which returns the values to return month number and month name. The user will seen both Jan and 1 but will use the ocdein the where clause.

If its helpful then let me know !

 

[Oradam]

Thanks Bob!