DataSrc:UNITA Data/Indicators/t241unito: Difference between revisions

    From UNITApedia
    m (Reverted edits by Elie Saade (talk) to last revision by Antonio De Jesus Menchaca Martinez)
    Tag: Rollback
    No edit summary
     
    (6 intermediate revisions by the same user not shown)
    Line 1: Line 1:
    {{#get_db_data:  
    {{#get_db_data:  
    db=DW_UNITAData_Indicators_T241Unito
    db=DW_UNITAData_Mobility
    |data=id=id,type_of_mobility=type_of_mobility,status_of_mobility_participant=status_of_mobility_participant,entry_date=monthyear,participants=participants
    |query=SELECT jsontext FROM public.t241_json LIMIT 1
    |data=raw_blob=jsontext
    }}
    }}


    {{#store_external_table: DW_UNITAData_Indicators_T241Unito
    ; Data Verification:
    |id={{{id}}}  
    <pre>{{#external_value:raw_blob}}</pre>{{#get_db_data:
    |type_of_mobility={{{type_of_mobility}}}
    db=DW_UNITAData_Mobility
    |status_of_mobility_participant={{{status_of_mobility_participant}}}
    |query=SELECT 1 as test_val
    |entry_date={{{entry_date}}}
    |data=test=test_val
    |participants={{{participants}}}
    }}
    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
    }}
     
    {{#echarts:
    |width=1000px
    |height=600px
    |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
    }}
    }}


    Line 16: Line 38:
    |?type_of_mobility
    |?type_of_mobility
    |?status_of_mobility_participant
    |?status_of_mobility_participant
    |?entry_date
    |?academic_year
    |?participants
    |?participants
    |?mobility_flux
    |class=datatable  
    |class=datatable  
    |format=datatables  
    |format=datatables  

    Latest revision as of 13:24, 4 June 2026


    Data Verification
    {{#external_value:raw_blob}}

    DB CONNECTION STATUS: Error: no local variable "test" has been set. (Should say 1)



    Retrieved from "https://unitapedia.univ-unita.eu/index.php?title=DataSrc:UNITA_Data/Indicators/t241unito&oldid=7878"