Page History

...

SQL

noDataMessage	No Records Found!
columnLabel	true
columnTypes	S,FC"$0.00",F"$0.00",F"$0.00",F"$0.00"
disableAntiXss	true
width	100%	columnAttributes	style="background:#f2f2f2;text-align:center;font-weight:bold",,,,
dataSource	ManufacturerDS

SELECT '<a href="http://confluence.dev.ultimate.net.au:8090/display/HELP/Eclipse+Client+Detail?run_1=run&run_1_EffDate=' + CONVERT( VARCHAR(10), [eff_date], 23) + ' " target="_blank">' + CONVERT( VARCHAR(10), [eff_date], 103)+ '</a>' AS [CTP Fees Effective Date]
FROM [CTP_qld_import_history]
WHERE eff_date > '01/01/2019'
GROUP BY [eff_date]
ORDER BY [eff_date] DESC

Run with a user form and parameters

autoRun	true
inputSize	100
replace	EffDate:2021-07-01:Effective Date:select::2021-07-01:July 2021:2021-04-01:April 2021::
width	500
titleRun	Update Displayed Fees

CTP Fees Effective from: $EffDate

ITCE 12 Month Rates

No Records Found!trueS,FC"$0.00",F"$0.00",F"$0.00",F"$0.00"true100%style="background:#f2f2f2;text-align:center;font-weight:bold",,,,ManufacturerDSINLINE