DataSrc:T241: Difference between revisions

    From UNITApedia
    No edit summary
    No edit summary
    Line 43: Line 43:
    }
    }
    }}
    }}
    {{#vardefine: rawData |
    [
      ["Type of mobility", "Student bachelor", "Student master", "Student doctorate"],
      ["BIP-student mobility for studies",
        {{#sum: {{#ask:
          [[-Has subobject::DataSrc:T241]]
          [[type_of_mobility::BIP-student mobility for studies]]
          [[status_of_mobility_participant::Student bachelor]]
          |?participants
          |format=count  <!-- If participants are stored as numbers, #sum may work directly -->
        }} }},
        {{#sum: {{#ask:
          [[-Has subobject::DataSrc:T241]]
          [[type_of_mobility::BIP-student mobility for studies]]
          [[status_of_mobility_participant::Student master]]
          |?participants
          |format=count
        }} }},
        {{#sum: {{#ask:
          [[-Has subobject::DataSrc:T241]]
          [[type_of_mobility::BIP-student mobility for studies]]
          [[status_of_mobility_participant::Student doctorate]]
          |?participants
          |format=count
        }} }}
      ],
      ["Governance Board meeting",
        {{#sum: {{#ask:
          [[-Has subobject::DataSrc:T241]]
          [[type_of_mobility::Governance Board meeting]]
          [[status_of_mobility_participant::Staff academic]]
          |?participants
          |format=count
        }} }},
        0,
        0
      ],
      ["Matching Event (Research, Education etc)",
        {{#sum: {{#ask:
          [[-Has subobject::DataSrc:T241]]
          [[type_of_mobility::Matching Event (Research, Education etc)]]
          [[status_of_mobility_participant::Researcher]]
          |?participants
          |format=count
        }} }},
        {{#sum: {{#ask:
          [[-Has subobject::DataSrc:T241]]
          [[type_of_mobility::Matching Event (Research, Education etc)]]
          [[status_of_mobility_participant::Staff academic]]
          |?participants
          |format=count
        }} }},
        0
      ],
      ["Other- staff week, workshop, conference, training, internship, research",
        {{#sum: {{#ask:
          [[-Has subobject::DataSrc:T241]]
          [[type_of_mobility::Other- staff week, workshop, conference, training, internship, research]]
          [[status_of_mobility_participant::Student bachelor]]
          |?participants
          |format=count
        }} }},
        {{#sum: {{#ask:
          [[-Has subobject::DataSrc:T241]]
          [[type_of_mobility::Other- staff week, workshop, conference, training, internship, research]]
          [[status_of_mobility_participant::Student master]]
          |?participants
          |format=count
        }} }},
        {{#sum: {{#ask:
          [[-Has subobject::DataSrc:T241]]
          [[type_of_mobility::Other- staff week, workshop, conference, training, internship, research]]
          [[status_of_mobility_participant::Student doctorate]]
          |?participants
          |format=count
        }} }}
      ]
    ]
    }}
    {{#var:rawData}}

    Revision as of 14:41, 20 March 2025

    {{#get_db_data: db=DW_UNITAData_T241 |data=id=id,university_of_origin=university_of_origin,type_of_mobility=type_of_mobility,status_of_mobility_participant=status_of_mobility_participant,participants=participants }}

    {{#store_external_table: DW_UNITAData_T241 |id={{{id}}} |university_of_origin={{{university_of_origin}}} |type_of_mobility={{{type_of_mobility}}} |status_of_mobility_participant={{{status_of_mobility_participant}}} |participants={{{participants}}} }}


    [

     ["Type of mobility", "Student bachelor", "Student master", "Student doctorate"],
     ["BIP-student mobility for studies",
       {{#sum: 1 }},
       {{#sum: 1 }},
       {{#sum: 1 }}
     ],
     ["Governance Board meeting",
       {{#sum: 1 }},
       0,
       0
     ],
     ["Matching Event (Research, Education etc)",
       {{#sum: 1 }},
       {{#sum: 1 }},
       0
     ],
     ["Other- staff week, workshop, conference, training, internship, research",
       {{#sum: 1 }},
       {{#sum: 0 }},
       {{#sum: 1 }}
     ]
    

    ]