Database view for Catalog items

[Harshit]

In our project, the client need to create a report for a Catalog item (Report stolen device) which has 3 variables (namely - Place/Location, Type of Device, Description)   and should like below -

Item Name	RITM number	Place/Location	Type of device	Description
Report stolen device	RITM001	Place 1	Mobile	testxxxx
Report stolen device	RITM002	Place 2	I-Pad	testxx

I was trying using database views with the following tables but no luck -

1. sc_item_option_mtom

2. item_option_new

3. sc_item_option

Dont know where i went wrong, or is it really possible to get such a report?

Thanks in advance!!

[Bhavesh Jain1]

Do you really want to create a database view when you can get this information from single table?

sc_item_option_mtom

Parent Item stores the RITM number

Item stores the Item name

Question field stores all your variables

Value stores the user input

You can set the list layout for the table 'sc_item_option_mtom'.

Regards,

Bhavesh

http://www.igate.com

[Pradeep Sharma]

Just to add, If you have any reference field in your variable sets then the value of that field will be shown as "sys-id" and not the display value in Report.

Thanks,

Pradeep Sharma

[Harshit]

Thanks Pradeep..
I checked, no reference fields

[Pradeep Sharma]

Perfect

Thanks,

Pradeep Sharma