How are you getting the OTS-MAT-4404-F01 value to pass to the named query? From a dropdown or from a data entry by the operator?
Uhm, no. You can't put value parameters inside quoted strings. Try F_NUMBER LIKE CONCAT('%', :num, '%').
Even better would be to include the percent signs in the string parameter before submitting, so your SQL can be just F_NUMBER LIKE :num. It also allows not using a beginning percent sign when possible, as those crush DB performance.
Uggggg... yep. Missed that one. Thanks for setting me straight @pturmel. Now time to slink off to get more coffee.
Hi ,
Please help me with this last issue, now all are set, my query is ready and report also ready.
When I am trying to run report by harcoded values, it is working
below are the parameters,
and in preview we can see the records like this
but I want to pass parameters from screen so I am doing like this
and the parameters looking like
In parameters it is taking ''(single quotes) automatically, and because of that report is not generating I think.
above I am passing values without quotes and its working.
Can you please suggest what will be exact issue.
please help.
Thanks
t