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.
0