How can we restrict a user to write only numbers in the text fields in obiee 12c reports?

Question

Jerry Casey · Answer

My solution to this is to set a presentation variable in the employee ID prompt, say "varID".
Then, in the filter of the query, insert: UPPER('@{varID}')=LOWER('@{varID}').
In the 'No Results' view, type the custom message "Invalid Employee ID - Numbers Only!"

This only works as a test for unwanted alpha characters, (and maybe only in English?)

3754031 · Answer

And, to keep it simple - i have an Employee ID prompt - which is text field prompt.

I cannot use drop down or choice list as i have millions of employees.

And, employee id values in database are numeric.  (which is good)

However, we have few users - who may enter some string values unknowingly in the text field prompt.

Can we have integrate any customization - so, that when users enter any characters other than numeric it should say - enter only numeric values.

Thomas Dodds · Answer

force the prompt to be a searchable lookup and selection instead of free-form text ... if you have too many values, then you need additional restricting prompts to narrow down the scope of the final list

example:

if you have 600,00 customers maybe you need a City prompt to narrow the search down to 100,000 then you need an additional one to maybe filter by ZIP Code and now you get 30-50,000 in a zip code and then maybe filtering those by sales rep to get the 10-15 to pick from...

free-form is ungoverned (free of any form)...