See SqlServer.RFQ2.sql
row 112-117
INSERT INTO #rfqRecordIdProduct (Id,LimitedToStores,SubjectToAcl)
select distinct A.Id,A.LimitedToStores,A.SubjectToAcl
from #tmpFNS_rfq_Record A WITH (NOLOCK),
FNS_RFQProduct AP WITH (NOLOCK)
where A.Id not in (select Id from #rfqRecordIdProduct)
and A.Id=AP.rfqRecordId and (AP.ProductId=@productId or AP.ForAllProduct=1)
The column in FNS_RFQProduct doesn't exists.
The button is not diplayed. In the log I have:
2018.01.16 16:41:02:5267*******
RFQReadController. RFQ2_Widget. widgetZone=productdetails_bottom
2018.01.16 16:41:02:5557*******
RFQReadController. RFQ2_Widget. step 1. productId=1413, categoryId=0, manufacturerId=0
2018.01.16 16:41:02:5937*******
RFQService. GetRFQButtons. productId=1413, categoryId=0, manufacturerId=0, storeId=1, languageId=2, AllowedCustomerRoleIds=1,3
-----------------> Error Invalid column name 'ForAllProduct'.
The column is present in [FNS_RFQRequestType] Table
If you want use a parameter on the button 'Display for all products' ok. Otherwise I'll add a product on the button if the button should be shown for the product.
Yes please, we need another logic: if the button is not associated (empy list) the button should not be visible.
I.e. the button must be visible only for the associated elements (product/categorie/Manifacturers)
Thank's
Filippo
filippo.monti wrote:
I'm using nop version 3.9 and I've a problem in the plugin.
I've defined 12 buttons (all published) and only on a button I've associated a product.
In the product preview I see 12 buttons and not only one (the associated one).
The problem don't arise if i made the same but with manifacturers association