bcgov / entity

ServiceBC Registry Team working on Legal Entities
Apache License 2.0
23 stars 58 forks source link

BUG: Platform application data breaks the "All" tab on the dashboard #24007

Open rstens opened 3 hours ago

rstens commented 3 hours ago

Describe the bug in current situation I noticed that the database has an application record for platform and this breaks the All tab in the dash.

Platform application record : 158

Regular application record : 165

"id","application_json","application_date","type","status","decision_date","invoice_id","payment_status_code","payment_completion_date","payment_account","registration_id","submitter_id","reviewer_id","application_tsv","application_number","created","modified","created_by_id","modified_by_id"
158,"{""registration"": {""businessDetails"": {""legalName"": ""Test Business"", ""businessNumber"": ""BN12345"", ""mailingAddress"": {""city"": ""MAPLE RIDGE"", ""address"": ""12766 227st"", ""country"": ""CA"", ""province"": ""BC"", ""postalCode"": ""V2X 6K6"", ""addressLineTwo"": """"}, ""homeJurisdiction"": ""BC"", ""takeDownRequestEmail"": ""takedown@test.test"", ""noticeOfNonComplianceEmail"": ""noncomp@test.test"", ""takeDownRequestOptionalEmail"": ""takedownopt@test.test"", ""consumerProtectionBCLicenceNumber"": ""1234"", ""noticeOfNonComplianceOptionalEmail"": ""noncompopt@test.test"", ""registeredOfficeOrAttorneyForServiceDetails"": {""attorneyName"": ""Billy Bob"", ""mailingAddress"": {""city"": ""MAPLE RIDGE"", ""address"": ""12766 227st"", ""country"": ""CA"", ""province"": ""BC"", ""postalCode"": ""V2X 6K6"", ""addressLineTwo"": """"}}}, ""completingParty"": {""lastName"": ""Test"", ""extension"": ""x64"", ""faxNumber"": ""604-777-7777"", ""firstName"": ""Test"", ""phoneNumber"": ""604-999-9999"", ""emailAddress"": ""compparty@test.test""}, ""platformDetails"": {""brands"": [{""name"": ""Provider A"", ""website"": ""http://abc.com""}, {""name"": ""Provider B"", ""website"": ""http://xyz.com""}], ""listingSize"": ""GREATER_THAN_THOUSAND""}, ""registrationType"": ""PLATFORM"", ""platformRepresentatives"": [{""jobTitle"": ""Sales Manager"", ""lastName"": ""Jinnah"", ""extension"": ""x64"", ""faxNumber"": ""604-888-888"", ""firstName"": ""Kial"", ""phoneNumber"": ""123-456-8970"", ""emailAddress"": ""rep1@test.test""}, {""jobTitle"": ""Sales Manager"", ""lastName"": ""Test"", ""extension"": """", ""faxNumber"": ""604-777-7777"", ""firstName"": ""Test"", ""phoneNumber"": ""604-999-9999"", ""emailAddress"": ""rep2@test.test""}]}}","2024-10-23 18:35:49.117075+00","registration","FULL_REVIEW_APPROVED","2024-10-23 18:37:00.774171+00",41764,"COMPLETED","2024-10-23 18:35:49+00","3040",131,41,41,"'-456':93 '-777':52,104 '-7777':53,105 '-888':87,88 '-8970':94 '-999':58,110 '-9999':59,111 '123':92 '1234':27 '12766':9,37 '227st':10,38 '604':51,57,86,103,109 '6k6':17,45 'abc.com':66 'b':69 'bc':14,19,42 'billi':31 'bn12345':4 'bob':32 'busi':2 'ca':12,40 'compparty@test.test':61 'greater':73 'jinnah':82 'kial':90 'manag':80,99 'mapl':6,34 'noncomp@test.test':23 'noncompopt@test.test':29 'platform':77 'provid':63,68 'rep1@test.test':96 'rep2@test.test':113 'ridg':7,35 'sale':79,98 'takedown@test.test':21 'takedownopt@test.test':25 'test':1,47,55,101,107 'thousand':75 'v2x':16,44 'x64':49,84 'xyz.com':71","76813933759828","2024-10-23 18:35:49.132126","2024-10-23 18:37:00.775313",41,41
165,"{""registration"": {""unitAddress"": {""city"": ""Cranbrook"", ""address"": ""15-9762 Ermacora Rd"", ""country"": ""CA"", ""nickname"": ""Auto Approval Address"", ""province"": ""BC"", ""postalCode"": ""V1C 7E1"", ""addressLineTwo"": """"}, ""unitDetails"": {""propertyType"": ""SECONDARY_SUITE"", ""ownershipType"": ""RENT""}, ""listingDetails"": [], ""primaryContact"": {""name"": {""lastName"": ""THIRTYNINE"", ""firstName"": ""BCREGTEST THANOS""}, ""details"": {""extension"": """", ""faxNumber"": """", ""phoneNumber"": ""6048313629"", ""emailAddress"": ""roland.stens@gmail.com"", ""preferredName"": ""Oma""}, ""dateOfBirth"": ""1942-10-30"", ""businessNumber"": ""Stens Consulting Inc."", ""mailingAddress"": {""city"": ""North Saanich"", ""address"": ""1239 Hillgrove Road"", ""country"": ""CA"", ""province"": ""BC"", ""postalCode"": ""V8L 5K7""}, ""socialInsuranceNumber"": ""999 999 999""}, ""registrationType"": ""HOST"", ""principalResidence"": {""agreedToSubmit"": true, ""agreedToRentalAct"": false, ""nonPrincipalOption"": ""Located in exempt community"", ""isPrincipalResidence"": false, ""specifiedServiceProvider"": ""n/a""}}}","2024-10-23 23:17:57.592501+00","registration","FULL_REVIEW",NULL,41780,"COMPLETED","2024-10-23 23:17:58.26766+00","3452",NULL,5,NULL,"'-10':36 '-30':37 '-9762':4 '1239':46 '15':3 '1942':35 '5k7':55 '6048313629':29 '7e1':17 '999':57,58,59 'address':12 'approv':11 'auto':10 'bc':14,52 'bcregtest':26 'ca':8,50 'communiti':66 'consult':40 'cranbrook':1 'ermacora':5 'exempt':65 'hillgrov':47 'host':61 'inc':41 'locat':63 'n/a':68 'north':43 'oma':33 'rd':6 'rent':22 'road':48 'roland.stens@gmail.com':31 'saanich':44 'secondari':19 'sten':39 'suit':20 'thano':27 'thirtynin':24 'v1c':16 'v8l':54","92460830342658","2024-10-23 23:17:57.603658","2024-10-23 23:25:26.354471",5,NULL

Experience Issue: When switching tabs from All to Full Examination, the page is loading and did not show me the list of application under full examination. I had to refresh the page for it to load properly.

Steps to reproduce:

  1. go to "all" tab
  2. go to page 2 or 3 (just do not stay in the first page)
  3. go to "full examination" tab --> you will find the issue here
image.png
rstens commented 3 hours ago

Duplicate of https://app.zenhub.com/workspaces/strr-65b2a7146835aa0cdf315b79/issues/gh/bcgov/entity/23973