Force prompt input to Uppercase in OBIEE 12c

986359

Hi All,

Is there a way in obiee on how to force prompt input values to be always in Uppercase and do a equals to search when it gets passed to report.

Thanks,

Swathi

Robert Angel

If this is free text then no, not without using java script.

Though you could make the prompt populate a variable and then do upper(@{YourVariableNameHere}{DEFAULT_VALUE_HERE) = Your.Columnhere in the analysis that is 'catching' the prompt.

If it is driven by a value list then you could convert the value list to SQL and then put the upper around the column name.

[Deleted User]

+1 to Robert

But I definitely would NOT go for JS hacking even if you find a snippet online but rather capture the value entered in the free text prompt and then apply it in upper case - just make sure you display the filter visually so people know what gets applied.

Robert Angel

Amen!