MIGx Grid Column Display

126 Posts

bigSlim Reply #1, 10 years, 1 month ago

I have setup MIGx and within it im calling a TV (AllSeminarsList) with a select binding

@SELECT pagetitle, id FROM site_content WHERE parent=21

My Form Tabs looks like this

[
{"caption":"Conference Timetable", "fields": [    
{"field":"time","caption":"Time","inputTV":"KeyNoteTime"},                           
{"field":"seminar","caption":"Seminar","inputTV":"AllSeminarsList"},
{"field":"speakers","caption":"Speakers","inputTV":"AllSpeakersList"}
]}
]

My Grid Columns code looks like this

[
{"header": "Time", "width": "160", "sortable": "false", "dataIndex": "time"},
{"header": "Seminar", "width": "500", "sortable": "false", "dataIndex": "seminar"},
{"header": "Speakers", "width": "500", "sortable": "false", "dataIndex": "speakers"}
]

When running MIGx the Speaker and Seminar lists populate fine however once saving and returning back to the Grid Columns view the columns only show the id of the chosen resource and not the pagetitle.

Am I executing my SELECT call wrong? How do I force the pagetitle to display instead of the id.

It must also be noted that when displaying the MIGX call on the frontend using getImageList call it works perfectly. this is just how I can improve the user experience for the client

Many thanks!

5,888 Posts

Bruno17 Reply #2, 10 years, 1 month ago

see this one:
https://forums.modx.com/thread/90905/migx-renderchunk-to-show-pagetitle-instead-of-id

does this help?

-------------------------------

you can buy me a beer, if you like MIGX

http://webcmsolutions.de/migx.html

Thanks!

126 Posts

bigSlim Reply #3, 10 years, 1 month ago

Hi Bruno

This helps massively and I've pretty much got everything now working however there is one bit I cant figure out.... one of my InputTVs is a multi-select (comma delimited) but the renderChunk isnt pulling multiple values (only works when one value is selected)

I worked my way through the rest of the thread and found an older reply by you regarding a simialar issue where you suggestion was to replace the fastfield tag in the renderChunk Tpl to this

[[migxLoopCollection? 
&classname=`modResource`
&where=`{"id:IN":"[ [[+yourFieldname]] ]"}`
&tpl=`@CODE:[[+pagetitle]]<br />`
]]

I have done this and put in my field name but im still not getting anything showing up in the grid?

Any help much appreciated

bS

5,888 Posts

Bruno17 Reply #4, 10 years, 1 month ago

if you just put your placeholder

[[+yourFieldname]]

into the renderchunk - tpl.
What do you get?

-------------------------------

you can buy me a beer, if you like MIGX

http://webcmsolutions.de/migx.html

Thanks!

126 Posts

bigSlim Reply #5, 10 years ago

Hey Bruno

Apologies for the delay on this...pressures of having too much on!

I stripped the code out and left just as [[+Speaker]]

When one speaker is selected the column grid returns the speaker ID number but when more than one speaker is selected the column grid is empty?

Does this give you any ideas?

126 Posts

bigSlim Reply #6, 10 years ago

Any help/update on this would be appreciated...

bS

23 Posts

just_nico Reply #7, 10 years ago

One solution that works for me:

1) Create a snippet which you use as output modifier

<?php
return '['.$input.']';

2) Use the snippet with

[[+Speaker:yourSnippetName]]

Edit: Make sure your speaker IDs are separated with comma

126 Posts

bigSlim Reply #8, 10 years ago

Thanks for replying...

I've tried your suggestion. On selecting one resource Im getting [id_of_resource] output instead of the pagetitle itself. i.e [123]

When I multi-select all that is output is [] - i.e empty brackets

Not sure why its not picking up the pagetitles?

bS