Questions tagged [table]
This tag is ambiguous. For database tables, use "database", for html tables use "template" or "html", for shipping table rates use "table-rates"
156 questions
0 votes
0 answers
46 views
Magento2: Insert order grid data into a custom table using the sales_order_save_after event
I have created an observer with this event file. <config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:Event/etc/events....
- 731
0 votes
1 answer
165 views
db_schema can't set foreign key - Table [prefix]_sales_order do not have column with name "name"
I must add column1 to sales_order_grid and create foreign key to table sales_grid.column1 When i try use bin/magento setup:upgrade i get next message Table [myPrefix]_sales_order do not have column ...
- 21
2 votes
4 answers
6k views
Insert data into custom table in magento 2
I have created a custom table in database of magento 2. I want to insert some data into this custom table. I want to pass this data from controller to the custom table in magento 2.4. Please can any ...
- 139
0 votes
1 answer
567 views
How to add table schema as a dependency in setup patch data?
I am creating a custom Module, in that I created a custom table and patch data. The patch data for inserting data into that table. Now the issue is, the custom table was created through declarative ...
- 1,162
0 votes
3 answers
2k views
Magneto2: Base table or view not found table amasty_conf_group_attr doesn't exist
The changes made in products attributes doesn't show on the frontend. The part of the database won't update and shows the following message. "Base table or view not found table ...
- 3
0 votes
1 answer
1k views
Magento 2: Get all bundle products
So I have to create a report (SQL Script) which has all the bundle products and all its customizable options. I can get list of all the bundle products using this query. select entity_id, type_id, sku,...
0 votes
1 answer
257 views
I have confusion take of sales_sequence_profile table in Magento 2
Can anyone explain where what's the use of this table or where it will work? Thanks
0 votes
4 answers
5k views
Magento 2: How to get last inserted custom table Id without saving new item?
I want to get the last inserted id to my block without adding new data into the table. I want to use this value to automatically filled in my phtml file. I tried getId and it's not working. I just ...
- 25