Custom report from SQL query












2















I want to get order total of the month January 2019 for complete orders



I need to know tables related to this query, or if someone can share query that would be great.






magento2 sql custom-reports







share|improve this question









New contributor




Muhammad Anas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





















  • order total, you mean the total number of orders for year 2019 or the total sum of amount of all the order for the specific month?

    – magefms
    16 hours ago











  • I need sum amount

    – Muhammad Anas
    16 hours ago
















2















I want to get order total of the month January 2019 for complete orders



I need to know tables related to this query, or if someone can share query that would be great.






magento2 sql custom-reports







share|improve this question









New contributor




Muhammad Anas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





















  • order total, you mean the total number of orders for year 2019 or the total sum of amount of all the order for the specific month?

    – magefms
    16 hours ago











  • I need sum amount

    – Muhammad Anas
    16 hours ago














2












2








2








I want to get order total of the month January 2019 for complete orders



I need to know tables related to this query, or if someone can share query that would be great.






magento2 sql custom-reports







share|improve this question









New contributor




Muhammad Anas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.












I want to get order total of the month January 2019 for complete orders



I need to know tables related to this query, or if someone can share query that would be great.






magento2 sql custom-reports




magento2 sql custom-reports






share|improve this question









New contributor




Muhammad Anas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











share|improve this question









New contributor




Muhammad Anas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









share|improve this question




share|improve this question








edited 16 hours ago









Muhammad Hasham

2,7012731




2,7012731






New contributor




Muhammad Anas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









asked 17 hours ago









Muhammad AnasMuhammad Anas

6211




6211




New contributor




Muhammad Anas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





New contributor





Muhammad Anas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.






Muhammad Anas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.













  • order total, you mean the total number of orders for year 2019 or the total sum of amount of all the order for the specific month?

    – magefms
    16 hours ago











  • I need sum amount

    – Muhammad Anas
    16 hours ago



















  • order total, you mean the total number of orders for year 2019 or the total sum of amount of all the order for the specific month?

    – magefms
    16 hours ago











  • I need sum amount

    – Muhammad Anas
    16 hours ago

















order total, you mean the total number of orders for year 2019 or the total sum of amount of all the order for the specific month?

– magefms
16 hours ago





order total, you mean the total number of orders for year 2019 or the total sum of amount of all the order for the specific month?

– magefms
16 hours ago













I need sum amount

– Muhammad Anas
16 hours ago





I need sum amount

– Muhammad Anas
16 hours ago










2 Answers
2






active

oldest

votes


















2














Your questions seems double meaning for me, so here I'll post my answer assuming:



You want to get the Total Numbers of order for the specific month, below query should work 



SELECT count(entity_id) FROM sales_order where state='complete' and status='complete' and month(created_at) = '01' and year(created_at) = '2019';


You want to get the total sum amount you can try this (This will filter only order that are completed): 



SELECT sum(base_grand_total) FROM sales_order where state='complete' and status='complete' and month(created_at) = '01' and year(created_at) = '2019';





share|improve this answer



















  • 1





    It worked. Thanks

    – Muhammad Anas
    16 hours ago



















1














Here is query which will give you order total of completed order's for month jan 2019:



SELECT sum(base_grand_total) FROM  sales_order

WHERE created_at >='2018-12-31 23:59:59.000' AND created_at <= '2019-02-31 

23:59:59.000' AND status='complete'





share|improve this answer
























  • Thanks Mohit, but it is showing warning that incorrect datetime format

    – Muhammad Anas
    16 hours ago











  • Thanks for answer. +1

    – Muhammad Anas
    15 hours ago











Your Answer








StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "479"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});






Muhammad Anas is a new contributor. Be nice, and check out our Code of Conduct.










draft saved

draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f267395%2fcustom-report-from-sql-query%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown

























2 Answers
2






active

oldest

votes








2 Answers
2






active

oldest

votes









active

oldest

votes






active

oldest

votes









2














Your questions seems double meaning for me, so here I'll post my answer assuming:



You want to get the Total Numbers of order for the specific month, below query should work 



