Connected Parameters Not Updating Dynamically When Datetime Value Changes

(2 posts) (2 voices)
  1. cdavison, Member

    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)

    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

  2. myDBR Team, Key Master

    For now the datetime field does not trigger the connected parameter updates. Connected parameters are triggered for now by selectlists and by radio buttons. We'll see if we can address this in the future versions.

    myDBR Team


You must log in to post.