Databases view by request item and service catalog (variable)

[Tepp]

Hi,

I would like to create a list view of my application in ServiceCatalog.

I have tried to join the three tables using the database view, but it does not work.

sc_req_item
sc_item_option_mtom
sc_item_option

I want to set a question (variable) in the ServiceCatalog to a column in the list.

Best regards,

[Ankur Bawiskar]

Hi,

check this link and it has solution

Database View to Join RITM (Request Item) and its Reference variable table

Regards
Ankur

[Ankur Bawiskar]

@Tepp 

Hope you are doing good.

Did my reply answer your question?

If my response helped please close the thread by marking appropriate response as correct so that it benefits future readers.

Regards
Ankur

[Tepp]

Dear, Ankur Bawiskar

Thank you for your response.

I checked the article you told me about.
In conclusion, does it mean that the database view alone cannot turn variables into list columns and we need to take advantage of the report function?

[shloke04 · Accepted solution]

Hi @Tepp 

As far as I am aware, you will not be able to pull in the Variable Question Label to your Requested item list view. My suggestion will be to try out below two options:

1. Use a Report where ServiceNow OOTB provides an ability to dot walk in and have variables displayed in your list view.

2. Create a Database View as per steps below and have a new Module created to have your Variables displayed in List view as you need. You can restrict this module based on role as well to specific group of users in case there is a need.

1. Navigate to Database View module.

2. Now create a Database View as shown in below screenshot:

3. Now when you click on Try it, it will show you the result where you need to add Your Variable Question and it's value as you need as shown below:

4. Now you can add this as a new module under an Application Menu by following the steps as  below:

Select the Table Name as your Database View Table Name and select the Application Menu under which you want to have this module:

Save your changes and refresh your Browser. You will see the module being displayed with results as you need. This can be one of the option you may think of.

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke