| BIRT report issue using wildcard % with SQL [message #1838949] |
Wed, 10 March 2021 08:38 |
 Eran Carmona
Messages: 1
Registered: March 2021 |
Junior Member |
|
|
we have a report which has a parameter which is passed to SQL query defined in the report as a "like" statement so user can use wildcards in the parameter.
some of the same values return with "no data to display" although there are values in DB matching the parameter. it looked BIRT is treating the values as encoded html string which when decoded is different so query didn't get any results or got wrong results.. %4D% got converted to M%-
seems using wildcard %<text> is not working properly as dynamic input parameter to SQL query and instead user need to input %25<text>
the parameters to the query are with ?
is there any way to check why like %<text>% operation is not propagating properly to SQL input parameter?
Now:
&__report=1378&title=ISE Z SITE HUBREPORT&isGrid=true&reportFileName=ISE_Z_SIDE_HUB_REPORT.rptdesign&isLarge=false&schedulePlay=undefined&scheduleId=undefined&__showtitle=false&__islocale=customerId&customerId=A%&__isdisplay__customerId=A%&__islocale=zSideSite&zSideSite=%A%&__isdisplay__zSideSite=%A%
Previous BIRT version:
&__report=1319&title=ISE_Z_SITE_HUB_REPORT&isGrid=true&reportFileName=ISE_Z_SIDE_HUB_REPORT.rptdesign&isLarge=false&schedulePlay=undefined&scheduleId=undefined&__showtitle=false&__islocale=customerId&customerId=A%25&__isdisplay__customerId=A%25&__islocale=zSideSite&zSideSite=%25A%25&__isdisplay__zSideSite=%25A%25
(different report)
|
|
|
Powered by
FUDForum. Page generated in 0.06278 seconds