How to make a field as unique?

[synergie]

Hello,

What is the simplest way to make a field as unique in Typolight? (in the database script, in dca)?

By unique I mean : if the first element is named "test" no other can be named "test" again. The best would be to have a validator message, like the one for the "not null field" : "This field can not be left blank", but this time :"This value already exist, please choose another name". Or something like this...

Thanks

[ga.n]

add a 'save_callback' entry in your field definition:

'myfield' => array
		(
			'label'                   =>...,
			'inputType'               => 'text',
			'save_callback' => array
			(
				array('myclass', 'checkUniqueness')
			)

then create the callback

class myclass extends Backend {

	public function __construct() {
		parent::__construct();
		$this->import('Database');
	}

       public function checkUniqueness($varValue, DataContainer $dc) {

       // value check goes here

                if ($recordExists) {
                         throw new Exception('field must be unique');
                }

                return $varValue

      }
}

hope this helps

[ramjet]

Many ways for various objectives...
In the sql...to ensure unique entries into the database

  UNIQUE KEY `name` (`name`)

In the DCA of your module in tl_whatever.php

'eval'                    => array('mandatory'=>true,'unique'=>true, 'maxlength'=>6, 'tl_class'=>'w50'),

To make a member email unique for instance...

In your modules DCA in tl_member.php

$GLOBALS['TL_DCA']['tl_member']['fields']['email']['eval']['unique']  =  true;

[synergie]

'unique' => true

very good and easy! thanks I will test it!