We have a product list that is about 40k items in it. 40% of them have the discontinued flag checked...which created a lot of dead wood. Since we already imported the data, is there any way to make them not show up on VIEW->product and product search by default? Does that require a compile?
try deselecting the active flag
Add Where condition for
In the table ...
LEFT OUTER JOIN M_ProductPrice pr ON (M_Product.M_Product_ID=pr.M_Product_ID AND pr.IsActive='Y')
LEFT OUTER JOIN M_PriceList_Version plv ON (pr.M_PriceList_Version_ID=plv.M_PriceList_Version_ID)
LEFT OUTER JOIN M_AttributeSet pa ON (M_Product.M_AttributeSet_ID=pa.M_AttributeSet_ID),
discontinued flag checked
add field AD_InfoWindow.WhereClause
Log in to post a comment.
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.