question Re: Inactive databases still show in the dropdown options in Community Central forum

Inactive databases still show in the dropdown options

Onyinye Anthony — Thu, 05 Sep 2024 08:52:17 GMT

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).

Re: Inactive databases still show in the dropdown options

Mark Manders — Thu, 05 Sep 2024 11:04:46 GMT

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

Is it a menu that shows databases?

Re: Inactive databases still show in the dropdown options

Robbie — Thu, 05 Sep 2024 11:06:28 GMT

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

Re: Inactive databases still show in the dropdown options

Onyinye Anthony — Fri, 06 Sep 2024 15:18:39 GMT

Thank you. This was helpful