For JDBC source, Command object not recognizing '(' character
I am trying to create a crystal report from a JDBC source query (which is actually pointing to Clearquest Oracle database). The query accepts a parameter to filter down data.
Issue I have is when I try to pass a parameter in the command object used for defining the Data Source (See attached screenshot), somehow the parsing ignores anything entered beyond the open bracket character - '('.
In the example screenshot attached, notice how everything I have entered beyond ( is ignored totally in the error message.
I somehow need to find a way to pass this parameter & for that I need the system to understand the ( character.
Any help is appreciated.