How to display a list of product options in the tv field?

Question

MODX

How to display a list of product options in the tv field?
like @SELECT concat(`pagetitle`, ' (', `id`, ')') , `id` FROM `modx_site_content` where `class_key` = 'msProduct' and `deleted` = 0 and `published` = 1
in this example, the list of product names is entered, and the output is Id, and I need to get a list of product options and the output is the option key

Answer 1

You need to select modx_ms2_product_options from another table :
https://github.com/Ibochkarev/miniShop2/blob/maste...