This example contains a helper class which allows to load enumeration values from the database. These values will be then used in business-central for authoring.

Enumeration are loaded from database every time the Guided Decision Table is opened.

Provided that you have RHPAM (or RHDM) 7.7 installed, you can utilize this example like this (PostgreSQL is used in this demo):

• Download PostgreSQL driver from PostgreSQL website
• Start the RHPAM (i.e. ./standalone.sh)
• Deploy the JDBC driver :

  $ ./jboss-cli.sh
  $ connect
  $ deploy postgresql-42.2.14.jar

• Configure the JBoss EAP datasource - change the values so they fit your environment:

/subsystem=datasources/data-source=CliDatasource:add(jndi-name=java:jboss/datasources/EnumDS,driver-name=postgresql-42.2.14.jar,connection-url=jdbc:postgresql://localhost:5432/productcodes,user-name=agiertli,password=agiertli)

• Create the example DB table which will hold your enum values:

CREATE TABLE productlist (
    id bigint PRIMARY KEY,
    name character varying(255),
    region character varying(255)
);

• Fill it with sample data:

INSERT INTO "public"."productlist"("id","name","region")
VALUES
(1,E'Ibalgin',E'India'),
(2,E'Nalgesin',E'India'),
(3,E'Kinedril',E'Japan'),
(4,E'Paralen',E'Japan'),
(5,E'Acylpirin',E'India'),
(6,E'Coldrex',E'Japan'),
(7,E'Acylpirin',E'China'),
(8,E'Acylpirin',E'Spain'),
(9,E'Acylpirin',E'UK'),
(10,E'Acylpirin',E'Ireland'),
(11,E'Acylpirin',E'Norway'),
(12,E'Acylpirin',E'Australia'),
(13,E'Coldrex',E'Australia'),
(14,E'Celaskon',E'Norway'),
(15,E'Hot-Flu',E'China');

• Install the enum-loader project to your local maven repository:

mvn clean install

Once the Enum Loader is setup, you can proceed with importing KJAR so you can actually see the Enums in action.

• Start the RHPAM / RHDM and and log into the business-central
• Import the repository with the example KJAR. The repository is located at this URL on github
• Review the Enumeration definition, which looks like this:

'Product.region' : ['India','Japan']
'Product.name[region]' : '(new org.redhat.appdev.enumloader.EnumLoader()).getProductCodes("@{region}")'

The above enum includes dependency between attribute region and name. In practice, it means that whenever specific region (India,Japan,..) is selected, only country specific enum values will be displayed to the end user.

Sample values for Japan:

Sample values for India: