Indexing field in _cstm table

Hello , i have issue with indexing custom field in account module , i try to set :

$dictionary["Account_cstm"]['indices'][] =array(
            'name' => 'idx_custom_index',
            'type' => 'index',
            'fields' =>
                0 => 'phone_c',

but when i use Repair/rebuild Suite try to alert table accounts, but need to alert accounts_cstm .
Help me pls. Where i am wrong ?

I would like this answer as well… however I will say, Smoorfy, it is aparently OK to do this at the database level.


1 Like

Yes , its no another way =(

you can create manual index on your databse, and add ‘source’ => ‘non-db’ inside your index configuration. Example: $dictionary[YourModule][‘indices’][] = array(‘name’ => ‘idx_check_duplicate_fields’,
‘type’ => ‘index’,
‘fields’ => array(‘name’, ‘phone_c’, ‘facebook_c’),
’source’ => ‘non-db’,

1 Like