cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Delete misspelling contract status from dropdown list

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

(1) Solution
mfranz
By Level 17 Champion
Level 17 Champion
  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%'

View solution in original post

(1) Reply
mfranz
By Level 17 Champion
Level 17 Champion
  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%'