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....
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