Fixed the issue of blanks on current regimen and last date of pickup.
The fix is simply changing inner join to the left join on the codeset for the subquery.
The other fix will be an update script to be executed directly on the database
update hiv_regimen set regimen_type_id=1, active=false where id=40;
update hiv_regimen set regimen_type_id=2, active=false where id=41;
Fixed the issue of blanks on current regimen and last date of pickup. The fix is simply changing inner join to the left join on the codeset for the subquery.
The other fix will be an update script to be executed directly on the database update hiv_regimen set regimen_type_id=1, active=false where id=40; update hiv_regimen set regimen_type_id=2, active=false where id=41;