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

    From UNITApedia
    No edit summary
    Tag: Reverted
    No edit summary
     
    (9 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:  
    db=DW_UNITAData_Mobility_T241Unito_sum
    db=DW_UNITAData_Mobility_T241Unito_sum
    Line 7: Line 32:
           participants=participants,
           participants=participants,
           mobility_flux=mobility_flux
           mobility_flux=mobility_flux
    }}
    {{#store_external_table: DW_UNITAData_Indicators_T241Unito
    |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 29: Line 45:
    |mainlabel=-  
    |mainlabel=-  
    |header=show
    |header=show
    }}
    {{#echarts:
      width=1000px
      |height=600px
      |option={
        "title": { "text": "Mobility Participants by Year" },
        "tooltip": { "trigger": "axis" },
        "legend": { "data": ["Participants"] },
        "xAxis": {
          "type": "category",
          "data": [{{#ask: [[-Has subobject::{{FULLPAGENAME}}]] |?academic_year= |format=list |sep=, |link=none}}]
        },
        "yAxis": { "type": "value" },
        "series": [{
          "name": "Participants",
          "type": "bar",
          "data": [{{#ask: [[-Has subobject::{{FULLPAGENAME}}]] |?participants= |format=list |sep=, |link=none}}]
        }]
      }
    }}
    }}

    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"