You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by rtrujillo <RT...@touchnet.com> on 2007/01/04 21:09:42 UTC
Generic field types
I am looking for the defined list of Ofbiz generic field types.
I have searched the documentation and nabble.com, but I can not find any
documentation.
I found the the fieldtype[db type].xml files, but not the list of defined
field types.
Also, for other databases not defined, can I create my own fieldtype[db
type].xml file?
<fieldtypemodel xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="http://www.ofbiz.org/dtds/fieldtypemodel.xsd">
<!-- ===================== field-type-def ==================== -->
<!-- General Types -->
<field-type-def type="blob" sql-type="IMAGE"
java-type="java.lang.Object"></field-type-def>
<field-type-def type="date-time" sql-type="DATETIME"
java-type="java.sql.Timestamp"></field-type-def>
<field-type-def type="date" sql-type="DATETIME"
java-type="java.sql.Date"></field-type-def>
<field-type-def type="time" sql-type="DATETIME"
java-type="java.sql.Time"></field-type-def>
<field-type-def type="currency-amount" sql-type="DECIMAL(18,2)"
java-type="Double"><validate method="isSignedDouble" /></field-type-def>
<field-type-def type="currency-precise" sql-type="DECIMAL(18,3)"
java-type="Double"><validate method="isSignedDouble" /></field-type-def>
<field-type-def type="floating-point" sql-type="FLOAT"
java-type="Double"><validate method="isSignedDouble" /></field-type-def>
<field-type-def type="numeric" sql-type="INT" java-type="Long"><validate
method="isSignedLong" /></field-type-def>
<field-type-def type="id" sql-type="VARCHAR(20)"
java-type="String"></field-type-def>
<field-type-def type="id-long" sql-type="VARCHAR(60)"
java-type="String"></field-type-def>
<field-type-def type="id-vlong" sql-type="VARCHAR(250)"
java-type="String"></field-type-def>
<field-type-def type="indicator" sql-type="CHAR(1)"
java-type="String"></field-type-def>
<field-type-def type="very-short" sql-type="VARCHAR(10)"
java-type="String"></field-type-def>
<field-type-def type="short-varchar" sql-type="VARCHAR(60)"
java-type="String"></field-type-def>
<field-type-def type="long-varchar" sql-type="VARCHAR(255)"
java-type="String"></field-type-def>
<field-type-def type="very-long" sql-type="TEXT"
java-type="String"></field-type-def>
<field-type-def type="comment" sql-type="VARCHAR(255)"
java-type="String"></field-type-def>
<field-type-def type="description" sql-type="VARCHAR(255)"
java-type="String"></field-type-def>
<field-type-def type="name" sql-type="VARCHAR(100)"
java-type="String"></field-type-def>
<field-type-def type="value" sql-type="VARCHAR(255)"
java-type="String"></field-type-def>
<!-- Specialized Types -->
<field-type-def type="credit-card-number" sql-type="VARCHAR(255)"
java-type="String"><validate method="isAnyCard" /></field-type-def>
<field-type-def type="credit-card-date" sql-type="VARCHAR(20)"
java-type="String"><validate method="isDateAfterToday" /></field-type-def>
<field-type-def type="email" sql-type="VARCHAR(255)"
java-type="String"><validate method="isEmail" /></field-type-def>
<field-type-def type="url" sql-type="VARCHAR(255)"
java-type="String"></field-type-def>
<field-type-def type="id-ne" sql-type="VARCHAR(20)"
java-type="String"><validate method="isNotEmpty" /></field-type-def>
<field-type-def type="id-long-ne" sql-type="VARCHAR(60)"
java-type="String"><validate method="isNotEmpty" /></field-type-def>
<field-type-def type="id-vlong-ne" sql-type="VARCHAR(250)"
java-type="String"><validate method="isNotEmpty" /></field-type-def>
<field-type-def type="tel-number" sql-type="VARCHAR(60)"
java-type="String"><validate method="isInternationalPhoneNumber"
/></field-type-def>
http://ofbiz.apache.org/docs/entity.html#Entity_Modeling
--
View this message in context: http://www.nabble.com/Generic-field-types-tf2921731.html#a8166417
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Generic field types
Posted by Jacques Le Roux <ja...@les7arts.com>.
Actually you found them. AFAIK field types are function of the DB used. Hence, yes you may create your own field types as far as
they are compatible with the DB you use and moreover with the JDBC driver you use. You may start from an existing fieldtype[db
type].xml file. Derby seems a good choice as it's default OFBiz DB.
Jacques
From: "rtrujillo" <RT...@touchnet.com>
>
> I am looking for the defined list of Ofbiz generic field types.
>
> I have searched the documentation and nabble.com, but I can not find any
> documentation.
>
> I found the the fieldtype[db type].xml files, but not the list of defined
> field types.
>
> Also, for other databases not defined, can I create my own fieldtype[db
> type].xml file?
>
>
> <fieldtypemodel xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>
> xsi:noNamespaceSchemaLocation="http://www.ofbiz.org/dtds/fieldtypemodel.xsd">
> <!-- ===================== field-type-def ==================== -->
> <!-- General Types -->
> <field-type-def type="blob" sql-type="IMAGE"
> java-type="java.lang.Object"></field-type-def>
>
> <field-type-def type="date-time" sql-type="DATETIME"
> java-type="java.sql.Timestamp"></field-type-def>
> <field-type-def type="date" sql-type="DATETIME"
> java-type="java.sql.Date"></field-type-def>
> <field-type-def type="time" sql-type="DATETIME"
> java-type="java.sql.Time"></field-type-def>
>
> <field-type-def type="currency-amount" sql-type="DECIMAL(18,2)"
> java-type="Double"><validate method="isSignedDouble" /></field-type-def>
> <field-type-def type="currency-precise" sql-type="DECIMAL(18,3)"
> java-type="Double"><validate method="isSignedDouble" /></field-type-def>
> <field-type-def type="floating-point" sql-type="FLOAT"
> java-type="Double"><validate method="isSignedDouble" /></field-type-def>
> <field-type-def type="numeric" sql-type="INT" java-type="Long"><validate
> method="isSignedLong" /></field-type-def>
>
> <field-type-def type="id" sql-type="VARCHAR(20)"
> java-type="String"></field-type-def>
> <field-type-def type="id-long" sql-type="VARCHAR(60)"
> java-type="String"></field-type-def>
> <field-type-def type="id-vlong" sql-type="VARCHAR(250)"
> java-type="String"></field-type-def>
>
> <field-type-def type="indicator" sql-type="CHAR(1)"
> java-type="String"></field-type-def>
> <field-type-def type="very-short" sql-type="VARCHAR(10)"
> java-type="String"></field-type-def>
> <field-type-def type="short-varchar" sql-type="VARCHAR(60)"
> java-type="String"></field-type-def>
> <field-type-def type="long-varchar" sql-type="VARCHAR(255)"
> java-type="String"></field-type-def>
> <field-type-def type="very-long" sql-type="TEXT"
> java-type="String"></field-type-def>
>
> <field-type-def type="comment" sql-type="VARCHAR(255)"
> java-type="String"></field-type-def>
> <field-type-def type="description" sql-type="VARCHAR(255)"
> java-type="String"></field-type-def>
> <field-type-def type="name" sql-type="VARCHAR(100)"
> java-type="String"></field-type-def>
> <field-type-def type="value" sql-type="VARCHAR(255)"
> java-type="String"></field-type-def>
>
> <!-- Specialized Types -->
> <field-type-def type="credit-card-number" sql-type="VARCHAR(255)"
> java-type="String"><validate method="isAnyCard" /></field-type-def>
> <field-type-def type="credit-card-date" sql-type="VARCHAR(20)"
> java-type="String"><validate method="isDateAfterToday" /></field-type-def>
> <field-type-def type="email" sql-type="VARCHAR(255)"
> java-type="String"><validate method="isEmail" /></field-type-def>
> <field-type-def type="url" sql-type="VARCHAR(255)"
> java-type="String"></field-type-def>
> <field-type-def type="id-ne" sql-type="VARCHAR(20)"
> java-type="String"><validate method="isNotEmpty" /></field-type-def>
> <field-type-def type="id-long-ne" sql-type="VARCHAR(60)"
> java-type="String"><validate method="isNotEmpty" /></field-type-def>
> <field-type-def type="id-vlong-ne" sql-type="VARCHAR(250)"
> java-type="String"><validate method="isNotEmpty" /></field-type-def>
> <field-type-def type="tel-number" sql-type="VARCHAR(60)"
> java-type="String"><validate method="isInternationalPhoneNumber"
> /></field-type-def>
>
>
>
>
> http://ofbiz.apache.org/docs/entity.html#Entity_Modeling
>
>
> --
> View this message in context: http://www.nabble.com/Generic-field-types-tf2921731.html#a8166417
> Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Richard Trujillo question about accounting documentation
Posted by rtrujillo <RT...@touchnet.com>.
Try rtrujill@swbell.net
Si Chen-2 wrote:
>
> Richard,
>
> You asked me a question off the list but your spam blocker bounced my
> email. Do you have another email address?
>
> Si
>
>
--
View this message in context: http://www.nabble.com/Generic-field-types-tf2921731.html#a8438428
Sent from the OFBiz - User mailing list archive at Nabble.com.
Richard Trujillo question about accounting documentation
Posted by Si Chen <si...@opensourcestrategies.com>.
Richard,
You asked me a question off the list but your spam blocker bounced my
email. Do you have another email address?
Si
Re: Generic field types
Posted by David E Jones <jo...@undersunconsulting.com>.
On Jan 4, 2007, at 1:09 PM, rtrujillo wrote:
>
> I am looking for the defined list of Ofbiz generic field types.
>
> I have searched the documentation and nabble.com, but I can not
> find any
> documentation.
>
> I found the the fieldtype[db type].xml files, but not the list of
> defined
> field types.
Looks like you found them... this is the only place they exist.
> Also, for other databases not defined, can I create my own fieldtype
> [db
> type].xml file?
Yep, go for it!
-David
> <fieldtypemodel xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>
> xsi:noNamespaceSchemaLocation="http://www.ofbiz.org/dtds/
> fieldtypemodel.xsd">
> <!-- ===================== field-type-def ==================== -->
> <!-- General Types -->
> <field-type-def type="blob" sql-type="IMAGE"
> java-type="java.lang.Object"></field-type-def>
>
> <field-type-def type="date-time" sql-type="DATETIME"
> java-type="java.sql.Timestamp"></field-type-def>
> <field-type-def type="date" sql-type="DATETIME"
> java-type="java.sql.Date"></field-type-def>
> <field-type-def type="time" sql-type="DATETIME"
> java-type="java.sql.Time"></field-type-def>
>
> <field-type-def type="currency-amount" sql-type="DECIMAL(18,2)"
> java-type="Double"><validate method="isSignedDouble" /></field-type-
> def>
> <field-type-def type="currency-precise" sql-type="DECIMAL(18,3)"
> java-type="Double"><validate method="isSignedDouble" /></field-type-
> def>
> <field-type-def type="floating-point" sql-type="FLOAT"
> java-type="Double"><validate method="isSignedDouble" /></field-type-
> def>
> <field-type-def type="numeric" sql-type="INT" java-
> type="Long"><validate
> method="isSignedLong" /></field-type-def>
>
> <field-type-def type="id" sql-type="VARCHAR(20)"
> java-type="String"></field-type-def>
> <field-type-def type="id-long" sql-type="VARCHAR(60)"
> java-type="String"></field-type-def>
> <field-type-def type="id-vlong" sql-type="VARCHAR(250)"
> java-type="String"></field-type-def>
>
> <field-type-def type="indicator" sql-type="CHAR(1)"
> java-type="String"></field-type-def>
> <field-type-def type="very-short" sql-type="VARCHAR(10)"
> java-type="String"></field-type-def>
> <field-type-def type="short-varchar" sql-type="VARCHAR(60)"
> java-type="String"></field-type-def>
> <field-type-def type="long-varchar" sql-type="VARCHAR(255)"
> java-type="String"></field-type-def>
> <field-type-def type="very-long" sql-type="TEXT"
> java-type="String"></field-type-def>
>
> <field-type-def type="comment" sql-type="VARCHAR(255)"
> java-type="String"></field-type-def>
> <field-type-def type="description" sql-type="VARCHAR(255)"
> java-type="String"></field-type-def>
> <field-type-def type="name" sql-type="VARCHAR(100)"
> java-type="String"></field-type-def>
> <field-type-def type="value" sql-type="VARCHAR(255)"
> java-type="String"></field-type-def>
>
> <!-- Specialized Types -->
> <field-type-def type="credit-card-number" sql-type="VARCHAR(255)"
> java-type="String"><validate method="isAnyCard" /></field-type-def>
> <field-type-def type="credit-card-date" sql-type="VARCHAR(20)"
> java-type="String"><validate method="isDateAfterToday" /></field-
> type-def>
> <field-type-def type="email" sql-type="VARCHAR(255)"
> java-type="String"><validate method="isEmail" /></field-type-def>
> <field-type-def type="url" sql-type="VARCHAR(255)"
> java-type="String"></field-type-def>
> <field-type-def type="id-ne" sql-type="VARCHAR(20)"
> java-type="String"><validate method="isNotEmpty" /></field-type-def>
> <field-type-def type="id-long-ne" sql-type="VARCHAR(60)"
> java-type="String"><validate method="isNotEmpty" /></field-type-def>
> <field-type-def type="id-vlong-ne" sql-type="VARCHAR(250)"
> java-type="String"><validate method="isNotEmpty" /></field-type-def>
> <field-type-def type="tel-number" sql-type="VARCHAR(60)"
> java-type="String"><validate method="isInternationalPhoneNumber"
> /></field-type-def>
>
>
>
>
> http://ofbiz.apache.org/docs/entity.html#Entity_Modeling
>
>
> --
> View this message in context: http://www.nabble.com/Generic-field-
> types-tf2921731.html#a8166417
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>