Problem with STARTDATE of opportunity in search criteria
I have added a field called 'STARTDATE' of the table 'CRMD_OPPORT_H' to search criteria of Opportunity.
I have added this field to below structures
CRMST_QUERY_OPP_BTIL & CRMST_QUERY_R_OPP_BTIL.
Also I have selected few operators in 'CRMVC_DQ'.
But when I'm trying to search opportunities system is throwing the below error and this error is appearing for all the operators
except for 'IS'( EQ).
"The operator 'EQ' is the only one supported for the single value field STARTDATE".
Could you please let me know why this error is appearing ?
ArunKumar Balakrishnan replied
To add a new field to the search criteria, you just have to add the field to the structure 'CRMST_QUERY_OPP_BTIL' . But if it is a only certain operators are supported like EQ, BT, LT and GT. Since 'STARTDATE' is a custom field, check the search criteria by debugging the on_search event of the controller class and check the operator.
Search must be manually implemented by creating an implementation for BADI CRM_BADI_RF_Q1O_SEARCH with filter criteria as BTQOPP = OBJ_IL.