Set FieldType as Unique

[ian tabangay]

Hi. How do you set a field in an entity as UNIQUE?
Thanks


~ ian

[BJ Freeman]

can you elaborate?
are you talking about changing the Entity itself
or in a widget?

ian tabangay sent the following on 9/8/2008 3:26 AM:
> Hi. How do you set a field in an entity as UNIQUE?
> Thanks
>
>
> ~ ian
>

[ian tabangay]

Sorry. I was talking about the entity; as in a column of a table. I wanted
to ensure that a particular column in a table contains unique data and this
column isn't necessarily a primary key.


~ ian

On Mon, Sep 8, 2008 at 6:50 PM, BJ Freeman <[hidden email]> wrote:

> can you elaborate?
> are you talking about changing the Entity itself
> or in a widget?
>
> ian tabangay sent the following on 9/8/2008 3:26 AM:
> > Hi. How do you set a field in an entity as UNIQUE?
> > Thanks
> >
> >
> > ~ ian
> >
>
>

[David E Jones]

Use the entity -> index element for a unique index.

-David


On Sep 8, 2008, at 5:08 AM, ian tabangay wrote:

> Sorry. I was talking about the entity; as in a column of a table. I  
> wanted
> to ensure that a particular column in a table contains unique data  
> and this
> column isn't necessarily a primary key.
>
>
> ~ ian
>
> On Mon, Sep 8, 2008 at 6:50 PM, BJ Freeman <[hidden email]>  
> wrote:
>
>> can you elaborate?
>> are you talking about changing the Entity itself
>> or in a widget?
>>
>> ian tabangay sent the following on 9/8/2008 3:26 AM:
>>> Hi. How do you set a field in an entity as UNIQUE?
>>> Thanks
>>>
>>>
>>> ~ ian
>>>
>>
>>

[BJ Freeman]

not sure if this got implemented
http://lists.ofbiz.org/pipermail/users/2002-September/000177.html


ian tabangay sent the following on 9/8/2008 4:08 AM:

> Sorry. I was talking about the entity; as in a column of a table. I wanted
> to ensure that a particular column in a table contains unique data and this
> column isn't necessarily a primary key.
>
>
> ~ ian
>
> On Mon, Sep 8, 2008 at 6:50 PM, BJ Freeman <[hidden email]> wrote:
>
>> can you elaborate?
>> are you talking about changing the Entity itself
>> or in a widget?
>>
>> ian tabangay sent the following on 9/8/2008 3:26 AM:
>>> Hi. How do you set a field in an entity as UNIQUE?
>>> Thanks
>>>
>>>
>>> ~ ian
>>>
>>
>

[ian tabangay]

Thanks! That did the trick.

~ ian

On Mon, Sep 8, 2008 at 7:59 PM, David E Jones <[hidden email]>wrote:

>
> Use the entity -> index element for a unique index.
>
> -David