Database view for Catalog items

Harshit
Tera Contributor

‎05-26-2014 08:09 AM

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 NameRITM numberPlace/LocationType of deviceDescription
Report stolen device

RITM001

Place 1Mobiletestxxxx
Report stolen deviceRITM002Place 2I-Padtestxx

 

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!!

0 Helpfuls
  • 2,147 Views
6 REPLIES 6

solutioningnow
Giga Guru

‎05-26-2014 11:56 PM

Hi Harshit,



You can create the database view for mention tables. I have also created the same database view in past for one of my customer. Please refer below screenshot for your reference:



db_view.png


Please mark answer as correct/helpful, if it was really helpful 🙂



Regards,


Solutioner


Logo.png


Enhance Knowledge NOW@ www.solutioningnow.com


http://www.solutioningnow.com/


Preview file
26 KB
Preview file
12 KB
0 Helpfuls

DrewW
Mega Sage
Mega Sage

‎05-27-2014 03:55 AM

While a database view or reporting directly from the Var ownership table will get you the data it will not get you the data in the format that you want.   There really is no good way to do this with out coding something custom.   We have used two methods to do this, the first was to create a local replica of the data and then created a complex stored procedure that would return a table in the form that you are looking for, but that all has to be done out side the system.   The other way was to create a UI page to show the information the way you want.


0 Helpfuls