Using value in list of values as applet search spec
Hi,
I'm trying to use a value in the list of values as a search spec for an applet in order to easily be able to adjust it.
I found the LookupName function and I am trying to do it like this:
Applet search spec: LookupName("SRCH_SPEC", "SPEC")
List of value entry:
Type: SRCH_SPEC
Display Value: SPEC
Language Independent Code: [Organizational Visibility] = "EXP"
where Organizational Visibility is a field on the business component of the applet.
When I try to access the applet the error "ORA-00920: invalid relational operator" is thrown. Will this not work? Is there any other way of achieving the same?