a set this right for all my suitecrm directory
in my modules/people/SearchFields.php I have
<?php
if (!defined(‘sugarEntry’) || !sugarEntry) {
die(‘Not A Valid Entry Point’);
}
$module_name = 'people';
$searchFields[$module_name] = array(
'name' => array('query_type' => 'default'),
'current_user_only' => array(
'query_type' => 'default',
'db_field' => array('assigned_user_id'),
'my_items' => true,
'vname' => 'LBL_CURRENT_USER_FILTER',
'type' => 'bool'
),
'assigned_user_id' => array('query_type' => 'default'),
//Range Search Support
'range_date_entered' => array('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true),
'start_range_date_entered' => array(
'query_type' => 'default',
'enable_range_search' => true,
'is_date_field' => true
),
'end_range_date_entered' => array(
'query_type' => 'default',
'enable_range_search' => true,
'is_date_field' => true
),
'range_date_modified' => array('query_type' => 'default', 'enable_range_search' => true, 'is_date_field' => true),
'start_range_date_modified' => array(
'query_type' => 'default',
'enable_range_search' => true,
'is_date_field' => true
),
'end_range_date_modified' => array(
'query_type' => 'default',
'enable_range_search' => true,
'is_date_field' => true
),
//Range Search Support
);
and my custom/modules/people/SearchFields.php I have
<?php
// created: 2021-04-02 13:18:54
$searchFields['people'] = array (
'name' =>
array (
'query_type' => 'default',
),
'current_user_only' =>
array (
'query_type' => 'default',
'db_field' =>
array (
0 => 'assigned_user_id',
),
'my_items' => true,
'vname' => 'LBL_CURRENT_USER_FILTER',
'type' => 'bool',
),
'assigned_user_id' =>
array (
'query_type' => 'default',
),
'range_date_entered' =>
array (
'query_type' => 'default',
'enable_range_search' => true,
'is_date_field' => true,
),
'start_range_date_entered' =>
array (
'query_type' => 'default',
'enable_range_search' => true,
'is_date_field' => true,
),
'end_range_date_entered' =>
array (
'query_type' => 'default',
'enable_range_search' => true,
'is_date_field' => true,
),
'range_date_modified' =>
array (
'query_type' => 'default',
'enable_range_search' => true,
'is_date_field' => true,
),
'start_range_date_modified' =>
array (
'query_type' => 'default',
'enable_range_search' => true,
'is_date_field' => true,
),
'end_range_date_modified' =>
array (
'query_type' => 'default',
'enable_range_search' => true,
'is_date_field' => true,
),
);
UPD
Please Note I have custom module named “people” (I created this and deleted prefix, sure it was working and right now I have another unprefixed custom modules that haven’t any problem with search)