LOV from Database with SQL hand

[ced62]

Hi,

I need to have a lov from a database object with SQL hand. If somebody have informations ...

ex : where begin_date = @prompt('Choose a date','D',{table.date},mono,constrained)

where table.date is a column of a table

Thanks

 

[Sridharan]

Ced,

I think you mean free Hand SQL. You can't have LOV's with Free Hand SQL only hard coded LOV's and not a dynamic one which picks from the DB Tables. Like I mentioned a lot of times in this forum and other forums try to reduce the Free Hand SQL. Use it only for extreme cases. Still you need to have something for your report if you already have a universe for the purpose then what you can do is select the Universe and change the SQL instead of selecting Free Hand SQL in the first case. If you do that then you are telling the BO to use the Universe but you can change the SQL to have the LOV as per your needs.

Sri