Delete misspelling contract status from dropdown list

[HPNZNB]

Hello experts,

How I can delete the misspelling status that imported from Business adapters studio from the dropdown list in FNMS On-Prem?

Thanks !

HP

[mfranz · Accepted solution]

1. Use a SQL statement to double check that you are looking for the correct entry.
   
   

   SELECT *
   FROM ContractStatus
   WHERE DefaultValue LIKE '%misspelled%'

2. Then delete it directly from the table.
   
   

   DELETE
   FROM ContractStatus
   WHERE DefaultValue LIKE '%misspelled%'