Answered ::SOLVED:: Migxdb alias how to show items from other table

3 Posts

lgonzales Reply #1, 11 years, 10 months ago

Hi sorry for my english, i try show one field from other table in grid with migx db, create the scheme and alias but not found.
this is my scheme is correct?

<?xml version="1.0" encoding="UTF-8"?>
<model package="lgonzales" baseClass="xPDOObject" platform="mysql" defaultEngine="MyISAM" version="1.1">
	<object class="equipos" table="esan_equipos" extends="xPDOSimpleObject" >
		<field key="eq_tipo" dbtype="int" precision="4" phptype="integer" null="false" default="1" />
		<field key="eq_marca" dbtype="int" precision="4" phptype="integer" null="false" default="1" />
		<field key="eq_modelo" dbtype="int" precision="4" phptype="integer" null="false" default="1" />
		<field key="eq_serie" dbtype="varchar" precision="255" phptype="string" null="false" />
		<field key="eq_estado" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
		<field key="eq_aula" dbtype="int" precision="3" phptype="integer" null="false" default="1" />
		<field key="createdby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
		<field key="createdon" dbtype="datetime" phptype="datetime" null="false" />
		<field key="editedby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
		<field key="editedon" dbtype="datetime" phptype="datetime" null="false" />
		<field key="deleted" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
		<field key="deletedon" dbtype="datetime" phptype="datetime" null="false" />
		<field key="deletedby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
		<field key="publishedon" dbtype="datetime" phptype="datetime" null="false" />
		<field key="publishedby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
		<index alias="PRIMARY" name="PRIMARY" primary="true" unique="true">
			<column key="id" collation="A" null="false" />
		</index>
		<aggregate alias="Resource" class="modResource" local="resource_id" foreign="id" cardinality="one" owner="foreign" />
		<aggregate alias="Creator" class="modUser" local="createdby" foreign="id" cardinality="one" owner="foreign" />
		<aggregate alias="EditedBy" class="modUser" local="editedby" foreign="id" cardinality="one" owner="foreign"/>
		<aggregate alias="EquipoTipo" class="eqTipo" local="eq_tipo" foreign="id" cardinality="one" owner="foreign" />
		<aggregate alias="EquipoAula" class="eqAula" local="eq_aula" foreign="id" cardinality="one" owner="foreign" />
		<aggregate alias="EquipoModelo" class="eqModelo" local="eq_modelo" foreign="id" cardinality="one" owner="foreign" />
		<aggregate alias="EquipoMarca" class="eqMarca" local="eq_marca" foreign="id" cardinality="one" owner="foreign" />
		<composite alias="Software" class="software" local="eq_aula" foreign="id" cardinality="one" owner="foreign" />
	</object>
	<object class="eqTipo" table="esan_tipo" extends="xPDOSimpleObject" >
		<field key="et_nombre" dbtype="varchar" precision="255" phptype="string" null="false" />
		<field key="createdby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
		<field key="createdon" dbtype="datetime" phptype="datetime" null="false" />
		<field key="editedby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
		<field key="editedon" dbtype="datetime" phptype="datetime" null="false" />
		<field key="deleted" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
		<field key="deletedon" dbtype="datetime" phptype="datetime" null="false" />
		<field key="deletedby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
		<field key="publishedon" dbtype="datetime" phptype="datetime" null="false" />
		<field key="publishedby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
		<index alias="PRIMARY" name="PRIMARY" primary="true" unique="true">
			<column key="id" collation="A" null="false" />
		</index>
		<aggregate alias="Resource" class="modResource" local="resource_id" foreign="id" cardinality="one" owner="foreign" />
		<aggregate alias="Creator" class="modUser" local="createdby" foreign="id" cardinality="one" owner="foreign" />
		<aggregate alias="EditedBy" class="modUser" local="editedby" foreign="id" cardinality="one" owner="foreign"/>
	</object>
	<object class="eqMarca" table="esan_marca" extends="xPDOSimpleObject" >
		<field key="ema_nombre" dbtype="varchar" precision="255" phptype="string" null="false" />
		<field key="createdby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
		<field key="createdon" dbtype="datetime" phptype="datetime" null="false" />
		<field key="editedby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
		<field key="editedon" dbtype="datetime" phptype="datetime" null="false" />
		<field key="deleted" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
		<field key="deletedon" dbtype="datetime" phptype="datetime" null="false" />
		<field key="deletedby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
		<field key="publishedon" dbtype="datetime" phptype="datetime" null="false" />
		<field key="publishedby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
		<index alias="PRIMARY" name="PRIMARY" primary="true" unique="true">
			<column key="id" collation="A" null="false" />
		</index>
		<aggregate alias="Resource" class="modResource" local="resource_id" foreign="id" cardinality="one" owner="foreign" />
		<aggregate alias="Creator" class="modUser" local="createdby" foreign="id" cardinality="one" owner="foreign" />
		<aggregate alias="EditedBy" class="modUser" local="editedby" foreign="id" cardinality="one" owner="foreign"/>
	</object>
	<object class="eqModelo" table="esan_modelo" extends="xPDOSimpleObject" >
		<field key="em_nombre" dbtype="varchar" precision="255" phptype="string" null="false" />
		<field key="createdby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
		<field key="createdon" dbtype="datetime" phptype="datetime" null="false" />
		<field key="editedby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
		<field key="editedon" dbtype="datetime" phptype="datetime" null="false" />
		<field key="deleted" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
		<field key="deletedon" dbtype="datetime" phptype="datetime" null="false" />
		<field key="deletedby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
		<field key="publishedon" dbtype="datetime" phptype="datetime" null="false" />
		<field key="publishedby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
		<index alias="PRIMARY" name="PRIMARY" primary="true" unique="true">
			<column key="id" collation="A" null="false" />
		</index>
		<aggregate alias="Resource" class="modResource" local="resource_id" foreign="id" cardinality="one" owner="foreign" />
		<aggregate alias="Creator" class="modUser" local="createdby" foreign="id" cardinality="one" owner="foreign" />
		<aggregate alias="EditedBy" class="modUser" local="editedby" foreign="id" cardinality="one" owner="foreign"/>
	</object>
	<object class="eqAula" table="esan_aula" extends="xPDOSimpleObject" >
		<field key="ea_nombre" dbtype="varchar" precision="255" phptype="string" null="false" />
		<field key="createdby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
		<field key="createdon" dbtype="datetime" phptype="datetime" null="false" />
		<field key="editedby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
		<field key="editedon" dbtype="datetime" phptype="datetime" null="false" />
		<field key="deleted" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
		<field key="deletedon" dbtype="datetime" phptype="datetime" null="false" />
		<field key="deletedby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
		<field key="publishedon" dbtype="datetime" phptype="datetime" null="false" />
		<field key="publishedby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
		<index alias="PRIMARY" name="PRIMARY" primary="true" unique="true">
			<column key="id" collation="A" null="false" />
		</index>
		<aggregate alias="Resource" class="modResource" local="resource_id" foreign="id" cardinality="one" owner="foreign" />
		<aggregate alias="Creator" class="modUser" local="createdby" foreign="id" cardinality="one" owner="foreign" />
		<aggregate alias="EditedBy" class="modUser" local="editedby" foreign="id" cardinality="one" owner="foreign"/>
	</object>
	<object class="software" table="esan_software" extends="xPDOSimpleObject" >
		<field key="sw_nombre" dbtype="varchar" precision="255" phptype="string" null="false" />
		<field key="sw_tipo_licencia" dbtype="varchar" precision="255" phptype="string" null="false" />
		<field key="sw_licencias" dbtype="int" precision="4" phptype="integer" null="false" default="1" />
		<field key="createdby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
		<field key="createdon" dbtype="datetime" phptype="datetime" null="false" />
		<field key="editedby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
		<field key="editedon" dbtype="datetime" phptype="datetime" null="false" />
		<field key="deleted" dbtype="tinyint" precision="1" attributes="unsigned" phptype="integer" null="false" default="0" />
		<field key="deletedon" dbtype="datetime" phptype="datetime" null="false" />
		<field key="deletedby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
		<field key="publishedon" dbtype="datetime" phptype="datetime" null="false" />
		<field key="publishedby" dbtype="int" precision="10" phptype="integer" null="false" default="0" />
		<index alias="PRIMARY" name="PRIMARY" primary="true" unique="true">
			<column key="id" collation="A" null="false" />
		</index>
		<aggregate alias="Resource" class="modResource" local="resource_id" foreign="id" cardinality="one" owner="foreign" />
		<aggregate alias="Creator" class="modUser" local="createdby" foreign="id" cardinality="one" owner="foreign" />
		<aggregate alias="EditedBy" class="modUser" local="editedby" foreign="id" cardinality="one" owner="foreign"/>
	</object>