SELECT count(entity_id) FROM sales_order where state='complete' and status='complete' and month(created_at) = '01' and year(created_at) = '2019';


You want to get the total sum amount you can try this (This will filter only order that are completed): 



SELECT sum(base_grand_total) FROM sales_order where state='complete' and status='complete' and month(created_at) = '01' and year(created_at) = '2019';





share|improve this answer



















  • 1





    It worked. Thanks

    – Muhammad Anas
    16 hours ago
















2














Your questions seems double meaning for me, so here I'll post my answer assuming:



You want to get the Total Numbers of order for the specific month, below query should work 



SELECT count(entity_id) FROM sales_order where state='complete' and status='complete' and month(created_at) = '01' and year(created_at) = '2019';


You want to get the total sum amount you can try this (This will filter only order that are completed): 



SELECT sum(base_grand_total) FROM sales_order where state='complete' and status='complete' and month(created_at) = '01' and year(created_at) = '2019';





share|improve this answer



















  • 1





    It worked. Thanks

    – Muhammad Anas
    16 hours ago














2












2








2







Your questions seems double meaning for me, so here I'll post my answer assuming:



You want to get the Total Numbers of order for the specific month, below query should work 



SELECT count(entity_id) FROM sales_order where state='complete' and status='complete' and month(created_at) = '01' and year(created_at) = '2019';


You want to get the total sum amount you can try this (This will filter only order that are completed): 



SELECT sum(base_grand_total) FROM sales_order where state='complete' and status='complete' and month(created_at) = '01' and year(created_at) = '2019';





share|improve this answer













Your questions seems double meaning for me, so here I'll post my answer assuming:



You want to get the Total Numbers of order for the specific month, below query should work 



SELECT count(entity_id) FROM sales_order where state='complete' and status='complete' and month(created_at) = '01' and year(created_at) = '2019';


You want to get the total sum amount you can try this (This will filter only order that are completed): 



SELECT sum(base_grand_total) FROM sales_order where state='complete' and status='complete' and month(created_at) = '01' and year(created_at) = '2019';






share|improve this answer












share|improve this answer



share|improve this answer










answered 16 hours ago









magefmsmagefms

2,0472426




2,0472426








  • 1





    It worked. Thanks

    – Muhammad Anas
    16 hours ago














  • 1





    It worked. Thanks

    – Muhammad Anas
    16 hours ago








1




1





It worked. Thanks

– Muhammad Anas
16 hours ago





It worked. Thanks

– Muhammad Anas
16 hours ago













1














Here is query which will give you order total of completed order's for month jan 2019:



SELECT sum(base_grand_total) FROM  sales_order

WHERE created_at >='2018-12-31 23:59:59.000' AND created_at <= '2019-02-31 

23:59:59.000' AND status='complete'





share|improve this answer
























  • Thanks Mohit, but it is showing warning that incorrect datetime format

    – Muhammad Anas
    16 hours ago











  • Thanks for answer. +1

    – Muhammad Anas
    15 hours ago
















1














Here is query which will give you order total of completed order's for month jan 2019:



SELECT sum(base_grand_total) FROM  sales_order

WHERE created_at >='2018-12-31 23:59:59.000' AND created_at <= '2019-02-31 

23:59:59.000' AND status='complete'





share|improve this answer
























  • Thanks Mohit, but it is showing warning that incorrect datetime format

    – Muhammad Anas
    16 hours ago











  • Thanks for answer. +1

    – Muhammad Anas
    15 hours ago














1












1








1







Here is query which will give you order total of completed order's for month jan 2019:



SELECT sum(base_grand_total) FROM  sales_order

WHERE created_at >='2018-12-31 23:59:59.000' AND created_at <= '2019-02-31 

23:59:59.000' AND status='complete'





share|improve this answer













Here is query which will give you order total of completed order's for month jan 2019:



SELECT sum(base_grand_total) FROM  sales_order

WHERE created_at >='2018-12-31 23:59:59.000' AND created_at <= '2019-02-31 

23:59:59.000' AND status='complete'






share|improve this answer












share|improve this answer



share|improve this answer










answered 16 hours ago









Mohit chauhanMohit chauhan

498111




498111













  • Thanks Mohit, but it is showing warning that incorrect datetime format

    – Muhammad Anas
    16 hours ago











  • Thanks for answer. +1

    – Muhammad Anas
    15 hours ago



















  • Thanks Mohit, but it is showing warning that incorrect datetime format

    – Muhammad Anas
    16 hours ago











  • Thanks for answer. +1

    – Muhammad Anas
    15 hours ago

















Thanks Mohit, but it is showing warning that incorrect datetime format

– Muhammad Anas
16 hours ago





Thanks Mohit, but it is showing warning that incorrect datetime format

– Muhammad Anas
16 hours ago













Thanks for answer. +1

– Muhammad Anas
15 hours ago





Thanks for answer. +1

– Muhammad Anas
15 hours ago










Muhammad Anas is a new contributor. Be nice, and check out our Code of Conduct.










draft saved

draft discarded


















Muhammad Anas is a new contributor. Be nice, and check out our Code of Conduct.













Muhammad Anas is a new contributor. Be nice, and check out our Code of Conduct.












Muhammad Anas is a new contributor. Be nice, and check out our Code of Conduct.
















Thanks for contributing an answer to Magento Stack Exchange!


  • Please be sure to answer the question. Provide details and share your research!

But avoid …



  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.


To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f267395%2fcustom-report-from-sql-query%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







-

Popular posts from this blog

Færeyskur hestur Heimild | Tengill | Tilvísanir | LeiðsagnarvalRossið - síða um færeyska hrossið á færeyskuGott ár hjá færeyska hestinum

Image
FæreyjarHestar færeyskahjaltlandshestinumíslenski hesturinnBretlandskolanámumenskuWikipediafæreyskuWikipediaRossið - síða um færeyska hrossið á færeysku Færeyskur hestur Úr Wikipediu, frjálsa alfræðiritinu Jump to navigation Jump to search Rani og Grani. Grani í vetrarfeldi. Færeyski hesturinn (færeyska: Føroyska rossið ) er hestur sem hefur lifað í Færeyjum í hundruði ára. Hann er smágerður, 120-132 cm á hæð, og helst skyldur hjaltlandshestinum. Hlutverk hans var að draga vagna og plóg og bera klyfjar. Hann hefur fjórar gangtegundir eins og íslenski hesturinn (þar með talið tölt) og er með fjölda litaafbrigði. Nú til dags er hann notaður til frístunda. Í lok 19. aldar voru til um 800 hross. Mö...
Read more

He _____ here since 1970 . Answer needed [closed]What does “since he was so high” mean?Meaning of “catch birds for”?How do I ensure “since” takes the meaning I want?“Who cares here” meaningWhat does “right round toward” mean?the time tense (had now been detected)What does the phrase “ring around the roses” mean here?Correct usage of “visited upon”Meaning of “foiled rail sabotage bid”It was the third time I had gone to Rome or It is the third time I had been to Rome

Image
Engineer refusing to file/disclose patents Extending the spectral theorem for bounded self adjoint operators to bounded normal operators Do varchar(max), nvarchar(max) and varbinary(max) columns affect select queries? Why is it that I can sometimes guess the next note? What linear sensor for a keyboard? Why don’t women say שלא עשני גויה and שפחה, according to Ashkenazim? Did arcade monitors have same pixel aspect ratio as TV sets? anything or something to eat Query about absorption line spectra Can I use my Chinese passport to enter China after I acquired another citizenship? Fuse symbol on toroidal transformer Create all possible words using a set or letters Does the Mind Blank spell prevent the target from being frightened? Can I sign legal documents with a smiley face? When quoting, must I also copy hyphens used to divide words that continue on the next line? ...
Read more

