/
Custom Database Objects

Custom Database Objects

Designed for complex and enterprise use cases, Custom Database Objects require advanced technical support.

Overview

LearningBuilder is a very configurable system, and many features can be configured using in-app tools such as Comparison Rules.

In some use cases, however, the expected business rules are so complex or client-specific that in-app configuration is not feasible.

In other cases, especially with very large databases, custom queries or procedures can be used to improve performance over general-purpose queries.

LearningBuilder addresses these needs through client-specific database procedures that can “drop into” features that are designed to use them.

For example, the Member Attribute allows users to pick from a list of other people in the system. If the filter logic is complex, it can be written into a stored procedure that follows a specific format, and can then be selected through the UI as part of the Attribute configuration.

Configuring a Member Attribute with a custom filter procedure

Types of custom database objects

Feature indicator

Purpose

Feature indicator

Purpose

1

BulkAssignmentLearningPlanDataSource

Used by Bulk Assignment Learning Plans

2

MemberAttributeFilterDataSource

Filters the options in a Member Attribute

3

StoredProcedureBehavior

Procedures that can be triggered by a Run Stored Procedure Behavior

4

EntityListAttributeDataSource

Filters the options in an Entity List Attribute

5

ChartDataSource

Filters the data selectable in a custom chart

6

ActivityLookupAttributeFilterDataSource

Filters the options in an Activity Lookup Attribute

7

LearningPlanPostCreateHook

Procedures that can be triggered after a new Learning Plan Instance is created

8

SeatAssignmentAllocation

Procedures that can perform the “seat assignment” logic for Activity Offerings

9

MemberRoleAttributeFilterDataSource

Filters the options in a Member Role Attribute

10

PolledDataFile

Can support any 3rd party integration that relies on periodically requesting a data file from LearningBuilder.

Polled Data Files

11

SendToS3ApiDataSource

Used by integrations when an LB API needs to push data into a Lambda or by features that need external file storage like Multi-File Upload (S3) Attribute or Upload (S3) Attribute .

12

SystemInsightsView

Views that support https://heuristicsolutions.atlassian.net/wiki/spaces/DOCS/pages/3744071929

System Procedures

LearningBuilder exposes a number of stored procedures for use in extended features.