Skip to main content



      Home
Home » Archived » BIRT » BIRT report issue using wildcard % with SQL(BIRT report issue using wildcard % with SQL)
BIRT report issue using wildcard % with SQL [message #1838949] Wed, 10 March 2021 03:38
Eclipse UserFriend
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)
Previous Topic:BIRT: Combining results from two tables or cubes
Next Topic:Help with Eclipse/BIRT install
Goto Forum:
  


Current Time: Fri Apr 04 00:32:05 EDT 2025

Powered by FUDForum. Page generated in 0.03357 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top