When i add/Edit downloadable Product, I Can't get Link and Sample-Title
and Links can be purchased separately checkbox value.
I need details in which table it get saved/stored ? And how it is store ?
This three are Set as an Attributes
\Magento\Catalog\Model\ResourceModel\Product\CollectionFactory $productCollectionFactory,
$this->_productCollectionFactory = $productCollectionFactory;
public function getlinktitle($productId)
{
$collection = $this->_productCollectionFactory->create();
$collection->addAttributeToSelect('*');
$collection->addAttributeToFilter('entity_id',$productId);
foreach($collection as $product)
{
$attributes = $product->getAttributes();
foreach ($attributes as $attribute) {
if($attribute->getAttributeCode()=='links_title')
{
$attribute_title['link']=$attribute->getFrontend()->getValue($product);
}
if($attribute->getAttributeCode()=='samples_title')
{
$attribute_title['sample']=$attribute->getFrontend()->getValue($product);
}
if($attribute->getAttributeCode()=='links_purchased_separately')
{
$attribute_title['seprate']=$attribute->getFrontend()->getValue($product);
}
}
}
return $attribute_title;
}
Basically product stores in catalog_product_entity table and its type_id = downloadable
Its follow the eav structure so below is the details where url and other details stored.
Value is stored in table catalog_product_entity_int with attribute ID 125. You can check attribute ID from table eav_attribute`
SELECT * FROM catalog_product_entity_int
WHERE attribute_id
='125'