I’m facing an issue with updating the list of hospitals based on the selected city.
I have a list of variables such as Hospitals, City, Country.
City variable is able to refresh and get data upon Country selection,
City Variable Query:
Select city from CityZone where Country = ‘${country}’
Iam Try to get the Hospital Data using some View in SQL SERVER, from respective City Database.i.e we have City wise databases.
Select Hospitals from ${City}.[dbo].[View_getHospitalInfo]
ISSUE: My list of Hospitals is not updating , based on city selection, It is giving the previous data.
Iam Doubting on some Cache issue setting, I would like to hear if iam missing any.