How to create custom filter on contact with accounts_cstm.accounttype_c

Question

Hi All,

I tried to custom filter on Contact.

I create custom by this way:

1. Create new vardef by creating this file custom/Extension/modules/Contacts/Ext/Vardefs/accountType.php with:

$dictionary['Contact']['fields']['account_type'] = array(
    'name' => 'account_type',
    'source' => 'non-db',
    'massupdate' => false,
    'type' => 'enum',
    'options' => 'account_type_dom'
);

2. Add below code to file custom/modules/Contacts/clients/base/filters/default/default.php

'account_type' => array(
           'dbFields' => array(
               0 => 'accounts_cstm.accounttype_c',
           ),
           'type' => 'enum',
           'vname' => 'LBL_ACCOUNTTYPE',
   ),

After Rebuild, I got the below error(see image). I really want to filter on accounts_cstm.accounttype_c (I try with accounts.account_type, it's work)

Thanks

Gabor Meszaros · Accepted Answer

Hi All, I found the solution for this issue. Just change this: 'account_type' => array( 'dbFields' => array( 0 => 'accounts_cstm.accounttype_c' , ), 'type' => 'enum', 'vname' => 'LBL_ACCOUNTTYPE', ), TO: 'account_type' => array( 'dbFields' => array( 0 => ' accounts.accounttype_c', ), 'type' => 'enum', 'vname' => 'LBL_ACCOUNTTYPE', ), (I guess accounts is module name) Cheers,