How to display a list of MIGX TV field in the normal list (multiple choice)?

Friends, there is hope that there is a solution, describe the situation. There is a page on the CMS MODX REVO.
There are established PROJECTS. Created as a MIGX TV. It's simple.
But still there are other pages in the admin area there is a task to cling to every page of these or those PROJECTS.

a simple solution to make the projects page, and there is no problem, but do not want each project to have the resource, because there are only pictures and the title, so MIGX.

And don't even know how in TV list field (multiple selection) to pick up projects from the field of MIGX.
Usually because the page is output in the settings of the TV list in the "possible value" enter a sample SQL
@SELECT pagetitle, id FROM modx_site_content WHERE parent=3


And then on the page output by ID. How to do now I'll never know :(
Could you tell me the solution please.
March 19th 20 at 08:52
1 answer
March 19th 20 at 08:54
Normal MIGX tv stores data in JSON format, so the extraction of this data should not fetch from the database to do, and to perform certain data operations. For example, you can run the snippet:
@EVAL return $modx->runSnippet('snippet-name', array('key'=>'value'));

Or the second option is the use of MIGXdb. Then we can get data using @SELECT
It is clear, but how to find MIGX? There is only the id of the page where it is used. Know Migx is MIGX_id but I've never seen a request in BD how to use it to obtain a list of fields. - Susanna_Braun commented on March 19th 20 at 08:57
@Susanna_Braun, in the case of getImageList, you just need to specify:
docid — the id of the resource;
tvname — the name of the tv field;
tpl — chunk output;
outputSeparator — to specify '||'

The result after your EVAL should look like
'key==value||key2==value2'
or 'value||value2'
- Wilhelmin commented on March 19th 20 at 09:00
@Wilhelmin, I badly explained, the fact that online a withdrawal and I still don't take it, I would like in the ADMIN panel tv in the LIST (multiple selection) how to select a single MIGX tv. But I think it's impossible to do that way. - Susanna_Braun commented on March 19th 20 at 09:03
@Susanna_Braun, I just wrote about this. Your tv list of multiple choice in a field of possible values, make the
@EVAL return $modx->runSnippet('getImageList', array(
'docid'=>'1' ... 
));
- Wilhelmin commented on March 19th 20 at 09:06
@Wilhelmin, I still don't understand how this query will find I need MIGX tv, so the void appears @eval return $modx->runSnippet('getImageList', array('docid'=>'1')); - Susanna_Braun commented on March 19th 20 at 09:09
@Susanna_Braun, array should contain the correct settings. Complete the call parameters, which I have mentioned in the second comment. If that doesn't work, show configuration migx - Wilhelmin commented on March 19th 20 at 09:12

Find more questions by tags MODX