InfoLink PROMPTS with Modified SQL

I have an InfoLink that uses highly complex custom SQL.  I am not allowed to create a view in the DB, so the modified SQL is necessary.

I'd also like to include Prompts to limit the data returned by the query, but they produce errors when using the modified SQL.

I tried also using a parameter in the SQL, but it doesn't give the user a list of values from which to pick.

Any ideas would be very much appreciated!

(1) Answer