I am having issues with a connected parameter not dynamically updating when a datetime parameter is changed. I have three values that are used for calculating the last connected parameter box. When I select the car model, the software versions are updated dynamically. However, if I change the start/end dates after the model has been selected, the software version box will not dynamically update. In order to dynamically update it, I have to uncheck/check a car model. Is there any way for datetime to work dynamically for a parameter selection?
My code is below:
Actual Report Procedure and inputs:
DROP PROCEDURE IF EXISTS sp_DBR_software_select
$$
CREATE PROCEDURE `sp_DBR_software_select`(in BrandName text, in Models text, in StartDate datetime, in EndDate datetime, in SoftwareSelect text)
BEGIN END
$$
Select Vehicle Type Checkbox Parameter:
DROP PROCEDURE IF EXISTS sp_DBR_select_vehicle_types
$$
CREATE PROCEDURE `sp_DBR_select_vehicle_types`(mydbr_param_prev1 text)
BEGIN select Id, Model
from ahsgateway.test_models as m join ahsgateway.test_brands as b on m.`Brand` = b.`Name`
where b.`Name` = mydbr_param_prev1
order by Name; END
$$
Select Software Versions Checkbox Parameter:
DROP PROCEDURE IF EXISTS sp_DBR_software_select_versions
$$
CREATE PROCEDURE `sp_DBR_software_select_versions`(mydbr_param2 text, mydbr_param3 text, mydbr_param4 text)
BEGIN SELECT distinct SW_Version
FROM ahsgateway.test_production_software
join ahsgateway.test_models as m using(`Id`)
where find_in_set(m.`Id`,mydbr_param2)
and Date > mydbr_param3
and Date < mydbr_param4
order by Date asc; END
$$
