Re: Entity-engine Unique constraint definition?

[Richard Fleming]

 Thanks Scott, I'll check that out..
Rick

On Thursday, June 22, 2023 at 10:53:11 AM MDT, Scott Gray 
 wrote:  
 
 Hi Rick,

Yes, see the index element:


  


If you search the code base for 'unique="true"' you should find some
examples.

Regards
Scott

On Thu, 22 Jun 2023 at 17:23, Richard Fleming  wrote:

> Hi all,
> Is there a way to define a database unique constraint when defining an
> entity
> in the entity-engine.xml file?
> It is easy to define a primary key, but I don't see a way to set up a
> unique constraint beyond that.
> For instance I'd like to define a unique constraint on the productId and
> brandName fields of theproduct entity. I can do it in the database but
> TIARick
>
  

Re: Entity-engine Unique constraint definition?

[Scott Gray]

Hi Rick,

Yes, see the index element:


  


If you search the code base for 'unique="true"' you should find some
examples.

Regards
Scott

On Thu, 22 Jun 2023 at 17:23, Richard Fleming  wrote:

> Hi all,
> Is there a way to define a database unique constraint when defining an
> entity
> in the entity-engine.xml file?
> It is easy to define a primary key, but I don't see a way to set up a
> unique constraint beyond that.
> For instance I'd like to define a unique constraint on the productId and
> brandName fields of theproduct entity. I can do it in the database but
> TIARick
>

Entity-engine Unique constraint definition?

[Richard Fleming]

Hi all,
Is there a way to define a database unique constraint when defining an entity 
in the entity-engine.xml file?
It is easy to define a primary key, but I don't see a way to set up a unique 
constraint beyond that.
For instance I'd like to define a unique constraint on the productId and 
brandName fields of theproduct entity. I can do it in the database but
TIARick 

Stable demo was down, it's now back

[Jacques Le Roux]

Enjoy

Jacques