Questions tagged [resource-model]

The tag has no usage guidance, but it has a tag wiki.

Filter by
Sorted by
Tagged with
0
votes
1answer
25 views

ResourceModel->delete() not deleting row in custom table

I am writing a module which imports additional product information into a custom table with SKU as the PK. If there is already a row in the custom table regarding the SKU, i have to delete the old row ...
0
votes
0answers
17 views

How to modify data of Custom Field before rendering to backend form?

I have created a simple crud module that renders form with a few basic fields and saves data into database. Module is working fine and saving data correctly in the database. Issue is before rendering ...
0
votes
1answer
30 views

Magento 2 Category Tree With Multiselect and Text box in Custom Page

I am looking solution to get a Category tree on a custom page and parallel a text box, where the admin user could add some text and in parallel, he can select multiple categories. After adding text ...
0
votes
2answers
27 views

Magento 2 - How to properly load quote model by quote id?

I used to load the quote like this: $quote = $this->quoteModel->load($quoteId); But now I get a warning in PhpStorm saying that this method is deprecated: Deprecated: 100.1.0 because entities ...
2
votes
1answer
44 views

how to save data into custom table

i created 2 columns table. although entity_id is primary key but not auto_increment. entity_id is foreign key of quote table. db_schema.xml <schema xmlns:xsi="http://www.w3.org/2001/XMLSchema-...
0
votes
1answer
31 views

Magento 2 how to insert data in custom table?

I'm getting an error everytime I send my form in order to store data in a custom table I created. This is the error: {"0":"M\u00e9todo no v\u00e1lido Transom\\Emall\\Model\\StoreOwner::...
0
votes
1answer
27 views

Magento 2 : How to restrct field to be update in model?

I have a field in admin from which only be change at the time of new record. On the form edit, I want to show that field as editable but don't want to save the changes. For that, I have created the ...
0
votes
1answer
201 views

In Custom table always create a new row in magento 2?

I have created a custom table and update data using model and resource model. But it always create a new row on hitting ajax how to update row as old data is appear. I think i want to use Update query ...
0
votes
1answer
25 views

Change database in Resource model

I split my database on 3 parts. In my env php is set default, but in one of my model i need to connect to table wich located in different db. How can i change target db?
0
votes
1answer
85 views

How to add Data to Custom table in database using model in magento 2.3.5

I am created one form for contact and i want to insert form data into custom table in database in magento 2.3.5 so can anyone have idea about it then please send me solution. <?php namespace Aspl\...
0
votes
1answer
22 views

Cannot filter the data collection

I'm trying to filter the data collection from 4 hours to now and I have the below code but its not working. public function getWishlistProduct($wishlistid){ $to = date("Y-m-d h:i:s"); $from ...
0
votes
1answer
56 views

magento 2 resource model “save” to implement service contract persistence operations. not saving POST empty

I have a custom rest api for PUT and POST that the post data is an empty array therefore not saving as it's empty can anyone advise why or what could be wrong? /** * Save data. * * @...
0
votes
1answer
26 views

How to properly use Model Collection in Magento 2

I'm using Magento 2.3.4 , and i kinda confuse with how to use Magento 2 model correctly or follow the code standard. I have a model collection with database structure like this: brand_id | name | ...
1
vote
1answer
223 views

Magento 2 Save and Load functions

I just saw that Magento is going to deprecate load and save functions which we use in loading and saving models. Can someone provide some insights on this? What alternate we will be having now to use?...
0
votes
2answers
111 views

Magento2.3: How to collect the data by time?

I want to collect the records from 10PM to 5AM of wishlist data. I have already created a module and not sure how to filter the records by this timeframe. The wishlist table contains a field called ...
0
votes
0answers
8 views

how to filter the magento 2 in admin invoices list based on customer email?

how to filter the magento 2 in admin invoices list based on customer email ? i try to core modules but its not working?
4
votes
1answer
307 views

getCollection return null on custom model collection Magento 2.3.4

I'm creating a custom module to make a model by using mage2gen, I named this model critic: app/code/Vendor/Module/Model/Critic.php namespace Vendor\Module\Model; use Vendor\Module\Api\Data\...
0
votes
1answer
46 views

