Two MIGX DB Tables, results of one shown in one CMP selectable FormTab of the other

I see you have:



So you will need:



and a new column with this field: 'teamName_name'

Thanks bruno, tried that but still get the same error

I see you have rosters and team in different schemas/packages.
You should have them all in one xml-schema and in one package.

If that's not possible for some reason, you may need to make sure to load both packages.
The default processors of MIGXdb does only load the package, which is defined with the MIGX-configuration.

Otherwise xpdo doesn't know anything about the other table.

Quote from: Bruno17 at Apr 14, 2013, 12:46 PM

I see you have rosters and team in different schemas/packages.
You should have them all in one xml-schema and in one package.

If that's not possible for some reason, you may need to make sure to load both packages.
The default processors of MIGXdb does only load the package, which is defined with the MIGX-configuration.

Otherwise xpdo doesn't know anything about the other table.

Thats where I've been going wrong - gotcha, brilliant explanation too.

Thanks again for all your help Bruno - do you have a "buy me a beer"/similar link?

Is it possible to add the fields from the other table to the db filter? so something like that:



I just tried that and it seems to break the search functionality, as soon as I remove that "external" field from the DB filter JSON it works again...maybe doing something wrong?

if 'teamName' is the alias and 'name' the fieldname this should do it:

ha =), close, works perfectly! Thanks again Bruno!