The problem I'm having is when I use webtools to export the data I get
a SQL error because the entity engine adds the following ofbiz columns to the SQL query: LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP Since the table is not an ofbiz entity the columns do not exist and the generated query will fail. Is there a way to specify in the entity model to only use those columns that are explicitly defined in the definition file? |
Administrator
|
There is a parameter no-auto-stamp for entities
Jacques From: "Gnanashankar Shanmugam" <[hidden email]> > The problem I'm having is when I use webtools to export the data I get > a SQL error because the entity engine adds the following ofbiz columns > to the SQL query: > > LAST_UPDATED_STAMP, > LAST_UPDATED_TX_STAMP, > CREATED_STAMP, > CREATED_TX_STAMP > > > Since the table is not an ofbiz entity the columns do not exist and > the generated query will fail. Is there a way to specify in the > entity model to only use those columns that are explicitly defined in > the definition file? > |
hi jacques, In EntityEngine.xml, where i have to give no-auto-stamp
parameter for entities..any explain clearly..Advance thanks.. On Wed, Sep 30, 2009 at 2:24 PM, Jacques Le Roux < [hidden email]> wrote: > There is a parameter no-auto-stamp for entities > > Jacques > > From: "Gnanashankar Shanmugam" <[hidden email]> > > The problem I'm having is when I use webtools to export the data I get >> a SQL error because the entity engine adds the following ofbiz columns >> to the SQL query: >> >> LAST_UPDATED_STAMP, >> LAST_UPDATED_TX_STAMP, >> CREATED_STAMP, >> CREATED_TX_STAMP >> >> >> Since the table is not an ofbiz entity the columns do not exist and >> the generated query will fail. Is there a way to specify in the >> entity model to only use those columns that are explicitly defined in >> the definition file? >> >> > |
Administrator
|
It's an attribute of Entity, see entitymodel.xml
Jacques From: "Gnanashankar Shanmugam" <[hidden email]> > hi jacques, In EntityEngine.xml, where i have to give no-auto-stamp > parameter for entities..any explain clearly..Advance thanks.. > > On Wed, Sep 30, 2009 at 2:24 PM, Jacques Le Roux < > [hidden email]> wrote: > >> There is a parameter no-auto-stamp for entities >> >> Jacques >> >> From: "Gnanashankar Shanmugam" <[hidden email]> >> >> The problem I'm having is when I use webtools to export the data I get >>> a SQL error because the entity engine adds the following ofbiz columns >>> to the SQL query: >>> >>> LAST_UPDATED_STAMP, >>> LAST_UPDATED_TX_STAMP, >>> CREATED_STAMP, >>> CREATED_TX_STAMP >>> >>> >>> Since the table is not an ofbiz entity the columns do not exist and >>> the generated query will fail. Is there a way to specify in the >>> entity model to only use those columns that are explicitly defined in >>> the definition file? >>> >>> >> > |
hi jacques,
i created new component called entitytest, in that entitytest component entitymodel.xml, i created new entity called Planet. given below i wrote entity like <entity entity-name="Planet" package-name="org.ofbiz.entitytest"> <field name="planetId" type="id-ne"/> <field name="planetName" type="name"/> <field name="fromDate" type="date-time"/> <field name="thruDate" type="date-time"/> <prim-key field="planetId"/> <index name="PLANET_NAME_IDX" unique="true"> <index-field name="planetName"/> </index> </entity> in the above entity where i have to specific parameter no-auto-stamp. On Wed, Sep 30, 2009 at 3:00 PM, Jacques Le Roux < [hidden email]> wrote: > It's an attribute of Entity, see entitymodel.xml > > > Jacques > > From: "Gnanashankar Shanmugam" <[hidden email]> > >> hi jacques, In EntityEngine.xml, where i have to give no-auto-stamp >> parameter for entities..any explain clearly..Advance thanks.. >> >> On Wed, Sep 30, 2009 at 2:24 PM, Jacques Le Roux < >> [hidden email]> wrote: >> >> There is a parameter no-auto-stamp for entities >>> >>> Jacques >>> >>> From: "Gnanashankar Shanmugam" <[hidden email]> >>> >>> The problem I'm having is when I use webtools to export the data I get >>> >>>> a SQL error because the entity engine adds the following ofbiz columns >>>> to the SQL query: >>>> >>>> LAST_UPDATED_STAMP, >>>> LAST_UPDATED_TX_STAMP, >>>> CREATED_STAMP, >>>> CREATED_TX_STAMP >>>> >>>> >>>> Since the table is not an ofbiz entity the columns do not exist and >>>> the generated query will fail. Is there a way to specify in the >>>> entity model to only use those columns that are explicitly defined in >>>> the definition file? >>>> >>>> >>>> >>> >> > |
<entity entity-name="Planet" package-name="org.ofbiz.entitytest" no-
auto-stamp="true"> Regards Scott On 30/09/2009, at 10:51 PM, Gnanashankar Shanmugam wrote: > hi jacques, > i created new component called entitytest, in that entitytest > component > entitymodel.xml, i created new entity called Planet. given below i > wrote > entity like > > <entity entity-name="Planet" package-name="org.ofbiz.entitytest"> > <field name="planetId" type="id-ne"/> > <field name="planetName" type="name"/> > <field name="fromDate" type="date-time"/> > <field name="thruDate" type="date-time"/> > <prim-key field="planetId"/> > <index name="PLANET_NAME_IDX" unique="true"> > <index-field name="planetName"/> > </index> > </entity> > > in the above entity where i have to specific parameter no-auto-stamp. > > On Wed, Sep 30, 2009 at 3:00 PM, Jacques Le Roux < > [hidden email]> wrote: > >> It's an attribute of Entity, see entitymodel.xml >> >> >> Jacques >> >> From: "Gnanashankar Shanmugam" <[hidden email]> >> >>> hi jacques, In EntityEngine.xml, where i have to give no-auto-stamp >>> parameter for entities..any explain clearly..Advance thanks.. >>> >>> On Wed, Sep 30, 2009 at 2:24 PM, Jacques Le Roux < >>> [hidden email]> wrote: >>> >>> There is a parameter no-auto-stamp for entities >>>> >>>> Jacques >>>> >>>> From: "Gnanashankar Shanmugam" <[hidden email]> >>>> >>>> The problem I'm having is when I use webtools to export the data >>>> I get >>>> >>>>> a SQL error because the entity engine adds the following ofbiz >>>>> columns >>>>> to the SQL query: >>>>> >>>>> LAST_UPDATED_STAMP, >>>>> LAST_UPDATED_TX_STAMP, >>>>> CREATED_STAMP, >>>>> CREATED_TX_STAMP >>>>> >>>>> >>>>> Since the table is not an ofbiz entity the columns do not exist >>>>> and >>>>> the generated query will fail. Is there a way to specify in the >>>>> entity model to only use those columns that are explicitly >>>>> defined in >>>>> the definition file? >>>>> >>>>> >>>>> >>>> >>> >> smime.p7s (3K) Download Attachment |
Hi Scott and jacques,
thank you lot..i got answer..unwanted field are removed from entity.. On Wed, Sep 30, 2009 at 3:40 PM, Scott Gray <[hidden email]>wrote: > <entity entity-name="Planet" package-name="org.ofbiz.entitytest" > no-auto-stamp="true"> > > Regards > Scott > > > On 30/09/2009, at 10:51 PM, Gnanashankar Shanmugam wrote: > > hi jacques, >> i created new component called entitytest, in that entitytest component >> entitymodel.xml, i created new entity called Planet. given below i wrote >> entity like >> >> <entity entity-name="Planet" package-name="org.ofbiz.entitytest"> >> <field name="planetId" type="id-ne"/> >> <field name="planetName" type="name"/> >> <field name="fromDate" type="date-time"/> >> <field name="thruDate" type="date-time"/> >> <prim-key field="planetId"/> >> <index name="PLANET_NAME_IDX" unique="true"> >> <index-field name="planetName"/> >> </index> >> </entity> >> >> in the above entity where i have to specific parameter no-auto-stamp. >> >> On Wed, Sep 30, 2009 at 3:00 PM, Jacques Le Roux < >> [hidden email]> wrote: >> >> It's an attribute of Entity, see entitymodel.xml >>> >>> >>> Jacques >>> >>> From: "Gnanashankar Shanmugam" <[hidden email]> >>> >>> hi jacques, In EntityEngine.xml, where i have to give no-auto-stamp >>>> parameter for entities..any explain clearly..Advance thanks.. >>>> >>>> On Wed, Sep 30, 2009 at 2:24 PM, Jacques Le Roux < >>>> [hidden email]> wrote: >>>> >>>> There is a parameter no-auto-stamp for entities >>>> >>>>> >>>>> Jacques >>>>> >>>>> From: "Gnanashankar Shanmugam" <[hidden email]> >>>>> >>>>> The problem I'm having is when I use webtools to export the data I get >>>>> >>>>> a SQL error because the entity engine adds the following ofbiz columns >>>>>> to the SQL query: >>>>>> >>>>>> LAST_UPDATED_STAMP, >>>>>> LAST_UPDATED_TX_STAMP, >>>>>> CREATED_STAMP, >>>>>> CREATED_TX_STAMP >>>>>> >>>>>> >>>>>> Since the table is not an ofbiz entity the columns do not exist and >>>>>> the generated query will fail. Is there a way to specify in the >>>>>> entity model to only use those columns that are explicitly defined in >>>>>> the definition file? >>>>>> >>>>>> >>>>>> >>>>>> >>>>> >>>> >>> > |
Free forum by Nabble | Edit this page |