Inactive databases still show in the dropdown options

[Onyinye Anthony]

In the past, if a database was marked as Inactive (Active = false), it would not be displayed in the dropdown menu for users to see (in the service portal).

How do i  fix it so that inactive lookup database items were not be displayed in the Additional Databases dropdown menu (in the service portal).

[Mark Manders]

Can you share what you mean? Do you have a catalog item with the databases as field? 

Is it a menu that shows databases? 

[Robbie · Accepted solution]

Hi @Onyinye Anthony,

This can easily be configured, however, the solution is based off some of the detail you haven't quite provided. When you mention databases and drop-down. Is the drop-down pointing at a choice list or is it pointing at a CI (Configuration Item) table such as 'cmdb_ci_database'?

If it's a choice list (and non reference to the ci table), you'll just have to go into the choices and set the 'inactive' field to true (I know - it's a little weird being inverse logic).

If it's a referencing a ci table, you'll find that Out Of Box (OOB) there is no 'active' flag for ci's, and it's based off of the operation status such as 'Operational' for example.

Simply right click on the field and 'Configure Dictionary' to perform either of these updates.

To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Kudos.


Thanks, Robbie

[Onyinye Anthony]

Thank you. This was helpful