Slayer Innehåll Historia | Stil, komposition och lyrik | Bandets betydelse och framgångar | Sidoprojekt och samarbeten | Kontroverser | Medlemmar | Utmärkelser och nomineringar | Turnéer och festivaler | Diskografi | Referenser | Externa länkar | Navigeringsmenywww.slayer.net”Metal Massacre vol. 1””Metal Massacre vol. 3””Metal Massacre Volume III””Show No Mercy””Haunting the Chapel””Live Undead””Hell Awaits””Reign in Blood””Reign in Blood””Gold & Platinum – Reign in Blood””Golden Gods Awards Winners”originalet”Kerrang! Hall Of Fame””Slayer Looks Back On 37-Year Career In New Video Series: Part Two””South of Heaven””Gold & Platinum – South of Heaven””Seasons in the Abyss””Gold & Platinum - Seasons in the Abyss””Divine Intervention””Divine Intervention - Release group by Slayer””Gold & Platinum - Divine Intervention””Live Intrusion””Undisputed Attitude””Abolish Government/Superficial Love””Release “Slatanic Slaughter: A Tribute to Slayer” by Various Artists””Diabolus in Musica””Soundtrack to the Apocalypse””God Hates Us All””Systematic - Relationships””War at the Warfield””Gold & Platinum - War at the Warfield””Soundtrack to the Apocalypse””Gold & Platinum - Still Reigning””Metallica, Slayer, Iron Mauden Among Winners At Metal Hammer Awards””Eternal Pyre””Eternal Pyre - Slayer release group””Eternal Pyre””Metal Storm Awards 2006””Kerrang! Hall Of Fame””Slayer Wins 'Best Metal' Grammy Award””Slayer Guitarist Jeff Hanneman Dies””Bullet-For My Valentine booed at Metal Hammer Golden Gods Awards””Unholy Aliance””The End Of Slayer?””Slayer: We Could Thrash Out Two More Albums If We're Fast Enough...””'The Unholy Alliance: Chapter III' UK Dates Added”originalet”Megadeth And Slayer To Co-Headline 'Canadian Carnage' Trek”originalet”World Painted Blood””Release “World Painted Blood” by Slayer””Metallica Heading To Cinemas””Slayer, Megadeth To Join Forces For 'European Carnage' Tour - Dec. 18, 2010”originalet”Slayer's Hanneman Contracts Acute Infection; Band To Bring In Guest Guitarist””Cannibal Corpse's Pat O'Brien Will Step In As Slayer's Guest Guitarist”originalet”Slayer’s Jeff Hanneman Dead at 49””Dave Lombardo Says He Made Only $67,000 In 2011 While Touring With Slayer””Slayer: We Do Not Agree With Dave Lombardo's Substance Or Timeline Of Events””Slayer Welcomes Drummer Paul Bostaph Back To The Fold””Slayer Hope to Unveil Never-Before-Heard Jeff Hanneman Material on Next Album””Slayer Debut New Song 'Implode' During Surprise Golden Gods Appearance””Release group Repentless by Slayer””Repentless - Slayer - Credits””Slayer””Metal Storm Awards 2015””Slayer - to release comic book "Repentless #1"””Slayer To Release 'Repentless' 6.66" Vinyl Box Set””BREAKING NEWS: Slayer Announce Farewell Tour””Slayer Recruit Lamb of God, Anthrax, Behemoth + Testament for Final Tour””Slayer lägger ner efter 37 år””Slayer Announces Second North American Leg Of 'Final' Tour””Final World Tour””Slayer Announces Final European Tour With Lamb of God, Anthrax And Obituary””Slayer To Tour Europe With Lamb of God, Anthrax And Obituary””Slayer To Play 'Last French Show Ever' At Next Year's Hellfst””Slayer's Final World Tour Will Extend Into 2019””Death Angel's Rob Cavestany On Slayer's 'Farewell' Tour: 'Some Of Us Could See This Coming'””Testament Has No Plans To Retire Anytime Soon, Says Chuck Billy””Anthrax's Scott Ian On Slayer's 'Farewell' Tour Plans: 'I Was Surprised And I Wasn't Surprised'””Slayer””Slayer's Morbid Schlock””Review/Rock; For Slayer, the Mania Is the Message””Slayer - Biography””Slayer - Reign In Blood”originalet”Dave Lombardo””An exclusive oral history of Slayer”originalet”Exclusive! Interview With Slayer Guitarist Jeff Hanneman”originalet”Thinking Out Loud: Slayer's Kerry King on hair metal, Satan and being polite””Slayer Lyrics””Slayer - Biography””Most influential artists for extreme metal music””Slayer - Reign in Blood””Slayer guitarist Jeff Hanneman dies aged 49””Slatanic Slaughter: A Tribute to Slayer””Gateway to Hell: A Tribute to Slayer””Covered In Blood””Slayer: The Origins of Thrash in San Francisco, CA.””Why They Rule - #6 Slayer”originalet”Guitar World's 100 Greatest Heavy Metal Guitarists Of All Time”originalet”The fans have spoken: Slayer comes out on top in readers' polls”originalet”Tribute to Jeff Hanneman (1964-2013)””Lamb Of God Frontman: We Sound Like A Slayer Rip-Off””BEHEMOTH Frontman Pays Tribute To SLAYER's JEFF HANNEMAN””Slayer, Hatebreed Doing Double Duty On This Year's Ozzfest””System of a Down””Lacuna Coil’s Andrea Ferro Talks Influences, Skateboarding, Band Origins + More””Slayer - Reign in Blood””Into The Lungs of Hell””Slayer rules - en utställning om fans””Slayer and Their Fans Slashed Through a No-Holds-Barred Night at Gas Monkey””Home””Slayer””Gold & Platinum - The Big 4 Live from Sofia, Bulgaria””Exclusive! Interview With Slayer Guitarist Kerry King””2008-02-23: Wiltern, Los Angeles, CA, USA””Slayer's Kerry King To Perform With Megadeth Tonight! - Oct. 21, 2010”originalet”Dave Lombardo - Biography”Slayer Case DismissedArkiveradUltimate Classic Rock: Slayer guitarist Jeff Hanneman dead at 49.”Slayer: "We could never do any thing like Some Kind Of Monster..."””Cannibal Corpse'S Pat O'Brien Will Step In As Slayer'S Guest Guitarist | The Official Slayer Site”originalet”Slayer Wins 'Best Metal' Grammy Award””Slayer Guitarist Jeff Hanneman Dies””Kerrang! Awards 2006 Blog: Kerrang! Hall Of Fame””Kerrang! Awards 2013: Kerrang! Legend”originalet”Metallica, Slayer, Iron Maien Among Winners At Metal Hammer Awards””Metal Hammer Golden Gods Awards””Bullet For My Valentine Booed At Metal Hammer Golden Gods Awards””Metal Storm Awards 2006””Metal Storm Awards 2015””Slayer's Concert History””Slayer - Relationships””Slayer - Releases”Slayers officiella webbplatsSlayer på MusicBrainzOfficiell webbplatsSlayerSlayerr1373445760000 0001 1540 47353068615-5086262726cb13906545x(data)6033143kn20030215029

