I have a user requirement where they want to be able to select multiple values for a single parameter that will act as a filter for a report. The possible values for a parameter can come from almost any master data Oracle eBusiness table. I don't want to just present the user with a LOV where they search down a list selecting what they want. That wouldn't be very practical for selecting part numbers from 1000's of rows. I also want the user to easily see what values they have selected. I thought about providing a button that would navigate to a multi-row form where they could record their values and use those values in the where clause of the SQL for the report, but that is a somewhat complex solution I have never tried before. Just looking for any helpful suggestions on how to do this. I'm working in the latest version 4 of APEX.
I guess I answered my own question after I thought about it. I'll have a post process on the multi-row form page put all the values entered by the user into a single comma-delimited field and reference that in the where clause of my SQL for my report.