Commerce composer important tables:
PAGELAYOUT
PAGELAYOUTTYPE
PLLOCATION
PLPAGE
PLSTOREWIDGET
PLTEMPLATEREL
PLWIDGET
PLWIDGETDEF
PLWIDGETDEFDESC
PLWIDGETNVP
PLWIDGETREL
PLWIDGETSLOT
STOREPLTYPES
Some of the important queries:
Select * from PLWIDGET where PAGELAYOUT_ID in (select
PAGELAYOUT_ID from PAGELAYOUT where name like 'Sample%');
Select * from PLWIDGETDEF where IDENTIFIER like
'Sample%';
Select * from PLWIDGETDEFDESC where PLWIDGETDEF_ID in
(select PLWIDGETDEF_ID from PLWIDGETDEF where IDENTIFIER like 'Sample%');
Select * from PLSTOREWIDGET where PLWIDGETDEF_ID in
(select PLWIDGETDEF_ID from PLWIDGETDEF where IDENTIFIER like 'Sample%');
Select * from PAGELAYOUT where name like 'Sample%';
Select * from PLWIDGETREL where PLWIDGET_ID_CHILD in
(select PLWIDGET_ID
from PLWIDGET
where PAGELAYOUT_ID in (select PAGELAYOUT_ID from PAGELAYOUT where name like
'Sample%'));
Select * from PLWIDGETSLOT where PAGELAYOUT_ID in (select
PAGELAYOUT_ID from PAGELAYOUT where name like 'Sample%');
Do share the related data if anything found so that it can be helpful to others tooo...
I really appreciate your professional approach. These are pieces of very useful information that will be of great use for me in future.
ReplyDeleteThis is the precise weblog for anybody who needs to seek out out about this topic. You notice so much its almost arduous to argue with you. You positively put a brand new spin on a subject that's been written about for years. Nice stuff, simply nice!
ReplyDelete