You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

List of Values SQL query with multiple columns

Hello - I want to know if it is possible to use a List of Values object (with a Parameter) and select 2 columns in the LOV query, and then display one column for the End User to select, but have another column used in the Data Model SQL.

I want to select two columns from a LOV query, The first column is a Name/Description field, and the other is the Internal Identifier for the record in the table. The user would select the Name/Description column from the LOV query (this will have meaning to them), and then based on that Name column selected, the parameter used in the main Data Model SQL would use the Internal Identifier column to filter the query.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!