You have not defined the prim-key fields and also you have not defined the foreign key relationships if any of the field is coming from some other entity.
On Mon, Apr 21, 2008 at 10:45 AM, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > One thing that jumps out at me is that I see no primary key. > > Perhaps adding > > <prim-key field="asset_itemid"/> > > and maybe if asset_itemid is not always unique > > <prim-key field="depid"/> > > -----Original Message----- > From: Nattanicha Rittammanart [mailto:[EMAIL PROTECTED] > Sent: Sunday, April 20, 2008 1:38 PM > To: user@ofbiz.apache.org > Subject: Query entity > > > > > Hi all, > > I have a problem to ask you. > > I have table like this: > > > > <entity package-name="org.ofbiz.ams.ams" > > entity-name="DepreciationTrans" title="Keeps depreication record from > > depreciation table which created in each period"> > > <field type="id-ne" name="asset_itemid"></field> > > <field type="id-ne" name="depid"/> > > <field type="id" name="account_no"/> > > <field type="currency-amount" name="value_before_cal"/> > > </entity> > > > > I want to show it by using form, I do like this: > > > > <form name="ShowDepreTables" type="list" list-name="depre_to_dates" > > paginate-target="ShowDepreTable"> > > <actions> > > <entity-condition entity-name="DepreciationTrans"><order-by > > field-name="calculate_date"/></entity-condition> > > </actions> > > <field name="asset_itemid" title="asset > itemid"><display/></field> > > <field name="depid" title="department id"><display/></field> > > <field name="account_no" title="account > number"><display/></field> > > <field name="value_before_cal" title="before > > price"><display/></field> > > </form> > > > > But asset_itemid is a field which link from another table. If I show > > table as above, it will show asset_itemid. What I want is, I need it > > to show asset_item_name. So, I do like this: > > > > ...... > > <field name="asset_itemid" title="asset item name"> > > <display-entity entity-name="AssetItems" > > description="${asset_item_desc}" > > key-field-name="asset_itemid"></display-entity> > > </field> > > ...... > > > > But it caused error like this > > > > org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen > > [component://ams/widget/common/CommonScreens.xml#GlobalDecorator]: > > java.lang.IllegalArgumentException: Error getting value from the > > database for display of field [asset_itemid] on form > > [ShowDepreTables]: org.ofbiz.entity.GenericModelException: > > [GenericDelegator.findOne] Passed primary key is not a valid primary > > key: > > > [GenericEntity:AssetItems][asset_itemid,08000200010002(java.lang.String)] > > (Error getting value from the database for display of field > > [asset_itemid] on form [ShowDepreTables]: > > org.ofbiz.entity.GenericModelException: [GenericDelegator.findOne] > > Passed primary key is not a valid primary key: > > > [GenericEntity:AssetItems][asset_itemid,08000200010002(java.lang.String)]) > > > > > > How can I do to link asset_item_name from another table to show in > > table which has asset_itemid?? > > > > Thank in advances, > > Nattanicha > > > > > No virus found in this incoming message. > Checked by AVG. > Version: 7.5.524 / Virus Database: 269.23.0/1381 - Release Date: 4/16/2008 > 9:34 AM > > No virus found in this outgoing message. > Checked by AVG. > Version: 7.5.524 / Virus Database: 269.23.0/1381 - Release Date: 4/16/2008 > 9:34 AM > > -- Thanks & Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com [EMAIL PROTECTED]