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

    On Thursday, June 22, 2023 at 10:53:11 AM MDT, Scott Gray 
<scott.g...@hotwaxsystems.com> wrote:  
 
 Hi Rick,

Yes, see the index element:

<index name="SOME_NAME" unique="true">
  <index-field name="someFieldName"/>
</index>

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 <ad...@thebva.com> 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
>
  

Reply via email to