We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 38705
    • 101 Posts
    Hi,
    i have created a migxDB "products" succesfully and filled it with items.
    Each item has a column "resource", for linking this item to be shown with the getImageList in that resource, which works.
    On the top-menu (manager) i got a menu-item which directs me to the overview of the complete migxDB table.

    If i create a migxdb-tv with config "products" and go to a resource (in the manager) and load the grid i get nothing.
    How would i go about retrieving the items that only apply for that resource?
    Mind you there is a column in the migxdb with the correct resource-number in it available.

    I think i missed some info along the way :-s but cannot figure it out...

    Cheers,
    Michiel
      Addict since 2012....
      • 4172
      • 5,888 Posts
      If you would set it up like here
      http://rtfm.modx.com/extras/revo/migxdb/migxdb.tutorials/migxdb.create-a-basic-gallery-management-from-scratch-with-migxdb

      see this lines in the schema:

      <field key="resource_id" dbtype="int" precision="11" phptype="integer" null="false" default="0" />
      
      <aggregate alias="Resource" class="modResource" local="resource_id" foreign="id" cardinality="one" owner="foreign" />


      it should work automatically
        -------------------------------

        you can buy me a beer, if you like MIGX

        http://webcmsolutions.de/migx.html

        Thanks!