Skip to content

Instantly share code, notes, and snippets.

@zeloc
zeloc / order_notes.sql
Created August 16, 2018 08:11
sql to get all sales order notes in magento 2
select `order`.`increment_id` as `Sales Order`, DATE(`note`.`created_at`) as `Date`, TIME(`note`.`created_at`) as `Time`, `note`.`comment` as `Note`
FROM `sales_order` AS `order`
JOIN `sales_order_status_history` as `note`
ON `note`.`parent_id` = `order`.`entity_id`;
@zeloc
zeloc / 0_reuse_code.js
Created April 13, 2014 14:47
Here are some things you can do with Gists in GistBox.
// Use Gists to store code you would like to remember later on
console.log(window); // log the "window" object to the console