I've been trying without success to obtain all the orders that were approved (not all lines must be approved to be considered an approved order) and orders that were COMPLETELY cancelled given the approver email.

Once the order is placed in MAGENTO, all the information is stored in 2 tables (ORDER_INFO_TABLE and APPROVE_TABLE).

Take a look at this image:



I've been trying different queries but no one really helped me :(

I want to obtain ALL THE ORDERS that were APPROVED & COMPLETELY CANCELLED for a specific approver.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.