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,
Hi
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
