DataSrc:UNITA Data/Indicators/t241unito: Difference between revisions
From UNITApedia
Elie Saade (talk | contribs) No edit summary Tag: Reverted |
Elie Saade (talk | contribs) No edit summary |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{#get_db_data: | |||
db=DW_UNITAData_Mobility | |||
|query=SELECT jsontext FROM public.t241_json LIMIT 1 | |||
|data=raw_blob=jsontext | |||
}} | |||
; Data Verification: | |||
<pre>{{#external_value:raw_blob}}</pre>{{#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 | |||
}} | |||
{{#echarts: | |||
|width=1000px | |||
|height=600px | |||
|option={{#external_value:chart_config}} | |||
}} | |||
{{#get_db_data: | {{#get_db_data: | ||
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)
|option=[{"Academic_year":"2023-2024","Mobility_flux":"Outgoing","Type_of_mobility":"BIP-student mobility for studies","Status_of_mobility_participant":"Student_bachelor","Participants":7,"id":1},{"Academic_year":"2023-2024","Mobility_flux":"Outgoing","Type_of_mobility":"BIP-student mobility for studies","Status_of_mobility_participant":"Student_doctorate","Participants":1,"id":2},{"Academic_year":"2023-2024","Mobility_flux":"Outgoing","Type_of_mobility":"BIP-student mobility for studies","Status_of_mobility_participant":"Student_master","Participants":7,"id":3},{"Academic_year":"2023-2024","Mobility_flux":"Outgoing","Type_of_mobility":"Matching Event (Research, Education etc)","Status_of_mobility_participant":"Staff_academic","Participants":5,"id":4},{"Academic_year":"2023-2024","Mobility_flux":"Outgoing","Type_of_mobility":"other- staff week, workshop, conference, training, internship, research","Status_of_mobility_participant":"Staff_academic","Participants":5,"id":5},{"Academic_year":"2023-2024","Mobility_flux":"Outgoing","Type_of_mobility":"other- staff week, workshop, conference, training, internship, research","Status_of_mobility_participant":"Staff_administrative","Participants":9,"id":6},{"Academic_year":"2023-2024","Mobility_flux":"Outgoing","Type_of_mobility":"other- staff week, workshop, conference, training, internship, research","Status_of_mobility_participant":"Student_doctorate","Participants":1,"id":7},{"Academic_year":"2023-2024","Mobility_flux":"Incoming","Type_of_mobility":"SMS-student mobility for studies","Status_of_mobility_participant":"Student_bachelor","Participants":10,"id":8},{"Academic_year":"2023-2024","Mobility_flux":"Outgoing","Type_of_mobility":"SMS-student mobility for studies","Status_of_mobility_participant":"Student_bachelor","Participants":28,"id":9},{"Academic_year":"2023-2024","Mobility_flux":"Incoming","Type_of_mobility":"SMS-student mobility for studies","Status_of_mobility_participant":"Student_doctorate","Participants":1,"id":10},{"Academic_year":"2023-2024","Mobility_flux":"Incoming","Type_of_mobility":"SMS-student mobility for studies","Status_of_mobility_participant":"Student_master","Participants":9,"id":11},{"Academic_year":"2023-2024","Mobility_flux":"Outgoing","Type_of_mobility":"SMS-student mobility for studies","Status_of_mobility_participant":"Student_master","Participants":41,"id":12},{"Academic_year":"2023-2024","Mobility_flux":"Incoming","Type_of_mobility":"SMT-student mobility for traineeship","Status_of_mobility_participant":"Student_bachelor","Participants":1,"id":13},{"Academic_year":"2023-2024","Mobility_flux":"Outgoing","Type_of_mobility":"SMT-student mobility for traineeship","Status_of_mobility_participant":"Student_master","Participants":3,"id":14},{"Academic_year":"2023-2024","Mobility_flux":"Incoming","Type_of_mobility":"STA-staff mobility for teaching","Status_of_mobility_participant":"Staff","Participants":3,"id":15},{"Academic_year":"2023-2024","Mobility_flux":"Outgoing","Type_of_mobility":"STA-staff mobility for teaching","Status_of_mobility_participant":"Staff_academic","Participants":17,"id":16},{"Academic_year":"2023-2024","Mobility_flux":"Incoming","Type_of_mobility":"STT-staff mobility for training","Status_of_mobility_participant":"Staff","Participants":23,"id":17},{"Academic_year":"2023-2024","Mobility_flux":"Outgoing","Type_of_mobility":"STT-staff mobility for training","Status_of_mobility_participant":"Staff_academic","Participants":36,"id":18},{"Academic_year":"2023-2024","Mobility_flux":"Outgoing","Type_of_mobility":"STT-staff mobility for training","Status_of_mobility_participant":"Staff_administrative","Participants":35,"id":19},{"Academic_year":"2023-2024","Mobility_flux":"Outgoing","Type_of_mobility":"UNITA Week meeting","Status_of_mobility_participant":"Staff_academic","Participants":6,"id":20},{"Academic_year":"2023-2024","Mobility_flux":"Outgoing","Type_of_mobility":"UNITA Week meeting","Status_of_mobility_participant":"Staff_administrative","Participants":3,"id":21},{"Academic_year":"2023-2024","Mobility_flux":"Outgoing","Type_of_mobility":"UNITA Week meeting","Status_of_mobility_participant":"Student Assemby Member","Participants":1,"id":22},{"Academic_year":"2023-2024","Mobility_flux":"Outgoing","Type_of_mobility":"URM-Rural Mobility","Status_of_mobility_participant":"Student_master","Participants":4,"id":23},{"Academic_year":"2023-2024","Mobility_flux":"Outgoing","Type_of_mobility":"UVM-Virtual Mobility","Status_of_mobility_participant":"Student_bachelor","Participants":44,"id":24},{"Academic_year":"2023-2024","Mobility_flux":"Outgoing","Type_of_mobility":"UVM-Virtual Mobility","Status_of_mobility_participant":"Student_doctorate","Participants":3,"id":25},{"Academic_year":"2023-2024","Mobility_flux":"Outgoing","Type_of_mobility":"UVM-Virtual Mobility","Status_of_mobility_participant":"Student_master","Participants":23,"id":26},{"Academic_year":"2023-2024","Mobility_flux":"Outgoing","Type_of_mobility":"Work Package meeting","Status_of_mobility_participant":"Staff_academic","Participants":5,"id":27},{"Academic_year":"2023-2024","Mobility_flux":"Outgoing","Type_of_mobility":"Work Package meeting","Status_of_mobility_participant":"Staff_administrative","Participants":3,"id":28},{"Academic_year":"2024-2025","Mobility_flux":"Outgoing","Type_of_mobility":"BIP-student mobility for studies","Status_of_mobility_participant":"Student_bachelor","Participants":42,"id":29},{"Academic_year":"2024-2025","Mobility_flux":"Outgoing","Type_of_mobility":"BIP-student mobility for studies","Status_of_mobility_participant":"Student_doctorate","Participants":3,"id":30},{"Academic_year":"2024-2025","Mobility_flux":"Outgoing","Type_of_mobility":"BIP-student mobility for studies","Status_of_mobility_participant":"Student_master","Participants":21,"id":31},{"Academic_year":"2024-2025","Mobility_flux":"Outgoing","Type_of_mobility":"other- staff week, workshop, conference, training, internship, research","Status_of_mobility_participant":"Staff_academic","Participants":6,"id":32},{"Academic_year":"2024-2025","Mobility_flux":"Outgoing","Type_of_mobility":"other- staff week, workshop, conference, training, internship, research","Status_of_mobility_participant":"Staff_administrative","Participants":5,"id":33},{"Academic_year":"2024-2025","Mobility_flux":"Outgoing","Type_of_mobility":"other- staff week, workshop, conference, training, internship, research","Status_of_mobility_participant":"Student Assembly Member","Participants":1,"id":34},{"Academic_year":"2024-2025","Mobility_flux":"Outgoing","Type_of_mobility":"other- staff week, workshop, conference, training, internship, research","Status_of_mobility_participant":"Student_bachelor","Participants":1,"id":35},{"Academic_year":"2024-2025","Mobility_flux":"Incoming","Type_of_mobility":"SMS-student mobility for studies","Status_of_mobility_participant":"Student_bachelor","Participants":28,"id":36},{"Academic_year":"2024-2025","Mobility_flux":"Outgoing","Type_of_mobility":"SMS-student mobility for studies","Status_of_mobility_participant":"Student_bachelor","Participants":32,"id":37},{"Academic_year":"2024-2025","Mobility_flux":"Incoming","Type_of_mobility":"SMS-student mobility for studies","Status_of_mobility_participant":"Student_master","Participants":24,"id":38},{"Academic_year":"2024-2025","Mobility_flux":"Outgoing","Type_of_mobility":"SMS-student mobility for studies","Status_of_mobility_participant":"Student_master","Participants":50,"id":39},{"Academic_year":"2024-2025","Mobility_flux":"Outgoing","Type_of_mobility":"SMT-student mobility for traineeship","Status_of_mobility_participant":"Student_bachelor","Participants":1,"id":40},{"Academic_year":"2024-2025","Mobility_flux":"Outgoing","Type_of_mobility":"SMT-student mobility for traineeship","Status_of_mobility_participant":"Student_doctorate","Participants":1,"id":41},{"Academic_year":"2024-2025","Mobility_flux":"Outgoing","Type_of_mobility":"SMT-student mobility for traineeship","Status_of_mobility_participant":"Student_master","Participants":1,"id":42},{"Academic_year":"2024-2025","Mobility_flux":"Incoming","Type_of_mobility":"STA-staff mobility for teaching","Status_of_mobility_participant":"Staff","Participants":4,"id":43},{"Academic_year":"2024-2025","Mobility_flux":"Outgoing","Type_of_mobility":"STA-staff mobility for teaching","Status_of_mobility_participant":"Staff_academic","Participants":13,"id":44},{"Academic_year":"2024-2025","Mobility_flux":"Incoming","Type_of_mobility":"STT-staff mobility for training","Status_of_mobility_participant":"Staff","Participants":45,"id":45},{"Academic_year":"2024-2025","Mobility_flux":"Outgoing","Type_of_mobility":"STT-staff mobility for training","Status_of_mobility_participant":"Staff_academic","Participants":20,"id":46},{"Academic_year":"2024-2025","Mobility_flux":"Outgoing","Type_of_mobility":"STT-staff mobility for training","Status_of_mobility_participant":"Staff_administrative","Participants":15,"id":47},{"Academic_year":"2024-2025","Mobility_flux":"Outgoing","Type_of_mobility":"STT-staff mobility for training","Status_of_mobility_participant":"Student_doctorate","Participants":1,"id":48},{"Academic_year":"2024-2025","Mobility_flux":"Outgoing","Type_of_mobility":"UNITA Week meeting","Status_of_mobility_participant":"Staff_academic","Participants":4,"id":49},{"Academic_year":"2024-2025","Mobility_flux":"Outgoing","Type_of_mobility":"UNITA Week meeting","Status_of_mobility_participant":"Staff_administrative","Participants":2,"id":50},{"Academic_year":"2024-2025","Mobility_flux":"Outgoing","Type_of_mobility":"URM-Rural Mobility","Status_of_mobility_participant":"Student_master","Participants":3,"id":51},{"Academic_year":"2024-2025","Mobility_flux":"Outgoing","Type_of_mobility":"UVM-Virtual Mobility","Status_of_mobility_participant":"Student_bachelor","Participants":51,"id":52},{"Academic_year":"2024-2025","Mobility_flux":"Outgoing","Type_of_mobility":"UVM-Virtual Mobility","Status_of_mobility_participant":"Student_doctorate","Participants":2,"id":53},{"Academic_year":"2024-2025","Mobility_flux":"Outgoing","Type_of_mobility":"UVM-Virtual Mobility","Status_of_mobility_participant":"Student_master","Participants":4,"id":54}]