Questions tagged [query]
Denotes the question related to database SQL query( in context of magento ).
300 questions
0 votes
2 answers
268 views
Magento2: Disable / Modify GraphQL Field Suggestion
In GraphQL, if we enter wrong field name in search, its will suggest the alternative fields in the response. It creates some security issues in production. So we plan to disable that feature. ...
- 3,600
0 votes
1 answer
186 views
How to get products results even its visibility is search in magento graphql
Based on visibility,filter the product in magento 2. The SKU 111324 having the visibility value is "Search". Using below graphQL query Query query { products( filter: { sku: { eq:...
0 votes
1 answer
474 views
Is it possible to get Country Name using Select Query in Magento 2 DB?
I am trying to get the list of customers from the database directly using Mysql Query. SELECT ce.email As Email, ce.firstname As Firstname, ce.lastname As Lastname, COALESCE(NULLIF(cae.country_id,''), ...
- 2,952
0 votes
1 answer
126 views
Magento 2 - Query to know the user who update the price of the product
I am very new to magento. What is the query to to know who was the user who updated the price of a product? I just want to know the query, not the code. Thanks in advance.
- 15
0 votes
2 answers
296 views
Magento 2 - Products in category page not showing
My problem is that : all products in category page not showing. And when i displayed the query of $_productColection in Magento_Catalog/templates/product/list.phtml : /** * Product list template * *...
- 1
0 votes
1 answer
383 views
Add limit on collection of custom table and get one column value in Magento 2
I know there are solutions for getting one column as an array. $collection->getColumnValues('column_name'); And adding limit without setPageSize() and setCurPage() $collection->getSelect()-&...
- 642
2 votes
2 answers
227 views
Slow Query on Magento 1.9 Front-End After Moving Site to a New Server
I've just moved a Magento 1.9 site using a tarball and a mysqldump of the old site to a new server having the same hardware specs as the old one, followed all instructions I could find online, saw ...
- 23
2 votes
1 answer
630 views
Magento 2 Extremely high load on MySQL due to select query
I've seen similar questions asked on this site, but haven't seen a solution or fix to resolve the problem. Our site is spawning a large number of select queries to the point where mysql is overloaded ...
- 21