where clause in database view

[Deepthi13]

Hi team, I want to extract report on variable editor table with values. please suggest

i already created data base like below, but when i am filtering this in report it is throwing error as 2nd screen shot

[Muhammad Khan]

Hi Deepthi,

Make sure you have used proper field names in where clause as suggested by Bert. Also make sure that you have included those in View Fields related list. It also seems like you don't have access to the data.

Anyhow, below configuration might help you.

Database View

Variable Ownership

Options

Requested Item

Catalog Item

[radhikachowdar1]

hi khan, 

Thanks for your screen shots i got data now after running database view but how can i dot walk variables that are present on variable editor in my report. please suggest as i can see only fields on ritm,sc_item_option_list tabkes only..

[radhikachowdar1]

 how to get my decided column data here?

[radhikachowdar1]

how to get desired field on my list view in report