bcgov / bcgov/entity

ISSUE WITH COMPANY NAME DISPLAY IN MHR TABLE

Open
#21,847 0 comments 0 reactions 0 assignees View on GitHub
Assets MHR
Dominant language
JavaScript
Stars
23
Forks
62
Avg merge
24m
Merged PRs (30d)
1

Description

There is an issue displaying a business name in the MHR table: 2 & 2 holdings ltd. (pulled from drop down list)- see display on table, it displays '2 & 2 HOLDINGS LTD.' instead of '2 & 2 holdings ltd.' The output displays the company name properly.

image.png

Developer Note:
Short answer: this view of an owner name is only in the account MHR registrations table and will go away after data migration.

Long answer:
The registrations table displays a list of owner names. DB2 has a limited set of built in functions for aggregating data. There are no IMS DB2 JSON functions, we are using an XML function in the query to fetch the registration table information from DB2. The '&' character is reserved in XML, so the function is HTML encoding the '&' in the query results.

Solution:
Either live with it before data migration or make an API change to remove the encoding.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.