Hi,
in gridview.bugs.search, you already have the field name but the unified search doesn't return any result. Why ? I add the field description but nothing change. What can I do to have this feature to work.
Thanks,
Sébastien
SplendidCRM Community Version 6.5.4511.33863
with show_sql set to true, vwBUGS doesn't appear in the query below. May be I have to add this view to a store procedure ?
select ID , NAME , ASSIGNED_USER_ID , TITLE , ACCOUNT_NAME , ACCOUNT_ID , ACCOUNT_ASSIGNED_USER_ID , PHONE_WORK , EMAIL1 , TEAM_NAME , ASSIGNED_TO_NAME from vwCONTACTS_List where 1 = 1 and ( 1 = 1 and ( NAME like N'%E10H86%' escape '\' ) or ( TITLE like N'%E10H86%' escape '\' ) or ( ACCOUNT_NAME like N'%E10H86%' escape '\' ) or ( PHONE_WORK like N'%E10H86%' escape '\' ) or ( EMAIL1 like N'%E10H86%' escape '\' ) or ( ASSIGNED_TO_NAME like N'%E10H86%' escape '\' ) ) order by NAME asc; select ID , NAME , ASSIGNED_USER_ID , CITY , PHONE , EMAIL1 , TEAM_NAME , ASSIGNED_TO_NAME from vwACCOUNTS_List where 1 = 1 and ( 1 = 1 and ( NAME like N'%E10H86%' escape '\' ) or ( CITY like N'%E10H86%' escape '\' ) or ( PHONE like N'%E10H86%' escape '\' ) or ( EMAIL1 like N'%E10H86%' escape '\' ) or ( ASSIGNED_TO_NAME like N'%E10H86%' escape '\' ) ) order by NAME asc; select ID , NAME , ASSIGNED_USER_ID , STATUS , ACCOUNT_NAME , EMAIL1 , PHONE_WORK , TEAM_NAME , ASSIGNED_TO_NAME from vwLEADS_List where 1 = 1 and ( 1 = 1 and ( NAME like N'%E10H86%' escape '\' ) or ( STATUS like N'%E10H86%' escape '\' ) or ( ACCOUNT_NAME like N'%E10H86%' escape '\' ) or ( EMAIL1 like N'%E10H86%' escape '\' ) or ( PHONE_WORK like N'%E10H86%' escape '\' ) or ( ASSIGNED_TO_NAME like N'%E10H86%' escape '\' ) ) order by NAME asc; select ID , NAME , ASSIGNED_USER_ID , ACCOUNT_NAME , ACCOUNT_ID , ACCOUNT_ASSIGNED_USER_ID , SALES_STAGE , AMOUNT_USDOLLAR , DATE_CLOSED , TEAM_NAME , ASSIGNED_TO_NAME from vwOPPORTUNITIES_List where 1 = 1 and ( 1 = 1 and ( NAME like N'%E10H86%' escape '\' ) or ( ACCOUNT_NAME like N'%E10H86%' escape '\' ) or ( SALES_STAGE like N'%E10H86%' escape '\' ) or ( ASSIGNED_TO_NAME like N'%E10H86%' escape '\' ) ) order by NAME asc; select ID , NAME , ASSIGNED_USER_ID , ACCOUNT_NAME , EMAIL1 , PHONE_WORK , TEAM_NAME , ASSIGNED_TO_NAME from vwPROSPECTS_List where 1 = 1 and ( 1 = 1 and ( NAME like N'%E10H86%' escape '\' ) or ( ACCOUNT_NAME like N'%E10H86%' escape '\' ) or ( EMAIL1 like N'%E10H86%' escape '\' ) or ( PHONE_WORK like N'%E10H86%' escape '\' ) or ( ASSIGNED_TO_NAME like N'%E10H86%' escape '\' ) ) order by NAME asc; select ID , NAME , CASE_NUMBER , ASSIGNED_USER_ID , ACCOUNT_NAME , ACCOUNT_ID , ACCOUNT_ASSIGNED_USER_ID , TYPE_C , STATUS , EXT_REFERENCE_C , TEAM_NAME , ASSIGNED_TO_NAME from vwCASES_List where 1 = 1 and ( 1 = 1 and ( CASE_NUMBER like N'%E10H86%' escape '\' ) or ( NAME like N'%E10H86%' escape '\' ) or ( ACCOUNT_NAME like N'%E10H86%' escape '\' ) or ( TYPE_C like N'%E10H86%' escape '\' ) or ( STATUS like N'%E10H86%' escape '\' ) or ( EXT_REFERENCE_C like N'%E10H86%' escape '\' ) or ( ASSIGNED_TO_NAME like N'%E10H86%' escape '\' ) ) order by NAME asc; select ID , NAME , ASSIGNED_USER_ID , TOTAL_ESTIMATED_EFFORT , TOTAL_ACTUAL_EFFORT , TEAM_NAME , ASSIGNED_TO_NAME from vwPROJECTS_List where 1 = 1 and ( 1 = 1 and ( NAME like N'%E10H86%' escape '\' ) or ( TOTAL_ESTIMATED_EFFORT like N'%E10H86%' escape '\' ) or ( TOTAL_ACTUAL_EFFORT like N'%E10H86%' escape '\' ) or ( ASSIGNED_TO_NAME like N'%E10H86%' escape '\' ) ) order by NAME asc;