OFBiz › OFBiz - User

Generic field types

‹ Previous Topic Next Topic ›
 
classic Classic list List threaded Threaded
♦
♦
 5 messages Options
rtrujillo
Reply | Threaded
Open this post in threaded view
♦
♦
|

Generic field types

rtrujillo
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 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>

   
    <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
David E Jones-2
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Generic field types

David E Jones-2

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.
>

Jacques Le Roux
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Generic field types

Jacques Le Roux
Administrator
In reply to this post by rtrujillo
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" <[hidden email]>

>
> 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.

Si Chen-2
Reply | Threaded
Open this post in threaded view
♦
♦
|

Richard Trujillo question about accounting documentation

Si Chen-2
In reply to this post by rtrujillo
Richard,

You asked me a question off the list but your spam blocker bounced my
email.  Do you have another email address?

Si
rtrujillo
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Richard Trujillo question about accounting documentation

rtrujillo
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
Free forum by Nabble Edit this page