Magento getData() vs getFieldName() in model

After load('id') function in model, we can get data by either model->getData('field_name') or model->getFieldName(). I know that both functions are provided by DataObject class but what I want ...
1
vote
2answers
175 views

Magento 2.3 Unable to override Model: Magento\Reports\Model\ResourceModel\Report\Collection

Hello I am trying to override below function in below class using di.xml. Below is my code not working: di.xml <?xml version="1.0"?> <config xmlns:xsi="http://www.w3.org/2001/XMLSchema-...
0
votes
3answers
175 views

Class *Factory does not exist when get data to show on frontend

I'm trying to get data from my custom table and show it to frontend. I followed to this tutorial: https://www.emiprotechnologies.com/technical_notes/magento-technical-notes-60/post/how-to-create-...
0
votes
1answer
188 views

Magento2: How to check record before save record in table?

I am adding the barcode with product SKU and product ID in a table using below code:- File Path: /app/code/[NameSpace]/[ModuleName]/Model/ResourceModel/Custom.php public function generateBarcodes($...
1
vote
2answers
80 views

direct sql query in custom module

I have created a new web API module, this API should execute a direct SQL query. This is the code: namespace Mymodule\ProductByEbayItemid\Model\ProductByEbayItemidQuery; class ...
0
votes
2answers
41 views

Resourcemodel plugin not working - Magento2

app/code/Mymodule/Orderedproductsreport/etc/di.xml <type name="Magento\Reports\Model\ResourceModel\Product\Sold\Collection"> <plugin disabled="false" name="...
0
votes
2answers
787 views

Magento 2 : Insert Records in Multiple Table

I have created 2 table : table_1 : id (Primary key) name status table_2 : sub_id (Primary key) id (Foreign key table_1 id) description How to save records in both table using single model file?
0
votes
2answers
173 views

Grid not displaying in admin - custom Resource Model

I have a custom resource model mapping to a table named soldiers_thewatcher_watch with a primary key: watch_id. I added the Grid UI component as well as a controller and admin link, but when I ...
1
vote
0answers
30 views

Magento 2: join 2 table join issue

When 'm trying to join two tables in Magento 2, I get an empty result. This is the initial function that returns data from single table customer_entity without any error. \Block\Account\Message\...
1
vote
1answer
85 views

Magento 2 - What should repository methods return?

This question has been on my mind for some time. I'm currently writing a repository with the usual methods: save, getById, getList, delete and deleteById. What is the correct return for each method? ...
0
votes
0answers
28 views

how to use other module data source to new module in magento 2

Hi I want to use the data source of module 1 to module 2 in Magento 2 how I can do this ?? vendor/module2/etc/module.xml <sequence> <module name=vendor_module1/> </sequence> ...
0
votes
1answer
195 views

checking both updated_at and created_at filter with OR condition for product collection

Hello Please help me to updated this query to apply updated_at filter too with OR condition. Here If I want to add 'updated_at' too in the filter with the same condition like 'created_at' then what ...
1
vote
1answer
247 views

Magento 2.3. How to add data using model?

I have two variants adding data using Model. Which variant is more rignt ? Especially I want to ask about this $slider->setDataChanges(true);in first variant because I must set up _hasDataChanges ...
0
votes
1answer
32 views

Why magento2 outputs the query while showing data from ResourceModel collection Factory..?

protected $productCollectionFactory; public function __construct( ..... \Custom\MyModule\Model\ResourceModel\Product\CollectionFactory $productCollectionFactory, ... ) { ...
2
votes
1answer
406 views

factory class duplicate insert check in magento2

I have created a model class as like below. Vendor\Module\Model/Bulider.php namespace Vendor\Module\Model; use Magento\Framework\Exception\QualificationException; class Builder extends \Magento\...
4
votes
0answers
66 views

How to load Ui-component form data using another column instead of primary field Magento 2?

I have created a form using Ui-component it is working fine while adding new form & edit form. But I would like to do customization as per my requirement. Default Magento Ui form data is display ...
1
vote
1answer
156 views

Recevied Empty array after using getItemsByColumnValue() collection method

I'm trying to retrieve a row from a custom table named 'lmap_shipping_tablerate' using a specific value for a column postcode. An empty array is returned when following line is used in my ...
1
vote
1answer
54 views

Unable to display database table values on frontend in magento 2.1.7

I am trying to fetch table on frontend but getting this error Fatal error: Class 'Crud\Crudatfrontend\Model\ResourceModel\Post' not found in D:\xampp\htdocs\newmag\vendor\magento\framework\...
1
vote
2answers
455 views

How to update record using multiple conditions in CollectionFactory magento 2

I am trying to update the record but it creates a new record. Collection factory <?php namespace Webkul\Mpquotesystem\Block; use Webkul\Mpquotesystem\Model\ResourceModel\Quoteconversation; ...
0
votes
2answers
332 views

Magento 2 : Custom Column Error

So, I have added a column to sales_order table. It is varchar type and it has some data in it. I found tutorial: here that show what I want to achieve exactly. Now, I am running Magento 2.2.3. and ...
0
votes
1answer
41 views

Model Collection.php magento 2

I cant seem to find any information why we need to create a Collection.php file inside ResourceModel and what is the purpose of collection.
2
votes
1answer
282 views

Adding data to EAV attribute deprecated

I have an existing module with code like this: $attribute = $customerUpgrade->getEavConfig()->getAttribute(Customer::ENTITY, 'my_custom_attribute') ->addData([ 'attribute_set_id' ...
1
vote
2answers
360 views

Magento 2 + How to import the custom city collection from the database into a dropdown (for the city textarea)

I'm a bit confused with creating a city dropdown with my custom cities. I have already imported the cities into a table and also created the Model, ResourceModel, Collection. Now I need to get those ...
1
vote
1answer
164 views

Implementing service contract Magento 2 deletebyid()

Implementing service contract using this method getting error of "Class string does not exist." model/userrepository.php public function deletebyid($del) { $hamburger = $this->...
1
vote
1answer
47 views

Implementing service contract Magento 2? Getting error “Class Assign\RestService\Model\ResourceModel\Hamburger\CollectionFactory does not exist”

I am implementing simple service contracts. don't have much knowledge about service contracts following example from here How to implement service contract for a custom module in Magento 2? i am ...
0
votes
1answer
597 views

invalid create method

I have a model, I call it in a block and when I use the create method I get an error saying: Exception #0 (Magento\Framework\Exception\LocalizedException): Invalid method Vendor\Namespace\Model\...
0
votes
1answer
276 views

Check if product type is grouped, without loading whole product

I want to check whether a certain product is of type 'grouped' or something else. And, i need to do this without loading the whole product. Now for other attributes the code below seems to work ...
2
votes
3answers
289 views

magento 2 : model in custom module

i already have a table in database also created model files and all works fine so now added another table successfully so what changes i need to do with model files i mean in model resourcemodel and ...
2
votes
1answer
124 views

visibility attribute value is not rendering from product collection in magento 2

We need to display the visibility of the product in category page, but currently we are not able to fetch its value from product object. We tried with $_attributeLabel = $_product->getResource()-&...
0
votes
2answers
1k views

Call to undefined method addFieldToFilter() in magento 2

I have a model,resource model,collection file shown below. app/code/Magge/Custom/Model/Categrory.php namespace Magge\Custom\Model; use Magento\Framework\Model\AbstractModel; class Categrory ...
0
votes
1answer
119 views

Magento 2 assigning Custom User resources in User roles

When I am trying to create a new User role. After selecting the Custom resource List is Not showing, Can u Please help me how I can do this. I what to Create a login for Product Manager to Upload ...
1
vote
1answer
98 views

Module with cron job to fetch all products where custom attribute is true

I am brand new to Magento module development, and I need some help getting started. My goal is relatively simple: I'd like to create a module which fetches all products with a custom attribute '...
0
votes
1answer
101 views

Magento 2 getting Error override resource model

I have facing Below error when I override resource model Fatal error: Call to undefined method Magento\ConfigurableProduct\Model\ResourceModel\Product\Type\Configurable\Interceptor::getAttributeId() ...