Author Topic: [Database]: How to get the custom fields for products in an Order?  (Read 338 times)

EvanGR

  • Jr. Member
  • **
  • Posts: 451
[Database]: How to get the custom fields for products in an Order?
« on: September 30, 2021, 13:14:18 pm »
Database related question, didn't know which subforum to ask...

I am building a custom SQL query, and I want to get the selected custom fields for each product in a given Order.
I mostly care about the strings (labels) so I can print a report.
e.g.
T-shirt Red XL

Can you help me find the DB structure for that info, and perhaps some pseudocode for the logic?

Thank you