{"type":"doc","content":[{"type":"heading","attrs":{"level":2},"content":[{"text":"Problem","type":"text"}]},{"type":"paragraph","content":[{"text":"Card-holder data wrongly uploaded for some reason and need to be removed from the system.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Solution","type":"text"}]},{"type":"paragraph","content":[{"text":"Data needs to be backed-up and hard-deleted from the database. Setting ","type":"text"},{"text":"date_deleted_dte ","type":"text","marks":[{"type":"strong"}]},{"text":"to a non-null value doesn’t work since select queries in the application do not filter by this field.","type":"text"}]},{"type":"paragraph","content":[{"text":"Data needs to be deleted from the following tables: ","type":"text"}]},{"type":"bulletList","content":[{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"yc096_person","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"yc070_party","type":"text"}]}]},{"type":"listItem","content":[{"type":"paragraph","content":[{"text":"tm019_upload_history","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"You would need to know the ","type":"text"},{"text":"organization name ","type":"text","marks":[{"type":"strong"}]},{"text":"for which data was uploaded","type":"text"},{"text":", ","type":"text","marks":[{"type":"strong"}]},{"text":"the ","type":"text"},{"text":"username","type":"text","marks":[{"type":"strong"}]},{"text":" for the account which made the upload, and the ","type":"text"},{"text":"date","type":"text","marks":[{"type":"strong"}]},{"text":" on which the upload was made, ","type":"text"},{"text":"number","type":"text","marks":[{"type":"strong"}]},{"text":" of records uploaded. ","type":"text"}]},{"type":"paragraph"},{"type":"codeBlock","attrs":{"language":"sql"},"content":[{"text":"---get foreign keys--\nselect * from tc006_organization where organization_name_txt = ''; --get \nselect * from tc008_user where User_Id = ''; --get \ndate uploaded = --format = DD-MMM-YYYY\nrecords uploaded = \n\n--run this to delete--\ndelete from yc096_person where last_update_user_id = and current_organization_id = and TO_DATE(date_created_dte)='';\ndelete from yc070_party where party_id in (select person_id from yc096_person where last_update_user_id = and current_organization_id = and TO_DATE(date_created_dte)='');\n\n--run this to delete from history--\ndelete from tm019_upload_history where\norganization_id = (select organization_id from tc006_organization where ORGANIZATION_NAME_TXT = '') AND\nTO_DATE(DATE_UPLOAD_DTE)='' and CARDHOLER_CNT_NUM = and\nLAST_UPDATE_USER_ID = (select TC008_USER_ID from tc008_user where USER_ID = '');","type":"text"}]},{"type":"paragraph"}],"version":1}

Browser not supported