How to display MIGX list in regular TV list box (multiple choice)?

Question

MODX

Friends, there is hope that there is a solution, I will describe the situation. There is a page on CMS MODX REVO.
The PROJECTS block was created there. Created as TV MIGX. Everything is simple.
But there are still other pages, and in the admin panel there is a task to link certain PROJECTS to each page.
a simple solution to make projects as pages, and there are no problems, but I don’t want to start a resource for each project, since there is only a photo and a title, therefore MIGX.
And now I don’t even know how in the TV field list (multiple choice), to cling to certain projects from the MIGX field.
Usually, this is how I display the pages in the TV list settings in the "possible values" field, enter the SQL selection

@SELECT pagetitle, id FROM modx_site_content WHERE parent=3

And further on the page I deduce by ID. And I don’t know how to do it now :(
Tell me the solution please.

Answer 1

Regular MIGX stores tv data in JSON format, so to extract this data, you should not make a selection from the database, but perform certain operations with the data. For example, this is how you can run a snippet:
Or the second option is to use MIGXdb. Then it will be possible to receive data through @SELECT