Indexing field in _cstm table

SuiteCRM Forum - English Language SuiteCRM General Discussion
#1

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' =>
            array(
                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 ?

#2

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

sieberta

1 Like
#3

Yes , its no another way =(

#4

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