DataSrc:UNITA Data/Indicators/t241unito

{{#get_db_data: db=DW_UNITAData_Mobility |query=SELECT jsontext FROM public.t241_json LIMIT 1 |data=raw_blob=jsontext }}

Data Verification

{{#external_value:raw_blob}}

{{#get_db_data:

db=DW_UNITAData_Mobility |query=SELECT 1 as test_val |data=test=test_val }} DB CONNECTION STATUS: {{#external_value:test}} (Should say 1) {{#get_db_data: db=DW_UNITAData_Mobility |query=SELECT jsontext FROM your_table_name WHERE university = 'UNITO' LIMIT 1 |data=chart_config=jsontext }}

|option={{#external_value:chart_config}}

{{#get_db_data: db=DW_UNITAData_Mobility_T241Unito_sum |data=id=id,

     type_of_mobility=type_of_mobility,
     status_of_mobility_participant=status_of_mobility_participant,
     academic_year=academic_year,
     participants=participants,
     mobility_flux=mobility_flux

}}