RITM variables values into database views

[basantsoni]

Hi Friends,

I have created database view where are pulling information from RITM and approval tables, but I also want to bring variables from some of the catalog item and variables values.

Please let me know, how we can pull variables into this view and their values.

Appreciate your valuable responses.

Regards,

Basant

[Munender Singh]

Hi,

Catalog Variables are stored in a table item_option_new.The variables are associated either to a catalog item or to a variable set.

The association between catalog item and variable set is stored in io_set_item.

Create a Database view on the two tables with variable_set as where clause.This way you will be able to achieve your solution.

Regards,

Munender

[Deepak Kumar5]

You should have "Variables" in available side of your report on DB View as well. Clicking on that, You can select your Request and variables to include in your report.