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.










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
    2 days ago











  • I need sum amount

    – Muhammad Anas
    2 days 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.










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
    2 days ago











  • I need sum amount

    – Muhammad Anas
    2 days 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.










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






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 2 days ago









Muhammad Hasham

2,7012831




2,7012831






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 2 days ago









Muhammad AnasMuhammad Anas

16413




16413




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
    2 days ago











  • I need sum amount

    – Muhammad Anas
    2 days 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
    2 days ago











  • I need sum amount

    – Muhammad Anas
    2 days 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
2 days 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
2 days ago













I need sum amount

– Muhammad Anas
2 days ago





I need sum amount

– Muhammad Anas
2 days 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
    2 days 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
    2 days ago











  • Thanks for answer. +1

    – Muhammad Anas
    2 days 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
    2 days 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
    2 days 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 2 days ago









magefmsmagefms

2,0822426




2,0822426








  • 1





    It worked. Thanks

    – Muhammad Anas
    2 days ago














  • 1





    It worked. Thanks

    – Muhammad Anas
    2 days ago








1




1





It worked. Thanks

– Muhammad Anas
2 days ago





It worked. Thanks

– Muhammad Anas
2 days 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
    2 days ago











  • Thanks for answer. +1

    – Muhammad Anas
    2 days 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
    2 days ago











  • Thanks for answer. +1

    – Muhammad Anas
    2 days 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 2 days ago









Mohit chauhanMohit chauhan

516112




516112













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

    – Muhammad Anas
    2 days ago











  • Thanks for answer. +1

    – Muhammad Anas
    2 days ago



















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

    – Muhammad Anas
    2 days ago











  • Thanks for answer. +1

    – Muhammad Anas
    2 days ago

















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

– Muhammad Anas
2 days ago





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

– Muhammad Anas
2 days ago













Thanks for answer. +1

– Muhammad Anas
2 days ago





Thanks for answer. +1

– Muhammad Anas
2 days 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

數位音樂下載

When can things happen in Etherscan, such as the picture below?

格利澤436b