Platform: Metatude_platfrom

Context: SQL Tutorial

Title: SQL SELECT DISTINCT Statement

Description: The SQL SELECT DISTINCT Statement The SELECT DISTINCT statement is used to return only distinct (different) values. Inside a table, a column often contains many duplicate values; and sometimes you only want to list the different (distinct) values. SELECT DISTINCT Syntax SELECT DISTINCT column1, column2, ... FROM table_name;

JWT attributes in request:

{
  "https://purl.imsglobal.org/spec/lti/claim/message_type": "LtiResourceLinkRequest",
  "given_name": "Mose",
  "family_name": "Hackett",
  "middle_name": "Gleason",
  "picture": "http://example.org/Mose.jpg",
  "email": "Mose.Hackett@example.org",
  "name": "Mose Gleason Hackett",
  "https://purl.imsglobal.org/spec/lti/claim/roles": [
    "http://purl.imsglobal.org/vocab/lis/v2/membership#Learner",
    "http://purl.imsglobal.org/vocab/lis/v2/institution/person#Student",
    "http://purl.imsglobal.org/vocab/lis/v2/membership#Mentor"
  ],
  "https://purl.imsglobal.org/spec/lti/claim/role_scope_mentor": [
    "a62c52c02ba262003f5e"
  ],
  "https://purl.imsglobal.org/spec/lti/claim/resource_link": {
    "id": "76063",
    "title": "SQL SELECT DISTINCT Statement",
    "description": "The SQL SELECT DISTINCT Statement The SELECT DISTINCT statement is used to return only distinct (different) values.  Inside a table, a column often contains many duplicate values; and sometimes you only want to list the different (distinct) values.  SELECT DISTINCT Syntax SELECT DISTINCT column1, column2, ... FROM table_name;"
  },
  "https://purl.imsglobal.org/spec/lti/claim/context": {
    "id": "55255",
    "label": "Tutorial",
    "title": "SQL Tutorial",
    "type": [
      "database"
    ]
  },
  "https://purl.imsglobal.org/spec/lti/claim/tool_platform": {
    "name": "Metatude_platfrom",
    "contact_email": "",
    "description": "",
    "url": "",
    "product_family_code": "",
    "version": "1.0",
    "guid": "4230"
  },
  "https://purl.imsglobal.org/spec/lti-ags/claim/endpoint": {
    "scope": [
      "https://purl.imsglobal.org/spec/lti-ags/scope/lineitem",
      "https://purl.imsglobal.org/spec/lti-ags/scope/result.readonly",
      "https://purl.imsglobal.org/spec/lti-ags/scope/score"
    ],
    "lineitems": "https://lti-ri.imsglobal.org/platforms/4230/contexts/55255/line_items"
  },
  "https://purl.imsglobal.org/spec/lti-nrps/claim/namesroleservice": {
    "context_memberships_url": "https://lti-ri.imsglobal.org/platforms/4230/contexts/55255/memberships",
    "service_versions": [
      "2.0"
    ]
  },
  "https://purl.imsglobal.org/spec/lti-ces/claim/caliper-endpoint-service": {
    "scopes": [
      "https://purl.imsglobal.org/spec/lti-ces/v1p0/scope/send"
    ],
    "caliper_endpoint_url": "https://lti-ri.imsglobal.org/platforms/4230/sensors",
    "caliper_federated_session_id": "urn:uuid:807b3b82fb6f309a3a6d"
  },
  "iss": "https://lti-ri.imsglobal.org",
  "aud": "m123456",
  "iat": 1787641305,
  "exp": 1787641605,
  "sub": "b488f5b733fd152c5eeb",
  "nonce": "8ccd913014ea58c944fa",
  "https://purl.imsglobal.org/spec/lti/claim/version": "1.3.0",
  "locale": "en-US",
  "https://purl.imsglobal.org/spec/lti/claim/launch_presentation": {
    "document_target": "iframe",
    "height": 320,
    "width": 240,
    "return_url": "https://lti-ri.imsglobal.org/platforms/4230/returns"
  },
  "https://www.example.com/extension": {
    "color": "violet"
  },
  "https://purl.imsglobal.org/spec/lti/claim/custom": {
    "myCustomValue": "123"
  },
  "https://purl.imsglobal.org/spec/lti/claim/deployment_id": "1",
  "https://purl.imsglobal.org/spec/lti/claim/target_link_uri": "https://lti-ri.imsglobal.org/lti/tools/2809/launches"
}

JWT that will be sent:

eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiIsImtpZCI6IjVHWFgzVTlQNklnMGRBNDNBZThiWXhsS1g5d0VWblZqRmtfeThLNHlrbUEifQ.eyJodHRwczovL3B1cmwuaW1zZ2xvYmFsLm9yZy9zcGVjL2x0aS9jbGFpbS9tZXNzYWdlX3R5cGUiOiJMdGlSZXNvdXJjZUxpbmtSZXF1ZXN0IiwiZ2l2ZW5fbmFtZSI6Ik1vc2UiLCJmYW1pbHlfbmFtZSI6IkhhY2tldHQiLCJtaWRkbGVfbmFtZSI6IkdsZWFzb24iLCJwaWN0dXJlIjoiaHR0cDovL2V4YW1wbGUub3JnL01vc2UuanBnIiwiZW1haWwiOiJNb3NlLkhhY2tldHRAZXhhbXBsZS5vcmciLCJuYW1lIjoiTW9zZSBHbGVhc29uIEhhY2tldHQiLCJodHRwczovL3B1cmwuaW1zZ2xvYmFsLm9yZy9zcGVjL2x0aS9jbGFpbS9yb2xlcyI6WyJodHRwOi8vcHVybC5pbXNnbG9iYWwub3JnL3ZvY2FiL2xpcy92Mi9tZW1iZXJzaGlwI0xlYXJuZXIiLCJodHRwOi8vcHVybC5pbXNnbG9iYWwub3JnL3ZvY2FiL2xpcy92Mi9pbnN0aXR1dGlvbi9wZXJzb24jU3R1ZGVudCIsImh0dHA6Ly9wdXJsLmltc2dsb2JhbC5vcmcvdm9jYWIvbGlzL3YyL21lbWJlcnNoaXAjTWVudG9yIl0sImh0dHBzOi8vcHVybC5pbXNnbG9iYWwub3JnL3NwZWMvbHRpL2NsYWltL3JvbGVfc2NvcGVfbWVudG9yIjpbImE2MmM1MmMwMmJhMjYyMDAzZjVlIl0sImh0dHBzOi8vcHVybC5pbXNnbG9iYWwub3JnL3NwZWMvbHRpL2NsYWltL3Jlc291cmNlX2xpbmsiOnsiaWQiOiI3NjA2MyIsInRpdGxlIjoiU1FMIFNFTEVDVCBESVNUSU5DVCBTdGF0ZW1lbnQiLCJkZXNjcmlwdGlvbiI6IlRoZSBTUUwgU0VMRUNUIERJU1RJTkNUIFN0YXRlbWVudCBUaGUgU0VMRUNUIERJU1RJTkNUIHN0YXRlbWVudCBpcyB1c2VkIHRvIHJldHVybiBvbmx5IGRpc3RpbmN0IChkaWZmZXJlbnQpIHZhbHVlcy4gIEluc2lkZSBhIHRhYmxlLCBhIGNvbHVtbiBvZnRlbiBjb250YWlucyBtYW55IGR1cGxpY2F0ZSB2YWx1ZXM7IGFuZCBzb21ldGltZXMgeW91IG9ubHkgd2FudCB0byBsaXN0IHRoZSBkaWZmZXJlbnQgKGRpc3RpbmN0KSB2YWx1ZXMuICBTRUxFQ1QgRElTVElOQ1QgU3ludGF4IFNFTEVDVCBESVNUSU5DVCBjb2x1bW4xLCBjb2x1bW4yLCAuLi4gRlJPTSB0YWJsZV9uYW1lOyJ9LCJodHRwczovL3B1cmwuaW1zZ2xvYmFsLm9yZy9zcGVjL2x0aS9jbGFpbS9jb250ZXh0Ijp7ImlkIjoiNTUyNTUiLCJsYWJlbCI6IlR1dG9yaWFsIiwidGl0bGUiOiJTUUwgVHV0b3JpYWwiLCJ0eXBlIjpbImRhdGFiYXNlIl19LCJodHRwczovL3B1cmwuaW1zZ2xvYmFsLm9yZy9zcGVjL2x0aS9jbGFpbS90b29sX3BsYXRmb3JtIjp7Im5hbWUiOiJNZXRhdHVkZV9wbGF0ZnJvbSIsImNvbnRhY3RfZW1haWwiOiIiLCJkZXNjcmlwdGlvbiI6IiIsInVybCI6IiIsInByb2R1Y3RfZmFtaWx5X2NvZGUiOiIiLCJ2ZXJzaW9uIjoiMS4wIiwiZ3VpZCI6IjQyMzAifSwiaHR0cHM6Ly9wdXJsLmltc2dsb2JhbC5vcmcvc3BlYy9sdGktYWdzL2NsYWltL2VuZHBvaW50Ijp7InNjb3BlIjpbImh0dHBzOi8vcHVybC5pbXNnbG9iYWwub3JnL3NwZWMvbHRpLWFncy9zY29wZS9saW5laXRlbSIsImh0dHBzOi8vcHVybC5pbXNnbG9iYWwub3JnL3NwZWMvbHRpLWFncy9zY29wZS9yZXN1bHQucmVhZG9ubHkiLCJodHRwczovL3B1cmwuaW1zZ2xvYmFsLm9yZy9zcGVjL2x0aS1hZ3Mvc2NvcGUvc2NvcmUiXSwibGluZWl0ZW1zIjoiaHR0cHM6Ly9sdGktcmkuaW1zZ2xvYmFsLm9yZy9wbGF0Zm9ybXMvNDIzMC9jb250ZXh0cy81NTI1NS9saW5lX2l0ZW1zIn0sImh0dHBzOi8vcHVybC5pbXNnbG9iYWwub3JnL3NwZWMvbHRpLW5ycHMvY2xhaW0vbmFtZXNyb2xlc2VydmljZSI6eyJjb250ZXh0X21lbWJlcnNoaXBzX3VybCI6Imh0dHBzOi8vbHRpLXJpLmltc2dsb2JhbC5vcmcvcGxhdGZvcm1zLzQyMzAvY29udGV4dHMvNTUyNTUvbWVtYmVyc2hpcHMiLCJzZXJ2aWNlX3ZlcnNpb25zIjpbIjIuMCJdfSwiaHR0cHM6Ly9wdXJsLmltc2dsb2JhbC5vcmcvc3BlYy9sdGktY2VzL2NsYWltL2NhbGlwZXItZW5kcG9pbnQtc2VydmljZSI6eyJzY29wZXMiOlsiaHR0cHM6Ly9wdXJsLmltc2dsb2JhbC5vcmcvc3BlYy9sdGktY2VzL3YxcDAvc2NvcGUvc2VuZCJdLCJjYWxpcGVyX2VuZHBvaW50X3VybCI6Imh0dHBzOi8vbHRpLXJpLmltc2dsb2JhbC5vcmcvcGxhdGZvcm1zLzQyMzAvc2Vuc29ycyIsImNhbGlwZXJfZmVkZXJhdGVkX3Nlc3Npb25faWQiOiJ1cm46dXVpZDo4MDdiM2I4MmZiNmYzMDlhM2E2ZCJ9LCJpc3MiOiJodHRwczovL2x0aS1yaS5pbXNnbG9iYWwub3JnIiwiYXVkIjoibTEyMzQ1NiIsImlhdCI6MTc4NzY0MTMwNSwiZXhwIjoxNzg3NjQxNjA1LCJzdWIiOiJiNDg4ZjViNzMzZmQxNTJjNWVlYiIsIm5vbmNlIjoiOGNjZDkxMzAxNGVhNThjOTQ0ZmEiLCJodHRwczovL3B1cmwuaW1zZ2xvYmFsLm9yZy9zcGVjL2x0aS9jbGFpbS92ZXJzaW9uIjoiMS4zLjAiLCJsb2NhbGUiOiJlbi1VUyIsImh0dHBzOi8vcHVybC5pbXNnbG9iYWwub3JnL3NwZWMvbHRpL2NsYWltL2xhdW5jaF9wcmVzZW50YXRpb24iOnsiZG9jdW1lbnRfdGFyZ2V0IjoiaWZyYW1lIiwiaGVpZ2h0IjozMjAsIndpZHRoIjoyNDAsInJldHVybl91cmwiOiJodHRwczovL2x0aS1yaS5pbXNnbG9iYWwub3JnL3BsYXRmb3Jtcy80MjMwL3JldHVybnMifSwiaHR0cHM6Ly93d3cuZXhhbXBsZS5jb20vZXh0ZW5zaW9uIjp7ImNvbG9yIjoidmlvbGV0In0sImh0dHBzOi8vcHVybC5pbXNnbG9iYWwub3JnL3NwZWMvbHRpL2NsYWltL2N1c3RvbSI6eyJteUN1c3RvbVZhbHVlIjoiMTIzIn0sImh0dHBzOi8vcHVybC5pbXNnbG9iYWwub3JnL3NwZWMvbHRpL2NsYWltL2RlcGxveW1lbnRfaWQiOiIxIiwiaHR0cHM6Ly9wdXJsLmltc2dsb2JhbC5vcmcvc3BlYy9sdGkvY2xhaW0vdGFyZ2V0X2xpbmtfdXJpIjoiaHR0cHM6Ly9sdGktcmkuaW1zZ2xvYmFsLm9yZy9sdGkvdG9vbHMvMjgwOS9sYXVuY2hlcyJ9.NT50rvExwwl4-6Lr8fRA4RI3mkbiuk0_8MNiwMfqfNAbop1wonLjCB4IoPA1Bji9jbFWpqIcYtfz_VHTDhn9DX6EVWQKKdu1qVPCnm-fc7iGw0AxKKAHPvd3BCYFnIpFXb7qW5Cq6il378UoShOFCA-1EU2szpJYWpsyRj4hjHOovHMxh1fl6QhYWfYUFF_tLKrTn7AbEG5CMfC5RY07T2bcykPFN7lLAP-0zudbzfru_FDJ6JAa5xTCKIXx31q0Ai6tf3aCBi1NgipT2thRNfhQk38sqRZdlfM9XplcvjxIuFt7hP5ajhZdXh9rK5wkkJwfWa7XWgjFIVQTDNHcpQ

Launch