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

    From UNITApedia
    No edit summary
    No edit summary
     
    (4 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",
    {{#get_db_data:  
        "data": [ {{#for_external_table: , | "{{{record.Academic_year}}}" }} ]
    db=DW_UNITAData_Mobility_T241Unito_sum
      },
    |data=id=id,
      "yAxis": { "type": "value" },
          type_of_mobility=type_of_mobility,
      "series": [{
          status_of_mobility_participant=status_of_mobility_participant,
        "name": "Participants",
          academic_year=academic_year,
        "type": "bar",
          participants=participants,
        "data": [ {{#for_external_table: , | {{{record.Participants}}} }} ]
          mobility_flux=mobility_flux
      }]
    }}
    }
     
    {{#ask: [[-Has subobject::{{FULLPAGENAME}}]]
    |?id
    |?type_of_mobility
    |?status_of_mobility_participant
    |?academic_year
    |?participants
    |?mobility_flux
    |class=datatable
    |format=datatables
    |mainlabel=-
    |header=show
    }}
    }}

    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"