Forum


List Manager Suggestions

Help us to make a better extension !
Forums
No se permite escribir sin estar logado. Por favor, login

prevent duplicate records 30.01.2022 12:27

Hi
I want to suggest you to make checking before updating record in table to prevent duplicating
Of course it must be optionally for choosen fields

Re: prevent duplicate records 31.01.2022 10:46

Hi,
thank you very much for your feedback. In fact you have already a method to prevent duplicating key fields. As you're directly editing the database records, you can introduce this restriction at your db table, creating a unique key for one (or more) fields, something like

ALTER TABLE Persons ADD CONSTRAINT MyConstraintPerson UNIQUE (LastName);

With this restriction your database will be in charge of validating data before the insert/update operation. With latest LM version 4.1.10 we have forwarded this validation error to the page, so if you try to insert a non-valid value using List Manager you will get a message like this:

Duplicate entry 'Jordan' for key 'MyConstraintPerson'


Hope this helps,regards
Moonsoft Team
www.moonsoft.es

Re: prevent duplicate records 31.01.2022 15:07

Thank you. It works. I can see Error message.
Are you satisfied with our products/services/support?
Please help us to keep improving, add a review at  joomla extensions site and  magento connect

Lo que nuestros clientes opinan de nosotros