ElementCategory

Overview

This is a dimension entity which contains basic information about element categories.

Which element categories are included?

This entity includes all the categories for elements (e.g. resource, activity).

Usage in itslearning

  • This entity is not used in the Itslearning application, this is a technical table

Notes

  • The entity shows the latest version of each element category.

  • LearningItems are grouped into ElementCategories like Resources, Activities and other

Relationships

ElementCategory is linked to:

Diagram

images/download/attachments/44599484/ElementCategory.PNG

Entity Details

Name

Data type

Nullable

Description

ElementCategoryId

Edm.Int32

false

Id of an element category

ElementCategoryTitle

Edm.String

Element category title

T_ModifiedDate

Edm.DateTime

false

Date and time the entity was last modified in data warehouse

SQL code

CREATE TABLE [Dwh].[ElementCategory]([ElementCategoryId] [INT] NOT NULL ,[ElementCategoryTitle] [NVARCHAR]( 100 ) NULL, [T_ModifiedDate] [DATETIME] NOT NULL ) ALTER TABLE Dwh.ElementCategory ADD CONSTRAINT PK_ElementCategory PRIMARY KEY (ElementCategoryId);

Request body

URI
https://reporting.itslearning.com/odata/engine7/ElementCategories?$top=10

Response body - XML

XML response
<?xml version="1.0" encoding="utf-8"?>
<feed xml:base="https://reporting.itslearning.com/odata/engine7" xmlns="http://www.w3.org/2005/Atom" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices
/metadata" xmlns:georss="http://www.georss.org/georss" xmlns:gml="http://www.opengis.net/gml">
<id>http://schemas.datacontract.org/2004/07/</id>
<title />
<updated>2017-08-29T13:25:03Z</updated>
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/ElementCategories" />
<entry>
<id>https://reporting.itslearning.com/odata/engine7/ElementCategories(1)</id>
<category term="Itslearning.Reporting.Data.Models.ElementCategory" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/ElementCategories(1)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/ElementCategories(1)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/LearningItems" type="application/atom+xml;type=feed" title="LearningItems" href="https://reporting.itslearning.com/odata/engine7/ElementCategories(1)/
LearningItems" />
<title />
<updated>2017-08-29T13:25:03Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:ElementCategoryId m:type="Edm.Int32">1</d:ElementCategoryId>
<d:ElementCategoryTitle>Resource</d:ElementCategoryTitle>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/ElementCategories(2)</id>
<category term="Itslearning.Reporting.Data.Models.ElementCategory" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/ElementCategories(2)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/ElementCategories(2)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/LearningItems" type="application/atom+xml;type=feed" title="LearningItems" href="https://reporting.itslearning.com/odata/engine7/ElementCategories(2)/
LearningItems" />
<title />
<updated>2017-08-29T13:25:03Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:ElementCategoryId m:type="Edm.Int32">2</d:ElementCategoryId>
<d:ElementCategoryTitle>Activity</d:ElementCategoryTitle>
</m:properties>
</content>
</entry>
<entry>
<id>https://reporting.itslearning.com/odata/engine7/ElementCategories(3)</id>
<category term="Itslearning.Reporting.Data.Models.ElementCategory" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" />
<link rel="edit" href="https://reporting.itslearning.com/odata/engine7/ElementCategories(3)" />
<link rel="self" href="https://reporting.itslearning.com/odata/engine7/ElementCategories(3)" />
<link rel="http://schemas.microsoft.com/ado/2007/08/dataservices/related/LearningItems" type="application/atom+xml;type=feed" title="LearningItems" href="https://reporting.itslearning.com/odata/engine7/ElementCategories(3)/
LearningItems" />
<title />
<updated>2017-08-29T13:25:03Z</updated>
<author>
<name />
</author>
<content type="application/xml">
<m:properties>
<d:ElementCategoryId m:type="Edm.Int32">3</d:ElementCategoryId>
<d:ElementCategoryTitle>n/a</d:ElementCategoryTitle>
</m:properties>
</content>
</entry>
</feed>

Response body - JSON (default output format)

JSON response
{
"odata.metadata":"https://reporting.itslearning.com/odata/engine7/$metadata#ElementCategories","value":[
{
"ElementCategoryId":1,"ElementCategoryTitle":"Resource"
},{
"ElementCategoryId":2,"ElementCategoryTitle":"Activity"
},{
"ElementCategoryId":3,"ElementCategoryTitle":"n/a"
}
]
}