I have a MIGXDB custom manager page where the client enters all their details about images.
Part of the DB are fields for selecting resources the images link to. For example a resource named “Jane Doe” is ID 10, and so in the MIGXDB there is a field for “authors” and it contains 10.
I didn’t originally build this site, but the way they linked the images to various resources is explicitly defined in the MIGXDB data, not the resource. In other words, the resource doesn’t choose what images belong to itself, the MIGXDB data chooses what resource it belongs to.
It feels kind of backwards to me but whatever.
Now I need to do the not-backwards way. I need to create resources which should have a TV where the client can choose any image in the entire MIGXDB dataset.
Imagine we had a “image of the week” page and the client just wants to edit the page and select a new image using a TV.
I can’t find such a TV.
I’ve found lots of examples of TVs that can choose from lists of tags and categories and resources, but none that choose from MIGXDB CMP data itself.
What I’d like is for the client to open the resource and go to the TVs area, and be presented with a small table with thumbnails, titles, few other bits of data, and search/filter so they can find the image(s) they need to select (there is almost 7000 images).
Then in the template I just need to pull these images out of the MIGXDB data and use all the fields connected to that image that I need.
I know I must be missing something. Does MIGX not come with a TV that helps select items from the MIGXDB data we create? How are resources and MIGXDB data meant to be related if not explicitly defined in the MIGX data itself?
I know I can use getImageList for getting the data, but I need my resource to first define which rows I want to return via a TV selection in the first place!
Any help would be lovely!