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

    From UNITApedia
    No edit summary
    Tag: Reverted
    No edit summary
     
    (7 intermediate revisions by the same user not shown)
    Line 1: Line 1:
    {{#get_db_data:  
    {{#get_db_data:  
    db=DW_UNITAData_Mobility
    db=DW_UNITAData_Mobility
    |query=SELECT jsontext FROM your_json_table WHERE university = 'UNITO'
    |query=SELECT jsontext FROM public.t241_json LIMIT 1
    |data=record=jsontext
    |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:  
    {{#echarts:  
    |width=1000px|height=600px
    |width=1000px
    |option={
    |height=600px
      "title": { "text": "Mobility Participants by Year (UNITO)" },
    |option={{#external_value:chart_config}}
      "tooltip": { "trigger": "axis" },
      "xAxis": {
        "type": "category",
        "data": [ {{#for_external_table: , | "{{{Academic_year}}}" }} ]
      },
      "yAxis": { "type": "value" },
      "series": [{
        "name": "Participants",
        "type": "bar",
        "data": [ {{#for_external_table: , | {{{Participants}}} }} ]
      }]
    }
    }}
    }}


    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"