search

bcgov / foi-flow

Freedom of Information modernization
Apache License 2.0
5 stars 3 forks source link

Advanced Search - Unable to search 'Unopened' #3856

Open KyEggleston opened 1 year ago

KyEggleston commented 1 year ago

Describe the bug in current situation In PROD, IAO users are unable to search for unopened requests using the 'Request State' filter of "Unopened". When selecting the "Unopened" checkbox, and searching for records, no data is displayed, and users are presented with an error toast. See images below.

Link bug to the User Story

Impact of this bug Low

Chance of Occurring (high/medium/low/very low) Low Pre Conditions: which Env, any pre-requesites or assumptions to execute steps? PROD

Steps to Reproduce Steps to reproduce the behavior:

  1. Go to Advanced Search in PROD
  2. Click on the "Unopened" checkbox under the 'Request State' filter
  3. Click 'Apply Search'
  4. See error

Actual/ observed behaviour/ results User receives error toast (below), and no data is displayed

Expected behaviour User should be presented with all requests that are unopened - if no requests are unopened, users should receive no results.

Screenshots/ Visual Reference/ Source If applicable, add screenshots to help explain your problem. You an use screengrab. image.png

m-prodan commented 1 year ago

@nkan-aot

nkan-aot commented 1 year ago

issue is due to special character "\u0000" representing null character in rawrequest ids 11047 and 11125. Issue with postgres when this character is in a json data type column https://github.com/turbot/steampipe-postgres-fdw/issues/118 May have been introduced if applicant copied the request description from other sources when making request. I have removed the characters from db since it is meaningless character, however a permanent fix is needed to remove this character before inserting to db

image.png