You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "david Cantero (JIRA)" <ji...@apache.org> on 2009/05/11 13:43:45 UTC
[jira] Created: (OFBIZ-2459) getRelated only find one related
getRelated only find one related
--------------------------------
Key: OFBIZ-2459
URL: https://issues.apache.org/jira/browse/OFBIZ-2459
Project: OFBiz
Issue Type: Bug
Components: framework
Affects Versions: Release Branch 4.0
Environment: windows, linux, java 1.5 and java 1.6, mysql 5.0 and 5.1
Reporter: david Cantero
TABLE1with multiple foreign keys to another TABLE2 returns only one field name . The database is mysql and the log shows the following message:
GenericDelegator.java:250:WARN ] [RelationNameNotUnique] Relation TABLE2 of entity TABLE1 is not unique for that entity.
EXAMPLE CODE TO FIND RELATIONS:
GenericValue table2element = findOne("TABLE2",utilMisc.toMap("table2id", "10000"),false)
relationsList =table2element .getRelated("TABLE1")
The result is the first relation only => fk-name="reference1"
ENTITY MODEL DEFINITION <entitymodel.xml >
<entity entity-name="TABLE1" package-name="OT" title="Entity for storing indicators">
<field name="indicatorId" type="id-ne"></field>
<field name="indicatorName" type="id-long-ne"></field>
<field name="reference1_to_table2" type="id"></field>
<field name="reference2_to_table2" type="id"></field>
<prim-key field="indicatorId"/>
<relation type="one" fk-name="reference1" rel-entity-name="TABLE2">
<key-map field-name="reference1_to_table2" rel-field-name="table2id"/>
</relation>
<relation type="one" fk-name="reference2" rel-entity-name="TABLE2">
<key-map field-name="reference2_to_table2" rel-field-name="table2id"/>
</relation>
</entity>
<entity entity-name="TABLE2" package-name="OT" title="table 2 example">
<field name="table2id" type="id-ne"></field>
<field name="indicatorName" type="id-long-ne"></field>
<prim-key field="table2id"/>
</entity>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (OFBIZ-2459) getRelated only find one related
Posted by "Scott Gray (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-2459?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Scott Gray closed OFBIZ-2459.
-----------------------------
Resolution: Invalid
you need to enter titles on the relations so that they are unique, e.g.
<relation type="one" fk-name="reference1" title="REF1" rel-entity-name="TABLE2">
<relation type="one" fk-name="reference2" title="REF2" rel-entity-name="TABLE2">
you can then do:
getRelated("REF1TABLE1")
getRelated("REF2TABLE1")
> getRelated only find one related
> --------------------------------
>
> Key: OFBIZ-2459
> URL: https://issues.apache.org/jira/browse/OFBIZ-2459
> Project: OFBiz
> Issue Type: Bug
> Components: framework
> Affects Versions: Release Branch 4.0
> Environment: windows, linux, java 1.5 and java 1.6, mysql 5.0 and 5.1
> Reporter: david Cantero
>
> TABLE1with multiple foreign keys to another TABLE2 returns only one field name . The database is mysql and the log shows the following message:
> GenericDelegator.java:250:WARN ] [RelationNameNotUnique] Relation TABLE2 of entity TABLE1 is not unique for that entity.
> EXAMPLE CODE TO FIND RELATIONS:
>
> GenericValue table2element = findOne("TABLE2",utilMisc.toMap("table2id", "10000"),false)
> relationsList =table2element .getRelated("TABLE1")
> The result is the first relation only => fk-name="reference1"
> ENTITY MODEL DEFINITION <entitymodel.xml >
> <entity entity-name="TABLE1" package-name="OT" title="Entity for storing indicators">
>
> <field name="indicatorId" type="id-ne"></field>
> <field name="indicatorName" type="id-long-ne"></field>
> <field name="reference1_to_table2" type="id"></field>
> <field name="reference2_to_table2" type="id"></field>
>
> <prim-key field="indicatorId"/>
>
> <relation type="one" fk-name="reference1" rel-entity-name="TABLE2">
> <key-map field-name="reference1_to_table2" rel-field-name="table2id"/>
> </relation>
>
> <relation type="one" fk-name="reference2" rel-entity-name="TABLE2">
> <key-map field-name="reference2_to_table2" rel-field-name="table2id"/>
> </relation>
>
> </entity>
> <entity entity-name="TABLE2" package-name="OT" title="table 2 example">
>
> <field name="table2id" type="id-ne"></field>
> <field name="indicatorName" type="id-long-ne"></field>
>
> <prim-key field="table2id"/>
> </entity>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (OFBIZ-2459) getRelated only find one related
Posted by "responde (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/OFBIZ-2459?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12708111#action_12708111 ]
responde commented on OFBIZ-2459:
---------------------------------
Thanks for the reply, if you come to spain, madrid, is invited to a beer
-----Mensaje original-----
De: Scott Gray (JIRA) [mailto:jira@apache.org]
Enviado el: lunes, 11 de mayo de 2009 14:30
Para: dhoyos_es@yahoo.es
Asunto: [jira] Closed: (OFBIZ-2459) getRelated only find one related
[ https://issues.apache.org/jira/browse/OFBIZ-2459?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Scott Gray closed OFBIZ-2459.
-----------------------------
Resolution: Invalid
you need to enter titles on the relations so that they are unique, e.g.
<relation type="one" fk-name="reference1" title="REF1" rel-entity-name="TABLE2">
<relation type="one" fk-name="reference2" title="REF2" rel-entity-name="TABLE2">
you can then do:
getRelated("REF1TABLE1")
getRelated("REF2TABLE1")
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
> getRelated only find one related
> --------------------------------
>
> Key: OFBIZ-2459
> URL: https://issues.apache.org/jira/browse/OFBIZ-2459
> Project: OFBiz
> Issue Type: Bug
> Components: framework
> Affects Versions: Release Branch 4.0
> Environment: windows, linux, java 1.5 and java 1.6, mysql 5.0 and 5.1
> Reporter: david Cantero
>
> TABLE1with multiple foreign keys to another TABLE2 returns only one field name . The database is mysql and the log shows the following message:
> GenericDelegator.java:250:WARN ] [RelationNameNotUnique] Relation TABLE2 of entity TABLE1 is not unique for that entity.
> EXAMPLE CODE TO FIND RELATIONS:
>
> GenericValue table2element = findOne("TABLE2",utilMisc.toMap("table2id", "10000"),false)
> relationsList =table2element .getRelated("TABLE1")
> The result is the first relation only => fk-name="reference1"
> ENTITY MODEL DEFINITION <entitymodel.xml >
> <entity entity-name="TABLE1" package-name="OT" title="Entity for storing indicators">
>
> <field name="indicatorId" type="id-ne"></field>
> <field name="indicatorName" type="id-long-ne"></field>
> <field name="reference1_to_table2" type="id"></field>
> <field name="reference2_to_table2" type="id"></field>
>
> <prim-key field="indicatorId"/>
>
> <relation type="one" fk-name="reference1" rel-entity-name="TABLE2">
> <key-map field-name="reference1_to_table2" rel-field-name="table2id"/>
> </relation>
>
> <relation type="one" fk-name="reference2" rel-entity-name="TABLE2">
> <key-map field-name="reference2_to_table2" rel-field-name="table2id"/>
> </relation>
>
> </entity>
> <entity entity-name="TABLE2" package-name="OT" title="table 2 example">
>
> <field name="table2id" type="id-ne"></field>
> <field name="indicatorName" type="id-long-ne"></field>
>
> <prim-key field="table2id"/>
> </entity>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.