Schema Changes: 3.15.2

Upgrade: 3.15.1 → 3.15.2

This release applied 2 migration(s) to the database schema.

ID Type Description

1471

function

oils xpath string

1472

data

coded value map grid

Migration Details

1471 — oils xpath string

Type: function

View SQL
CREATE OR REPLACE FUNCTION evergreen.oils_xpath_string(text, text, text, anyarray) RETURNS text
AS $F$
    SELECT  ARRAY_TO_STRING(
                oils_xpath(
                    $1 ||
                        CASE WHEN $1 ~ $re$/[^/[]*@[^]]+$$re$ OR $1 ~ $re$\)$$re$ THEN '' ELSE '//text()' END,
                    $2,
                    $4
                ),
                $3
            );
$F$ LANGUAGE SQL IMMUTABLE;

1472 — coded value map grid

Type: data

View SQL
INSERT into config.workstation_setting_type (name, grp, datatype, label)
VALUES (
    'eg.grid.admin.config.coded_value_map', 'gui', 'object',
    oils_i18n_gettext(
        'eg.grid.admin.config.coded_value_map',
        'Grid Config: eg.grid.admin.config.coded_value_map',
        'cwst', 'label'
    )
);