</model>

and in the migxdb-settings in Joins

[{"alias":"EquipoTipo","selectfields":"et_nombre"}]

in columns Header TIPO and field et_nombre but not show the value :S any idea

TY for the help

This question has been answered by lgonzales. See the first response.

[ed. note: lgonzales last edited this post 11 years, 10 months ago.]

- 5,888 Posts
Bruno17 Reply #2, 11 years, 10 months ago
your field will be:
```
EquipoTipo_et_nombre
```
you should see all returned fields, when you look into the firebug - console in the returned ajax-response by refreshing the grid
-------------------------------

you can buy me a beer, if you like MIGX

http://webcmsolutions.de/migx.html

Thanks!
discuss.answer
- 3 Posts
lgonzales Reply #3, 11 years, 10 months ago

Hi Bruno17 TY, but nothing in the firebug show only
{"success":true,"total":"1","results":[{"id":1,"eq_tipo":1,"eq_marca":1,"eq_modelo":1,"eq_serie":"asdasd","eq_estado":0,"eq_aula":1,"createdby":1,"createdon":"2014-11-14 20:56:30","editedby":0,"editedon":"-1-11-30 00:00:00","deleted":0,"deletedon":"-1-11-30 00:00:00","deletedby":0,"publishedon":"2014-11-14 20:56:30","publishedby":1}]}

no see EquipoTipo_et_nombre what's wrong, sorry

Edit:

Sorry TY Bruno, just work, all fine, my error

Solved [ed. note: lgonzales last edited this post 11 years, 10 months ago.]