Image
SlayerMusikgrupper bildade 1981Amerikanska thrash metal-grupper amerikansktthrash metalHuntington Park1981gitarristernaJeff HannemanKerry KingbasistenTom ArayatrummisenDave LombardoGary HoltPaul Bostaphcertifierats med guldMetallicaAnthraxMegadeththrash metal1986extrema metalgenrerdeath metal22 januari2018USAKanadaEuropaHuntington ParkKalifornien1981gitarristernaJeff HannemanKerry KingbassångDave Lombardoheavy metalbrittiskaIron MaidenJudas PriestthrashMetallicaRattSteeler1982demoundergroundMetal Blade1983high schoolGene HoglanDeathStrapping Young Ladkassettvinyl1984LondonMarquee Club1984Eldorado StudiosTrack Record StudiosLos Angelesmastrade1985CDCombat Recordsextreme metalVenomExodusStudio 54 club1985VHSCombat RecordsBelgienUFORick RubinDef Jam Recordship hoprockakterThe Black CrowesRun–D.M.C.LL Cool JBeastie BoysthrashbpmAngel of DeathRaining BloodAndy WallaceHowie Weinberg1986bildskivaBillboard 200RIAAMetal HammerKerrang!Angela Gossowdeath metalArch Enemythrash metalOverk...
Read more