Dropdown list in the report filters
Yesterday I wrote a tip how to add your fields in the report filters and display columns when a custom report is created. Today I discovered another interesting thing. If the field definition has a type ‘enum’ and as options it contains existing dropdown list this list will be displayed in the report filters instead of plain text field:
'status' => array(
'name' => 'status', # name a field in the table
'vname' => 'LBL_MY_NEW_FIELD', # field HTML caption
'type' => 'varchar', # field type,
'len' => '20', #field length
'options' => 'leads_status_dom', # options for dropdown lists
),