topic How to validate unique column custom in document? in Nuxeo Forum

How to validate unique column custom in document?

Gabino_Reyes — Tue, 06 Oct 2020 00:37:58 GMT

Hello everybody,

How can I validate in polymer section that a column is unique in a nuxeo form?

What is the best alternative?

I tried to run nxql but I couldn't :'(

Gregory_Carlin — Sun, 11 Oct 2020 11:31:02 GMT

Hello,

This uniqueness check should be done on the Polymer part (when validating a form for example).

Do you want to check uniqueness in a complex multivalued property? In the search results?

Thx

Gabino_Reyes — Tue, 17 Nov 2020 18:57:43 GMT

Yes, I need validate the custom input value is unique in database before save the form.

My solution is:

Add operation Repository.ResultSetQuery
Add listener on input: ``` this.$.<custom_field>.addEventListener('blur', this._<custom_method>bind(this), true);

3. Execute query then validate is unique value.

:)

Thanks.