Skip to main content
Magento

Questions tagged [query]

Ask Question

Denotes the question related to database SQL query( in context of magento ).

300 questions
Newest Active Bountied Unanswered
0 votes
2 answers
272 views

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. ...
Rajkumar Elumalai's user avatar
  • 3,600
0 votes
2 answers
104 views

Whenever we send off a newsletter with say 10+ links to specific products, our server ends up overloading and our website ends up going down for 5-10 minutes until the server comes back up. The ...
ne0nlight's user avatar
  • 61
0 votes
1 answer
188 views

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:...
Jayashree N's user avatar
  • 7
1 vote
0 answers
15 views

I'm not sure when it started not working or if it ever worked. Helping a friend out with their website. I'm going to assume it was working at some point. I looked in the logs while refreshing the page ...
Singleton's user avatar
  • 84
0 votes
1 answer
475 views

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,''), ...
Chirag Prajapati's user avatar
  • 2,952
1 vote
1 answer
510 views

Query to get user permissions list in magento2 Admin roles role_type table column I found related query in above link but permission column is missing . Permission column exists in authorization rule ...
sandhya S's user avatar
  • 31
0 votes
1 answer
127 views

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.
jsnewbie21's user avatar
  • 15
0 votes
1 answer
60 views

What are the security risks associated with a Magento 2 website, and how can you mitigate them?
Noor Mohamed's user avatar
  • 515
0 votes
2 answers
297 views

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 * *...
Heri Rak's user avatar
  • 1
1 vote
0 answers
131 views

What would be the QUERY SQL to export the SKU columns and ADDITIONAL_ATTRIBUTES as shown in the product export module n Magento 2?
heroecall's user avatar
  • 11
0 votes
1 answer
383 views

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()-&...
Knight017's user avatar
  • 642
0 votes
1 answer
116 views

I am trying to provide video transcripts for each product video in a magento 2 site. I want to pull the transcript from the "video description" field in the admin area, and I have been ...
kug3lblitz's user avatar
  • 1
2 votes
2 answers
228 views

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 ...
Reza Anwar's user avatar
  • 23
2 votes
1 answer
2k views

I'm learning about Collections, Repositories and DTO, and I'm still trying to figure out what's the best way to query a table to fetch data. I also found that we can use \Magento\Framework\App\...
Douglas Vicentini's user avatar
  • 157
2 votes
1 answer
633 views

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 ...
Mike C's user avatar
  • 21

15 30 50 per page
1
2 3 4 5
…
20