Can you program Lobby parameters to have dropdown sections?

Can you program Lobby Parameters have dropdown selections?  Our Managers would like the ability to select the Sales team instead of typing the name.

 

Unfortunately it is not possible to assign dropdown selections on lobby parameters yet, would be great if you could use a custom enumeration to define it for instance, but will have to wait and see how it will evolve.  You can however try to minimise the input characters and the format of the data (Upper/Low case) required from the end user.  Let me explain using your example:

To eliminate case sensitive characters convert the parameter input to upper case and compare on database field that also need to be converted to upper case.

To allow parameter to be completed parsley add ‘%’ || to the front of the parameter if you would like to allow in-between comparison and || ‘%’ at the end to allow everything after the comparison.

The example I extracted on Customer_Order but can be modified to your requirements:

Hope that helps for the interim,

Regards Jacques

Thank you Paul, very nicely demonstrated and thanks for your effort on this, everybody can now benefit from it

oh hi Bill! i didn’t realize it was you.

fyi, I was able to design a solution.

I created an IAL hard-coding the values I wanted, and then used the above solution to plug it into my Lobby. Thx for the effort on this one!

select 'Division A' as DIVISION
from DUAL
UNION ALL
select 'Division B' as DIVISION
from DUAL
UNION ALL
select 'Division C' as DIVISION
from DUAL