Filter events delegates does not work #1157

Closed
opened 2026-02-20 15:06:05 -05:00 by deekerman · 22 comments
Owner

Originally created by @QuickCRM on GitHub (Sep 1, 2016).

Originally assigned to: @daniel-samson on GitHub.

When filtering delegates in an event, the delegates sub panel is no longer displayed

Issue

Expected Behavior

Contacts/Leads matching the searched first name/last name should be displayed
This also affects the history panel search on modules also.

Actual Behavior

Sub panel breaks with an SQL error.
Query Failed: ( SELECT count(*) c FROM contacts LEFT JOIN contacts_cstm ON contacts.id = contacts_cstm.id_c INNER JOIN fp_events_contacts_c ON contacts.id=fp_events_contacts_c.fp_events_contactscontacts_idb AND fp_events_contacts_c.fp_events_contactsfp_events_ida='59b14c11-4582-dfec-ee7a-57c538808e54' AND fp_events_contacts_c.deleted=0

where ((contacts.last_name like 'Lu%')) AND contacts.deleted=0 ) UNION ALL ( SELECT count(*) c FROM prospects LEFT JOIN prospects_cstm ON prospects.id = prospects_cstm.id_c INNER JOIN fp_events_prospects_1_c ON prospects.id=fp_events_prospects_1_c.fp_events_prospects_1prospects_idb AND fp_events_prospects_1_c.fp_events_prospects_1fp_events_ida='59b14c11-4582-dfec-ee7a-57c538808e54' AND fp_events_prospects_1_c.deleted=0

where ((contacts.last_name like 'Lu%')) AND prospects.deleted=0 ) UNION ALL ( SELECT count(*) c FROM leads LEFT JOIN leads_cstm ON leads.id = leads_cstm.id_c INNER JOIN fp_events_leads_1_c ON leads.id=fp_events_leads_1_c.fp_events_leads_1leads_idb AND fp_events_leads_1_c.fp_events_leads_1fp_events_ida='59b14c11-4582-dfec-ee7a-57c538808e54' AND fp_events_leads_1_c.deleted=0

where ((contacts.last_name like 'Lu%')) AND leads.deleted=0 ):

MySQL error 1054: Unknown column 'contacts.last_name' in 'where clause'

Possible Fix

Steps to Reproduce

  1. go to http://demo.suiteondemand.com
  2. create an event
  3. add a few contacts
  4. filter data

Context

Your Environment

  • SuiteCRM Version used: 7.7.4 (same problem occurs with 7.7.3)
  • Browser name and version (e.g. Chrome Version 51.0.2704.63 (64-bit)):
  • Environment name and version (e.g. MySQL, PHP 7): http://demo.suiteondemand.com
  • Operating System and version (e.g Ubuntu 16.04): http://demo.suiteondemand.com
Originally created by @QuickCRM on GitHub (Sep 1, 2016). Originally assigned to: @daniel-samson on GitHub. <!--- Provide a general summary of the issue in the **Title** above --> When filtering delegates in an event, the delegates sub panel is no longer displayed <!--- Before you open an issue, please check if a similar issue already exists or has been closed before. ---> #### Issue <!--- Provide a more detailed introduction to the issue itself, and why you consider it to be a bug --> #### Expected Behavior <!--- Tell us what should happen --> Contacts/Leads matching the searched first name/last name should be displayed This also affects the history panel search on modules also. #### Actual Behavior <!--- Tell us what happens instead --> Sub panel breaks with an SQL error. Query Failed: ( SELECT count(*) c FROM contacts LEFT JOIN contacts_cstm ON contacts.id = contacts_cstm.id_c INNER JOIN fp_events_contacts_c ON contacts.id=fp_events_contacts_c.fp_events_contactscontacts_idb AND fp_events_contacts_c.fp_events_contactsfp_events_ida='59b14c11-4582-dfec-ee7a-57c538808e54' AND fp_events_contacts_c.deleted=0 where ((contacts.last_name like 'Lu%')) AND contacts.deleted=0 ) UNION ALL ( SELECT count(*) c FROM prospects LEFT JOIN prospects_cstm ON prospects.id = prospects_cstm.id_c INNER JOIN fp_events_prospects_1_c ON prospects.id=fp_events_prospects_1_c.fp_events_prospects_1prospects_idb AND fp_events_prospects_1_c.fp_events_prospects_1fp_events_ida='59b14c11-4582-dfec-ee7a-57c538808e54' AND fp_events_prospects_1_c.deleted=0 where ((contacts.last_name like 'Lu%')) AND prospects.deleted=0 ) UNION ALL ( SELECT count(*) c FROM leads LEFT JOIN leads_cstm ON leads.id = leads_cstm.id_c INNER JOIN fp_events_leads_1_c ON leads.id=fp_events_leads_1_c.fp_events_leads_1leads_idb AND fp_events_leads_1_c.fp_events_leads_1fp_events_ida='59b14c11-4582-dfec-ee7a-57c538808e54' AND fp_events_leads_1_c.deleted=0 where ((contacts.last_name like 'Lu%')) AND leads.deleted=0 ): MySQL error 1054: Unknown column 'contacts.last_name' in 'where clause' #### Possible Fix <!--- Not obligatory, but suggest a fix or reason for the bug --> #### Steps to Reproduce <!--- Provide a link to a live example, or an unambiguous set of steps to --> <!--- reproduce this bug include code to reproduce, if relevant --> 1. go to http://demo.suiteondemand.com 2. create an event 3. add a few contacts 4. filter data #### Context <!--- How has this bug affected you? What were you trying to accomplish? --> <!--- If you feel this should be a low/medium/high priority then please state so --> #### Your Environment <!--- Include as many relevant details about the environment you experienced the bug in --> - SuiteCRM Version used: 7.7.4 (same problem occurs with 7.7.3) - Browser name and version (e.g. Chrome Version 51.0.2704.63 (64-bit)): - Environment name and version (e.g. MySQL, PHP 7): http://demo.suiteondemand.com - Operating System and version (e.g Ubuntu 16.04): http://demo.suiteondemand.com
Author
Owner

@vladbar commented on GitHub (Sep 22, 2016):

Solution details:

Description

references issue #2106
Added a statement which changes the current table for each subquery WHERE clause based on the module it is queering.
Before, it just used a generic WHERE clause (which comes from the subpanel definition), which was not a problem for most of the subpanels/modules, but caused an error with the Event module -> Delegates subpanel due to the fact that this subpanel needs to query multiple tables (Contacts, Prospects, Leads).

Motivation and Context

The original problem was: when filtering delegates in an event, the delegates sub panel is no longer displayed.
It was not displayed due to a mysql error as each subquery for the delegates sub panel tried to query contacts table in the WHERE clause, while the subquery itself was selecting from prospect or leads table.
The example error it generated:
MySQL error 1054: Unknown column 'contacts.last_name' in 'where clause'

How To Test This

Navigate to Events -> Delegates subpanel -> choose Filter from the dropdown -> search by any field -> should display the correct result.

Types of changes

  • Bug fix (non-breaking change which fixes an issue)
@vladbar commented on GitHub (Sep 22, 2016): Solution details: ## Description references issue #2106 Added a statement which changes the current table for each subquery WHERE clause based on the module it is queering. Before, it just used a generic WHERE clause (which comes from the subpanel definition), which was not a problem for most of the subpanels/modules, but caused an error with the Event module -> Delegates subpanel due to the fact that this subpanel needs to query multiple tables (Contacts, Prospects, Leads). ## Motivation and Context The original problem was: when filtering delegates in an event, the delegates sub panel is no longer displayed. It was not displayed due to a mysql error as each subquery for the delegates sub panel tried to query contacts table in the WHERE clause, while the subquery itself was selecting from prospect or leads table. The example error it generated: MySQL error 1054: Unknown column 'contacts.last_name' in 'where clause' ## How To Test This Navigate to Events -> Delegates subpanel -> choose Filter from the dropdown -> search by any field -> should display the correct result. ## Types of changes - [ ] Bug fix (non-breaking change which fixes an issue)
Author
Owner

@samus-aran commented on GitHub (Jan 17, 2017):

@QuickCRM
Is this still an issue for the filter on Events. I understand we have an issue opened for the History sub-panel but want to confirm if this was an issue on Events.

I have tested this on http://demo.suiteondemand.com and the subpanel doesn't disappear but curious if it filters as expected.

@samus-aran commented on GitHub (Jan 17, 2017): @QuickCRM Is this still an issue for the filter on Events. I understand we have an issue opened for the History sub-panel but want to confirm if this was an issue on Events. I have tested this on [http://demo.suiteondemand.com](http://demo.suiteondemand.com) and the subpanel doesn't disappear but curious if it filters as expected.
Author
Owner

@QuickCRM commented on GitHub (Jan 17, 2017):

Hi,

Just tried on your demo server and filtering still doesn't work.

Thanks

--
support@quickcrm.fr
NS-Team
www.quickcrm.fr/mobile

Le 17 janv. 2017 à 18:08, Ashley Nicolson notifications@github.com a écrit :

@QuickCRM
Is this still an issue for the filter on Events. I understand we have an issue opened for the History sub-panel but want to confirm if this was an issue on Events.

I have tested this on http://demo.suiteondemand.com and the subpanel doesn't disappear but curious if it filters as expected.


You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub, or mute the thread.

@QuickCRM commented on GitHub (Jan 17, 2017): Hi, Just tried on your demo server and filtering still doesn't work. Thanks -- support@quickcrm.fr NS-Team www.quickcrm.fr/mobile > Le 17 janv. 2017 à 18:08, Ashley Nicolson <notifications@github.com> a écrit : > > @QuickCRM > Is this still an issue for the filter on Events. I understand we have an issue opened for the History sub-panel but want to confirm if this was an issue on Events. > > I have tested this on http://demo.suiteondemand.com and the subpanel doesn't disappear but curious if it filters as expected. > > — > You are receiving this because you were mentioned. > Reply to this email directly, view it on GitHub, or mute the thread. >
Author
Owner

@horus68 commented on GitHub (Mar 6, 2017):

v.7.8.2 - Confirmed in the demo site @samus-aran

1- Error when hitting the "Select Delegates / Filter" when no delegates created
2017-03-06 13_56_35-filter events delegates events suitecrm
Error:
Notice: Undefined index: delegates in /app/include/SubPanel/SubPanelDefinitions.php on line 719 Notice: Undefined index: delegates in /app/include/SubPanel/SubPanelDefinitions.php on line 722 Notice: Trying to get property of non-object in /app/include/SubPanel/SubPanel.php on line 393 Notice: Trying to get property of non-object in /app/include/SubPanel/SubPanel.php on line 445 Notice: Trying to get property of non-object in /app/include/SubPanel/SubPanel.php on line 430
2017-03-06 13_53_15-filter events delegates events suitecrm

Now the error if delegates are already created:
Notice: Undefined index: delegates in /app/include/SubPanel/SubPanelDefinitions.php on line 719 Notice: Undefined index: delegates in /app/include/SubPanel/SubPanelDefinitions.php on line 722 Notice: Trying to get property of non-object in /app/include/SubPanel/SubPanel.php on line 393 Notice: Trying to get property of non-object in /app/include/SubPanel/SubPanel.php on line 445 Notice: Trying to get property of non-object in /app/include/SubPanel/SubPanel.php on line 430
2017-03-06 14_04_26-filter events delegates does not work events suitecrm

2- click on "Select Delegates" sometimes just turn screen gray and lock things out. We need to refresh or go to events using menu. (see the modal on the middle in grey)
(Firefox on windows)
2017-03-06 14_00_23-suitecrm

but sometimes it works (see the modal on the middle now in white)
2017-03-06 14_02_27-filter events delegates does not work events suitecrm

Also consider that this is a bug reported a long time ago (Forum topic from 22 months ago)
Events (1/1) - https://suitecrm.com/forum/bug-tracker/4041-events

@horus68 commented on GitHub (Mar 6, 2017): v.7.8.2 - Confirmed in the demo site @samus-aran 1- Error when hitting the "Select Delegates / Filter" when no delegates created ![2017-03-06 13_56_35-filter events delegates events suitecrm](https://cloud.githubusercontent.com/assets/3055443/23612811/c491d01a-0274-11e7-8720-0cb70511b29c.png) Error: ` Notice: Undefined index: delegates in /app/include/SubPanel/SubPanelDefinitions.php on line 719 Notice: Undefined index: delegates in /app/include/SubPanel/SubPanelDefinitions.php on line 722 Notice: Trying to get property of non-object in /app/include/SubPanel/SubPanel.php on line 393 Notice: Trying to get property of non-object in /app/include/SubPanel/SubPanel.php on line 445 Notice: Trying to get property of non-object in /app/include/SubPanel/SubPanel.php on line 430` ![2017-03-06 13_53_15-filter events delegates events suitecrm](https://cloud.githubusercontent.com/assets/3055443/23612774/99682b00-0274-11e7-8b67-7ca4bc84ed49.png) Now the error if delegates are already created: `Notice: Undefined index: delegates in /app/include/SubPanel/SubPanelDefinitions.php on line 719 Notice: Undefined index: delegates in /app/include/SubPanel/SubPanelDefinitions.php on line 722 Notice: Trying to get property of non-object in /app/include/SubPanel/SubPanel.php on line 393 Notice: Trying to get property of non-object in /app/include/SubPanel/SubPanel.php on line 445 Notice: Trying to get property of non-object in /app/include/SubPanel/SubPanel.php on line 430 ` ![2017-03-06 14_04_26-filter events delegates does not work events suitecrm](https://cloud.githubusercontent.com/assets/3055443/23613121/031ace1c-0276-11e7-868d-a7169ad0a14d.png) 2- click on "Select Delegates" sometimes just turn screen gray and lock things out. We need to refresh or go to events using menu. (see the modal on the middle in grey) (Firefox on windows) ![2017-03-06 14_00_23-suitecrm](https://cloud.githubusercontent.com/assets/3055443/23612982/65010f16-0275-11e7-81d3-843444a44a51.png) but sometimes it works (see the modal on the middle now in white) ![2017-03-06 14_02_27-filter events delegates does not work events suitecrm](https://cloud.githubusercontent.com/assets/3055443/23613034/a1055850-0275-11e7-8ccd-cf7905ca634b.png) Also consider that this is a bug reported a long time ago (Forum topic from 22 months ago) Events (1/1) - https://suitecrm.com/forum/bug-tracker/4041-events
Author
Owner

@samus-aran commented on GitHub (Mar 6, 2017):

Thanks for the screenshots @horus68. I've assigned this out to be resolved. 👍

@samus-aran commented on GitHub (Mar 6, 2017): Thanks for the screenshots @horus68. I've assigned this out to be resolved. :+1:
Author
Owner

@chris001 commented on GitHub (Mar 11, 2017):

Thanks @samus-aran
This 22 month old bug is prompting a question. How to track bugs so they don't slip thru the cracks, and go so long without getting worked on and resolved?

@chris001 commented on GitHub (Mar 11, 2017): Thanks @samus-aran This 22 month old bug is prompting a question. How to track bugs so they don't slip thru the cracks, and go so long without getting worked on and resolved?
Author
Owner

@jucedupp commented on GitHub (Sep 12, 2017):

@samus-aran This issue still has not been resolved, versions later? If you assigned this to be resolved on Mar 6, and it is now 6 months later? I looked into the code and this functionality is so fundamentally broken I don't even know where to start to fix it. Cost me 4 hours yesterday.

@jucedupp commented on GitHub (Sep 12, 2017): @samus-aran This issue still has not been resolved, versions later? If you assigned this to be resolved on Mar 6, and it is now 6 months later? I looked into the code and this functionality is so fundamentally broken I don't even know where to start to fix it. Cost me 4 hours yesterday.
Author
Owner

@pgorod commented on GitHub (Sep 12, 2017):

@jucedupp did you try that commit by @vladbar above? Does it fix your problem?

I'd like to know if we just need to merge that fix or if there's any other problems?

@pgorod commented on GitHub (Sep 12, 2017): @jucedupp did you try that commit by @vladbar above? Does it fix your problem? I'd like to know if we just need to merge that fix or if there's any other problems?
Author
Owner

@jucedupp commented on GitHub (Sep 12, 2017):

The commit does not fix the issue. No difference. Also attempted Quick repair.

@jucedupp commented on GitHub (Sep 12, 2017): The commit does not fix the issue. No difference. Also attempted Quick repair.
Author
Owner

@jucedupp commented on GitHub (Sep 12, 2017):

Notice:  Undefined index: delegates in xxx\include\SubPanel\SubPanelDefinitions.php on line 721
Notice:  Undefined index: delegates in xxx\include\SubPanel\SubPanelDefinitions.php on line 726
Notice:  Trying to get property of non-object in xxx\include\SubPanel\SubPanel.php on line 395
Notice:  Trying to get property of non-object in xxx\include\SubPanel\SubPanel.php on line 447
Notice:  Trying to get property of non-object in xxx\include\SubPanel\SubPanel.php on line 432
@jucedupp commented on GitHub (Sep 12, 2017): ``` Notice: Undefined index: delegates in xxx\include\SubPanel\SubPanelDefinitions.php on line 721 Notice: Undefined index: delegates in xxx\include\SubPanel\SubPanelDefinitions.php on line 726 Notice: Trying to get property of non-object in xxx\include\SubPanel\SubPanel.php on line 395 Notice: Trying to get property of non-object in xxx\include\SubPanel\SubPanel.php on line 447 Notice: Trying to get property of non-object in xxx\include\SubPanel\SubPanel.php on line 432 ```
Author
Owner

@jucedupp commented on GitHub (Sep 12, 2017):

This issue also persists on the live demo at https://demo.suiteondemand.com/

@jucedupp commented on GitHub (Sep 12, 2017): This issue also persists on the live demo at https://demo.suiteondemand.com/
Author
Owner

@jucedupp commented on GitHub (Sep 14, 2017):

@pgorod Bump.

@jucedupp commented on GitHub (Sep 14, 2017): @pgorod Bump.
Author
Owner

@jucedupp commented on GitHub (Sep 14, 2017):

On further investigation, I found the following in the logfile:

Failed to load original or custom subpanel data for delegates in modules//metadata/subpanels/.php

Note how the variable for the module name is empty.

I think the issue is that no relationship exists out of the box between the fp_Events and the Delegates module.

@jucedupp commented on GitHub (Sep 14, 2017): On further investigation, I found the following in the logfile: Failed to load original or custom subpanel data for delegates in modules//metadata/subpanels/.php Note how the variable for the module name is empty. I think the issue is that no relationship exists out of the box between the fp_Events and the Delegates module.
Author
Owner

@pgorod commented on GitHub (Sep 14, 2017):

@jucedupp can you get a stack trace on that error?

Put this before line 152 of include/SubPanel/SubPanelDefinitions.php

debug_print_backtrace();

and make it give the error again, then post the results.

@pgorod commented on GitHub (Sep 14, 2017): @jucedupp can you get a stack trace on that error? Put this before [line 152 of `include/SubPanel/SubPanelDefinitions.php`](https://github.com/salesagility/SuiteCRM/blame/master/include/SubPanel/SubPanelDefinitions.php#L152) `debug_print_backtrace();` and make it give the error again, then post the results.
Author
Owner

@jucedupp commented on GitHub (Sep 15, 2017):

@pgorod
Herewith the stack trace:

#0 aSubPanel->__construct(delegates, , Account Object ([field_name_map] => Array ([id] => Array ([name] => id,[vname] => LBL_ID,[type] => id,[required] => 1,[reportable] => 1,[comment] => Unique identifier,[inline_edit] => ),[name] => Array ([name] => name,[type] => name,[dbType] => varchar,[vname] => LBL_NAME,[len] => 150,[comment] => Name of the Company,[unified_search] => 1,[full_text_search] => Array ([boost] => 3),[audited] => 1,[required] => 1,[importable] => required,[merge_filter] => selected),[date_entered] => Array ([name] => date_entered,[vname] => LBL_DATE_ENTERED,[type] => datetime,[group] => created_by_name,[comment] => Date record created,[enable_range_search] => 1,[options] => date_range_search_dom,[inline_edit] => ),[date_modified] => Array ([name] => date_modified,[vname] => LBL_DATE_MODIFIED,[type] => datetime,[group] => modified_by_name,[comment] => Date record last modified,[enable_range_search] => 1,[options] => date_range_search_dom,[inline_edit] => ),[modified_user_id] => Array ([name] => modified_user_id,[rname] => user_name,[id_name] => modified_user_id,[vname] => LBL_MODIFIED,[type] => assigned_user_name,[table] => users,[isnull] => false,[group] => modified_by_name,[dbType] => id,[reportable] => 1,[comment] => User who last modified record,[massupdate] => ,[inline_edit] => ),[modified_by_name] => Array ([name] => modified_by_name,[vname] => LBL_MODIFIED_NAME,[type] => relate,[reportable] => ,[source] => non-db,[rname] => user_name,[table] => users,[id_name] => modified_user_id,[module] => Users,[link] => modified_user_link,[duplicate_merge] => disabled,[massupdate] => ,[inline_edit] => ),[created_by] => Array ([name] => created_by,[rname] => user_name,[id_name] => modified_user_id,[vname] => LBL_CREATED,[type] => assigned_user_name,[table] => users,[isnull] => false,[dbType] => id,[group] => created_by_name,[comment] => User who created record,[massupdate] => ,[inline_edit] => ),[created_by_name] => Array ([name] => created_by_name,[vname] => LBL_CREATED,[type] => relate,[reportable] => ,[link] => created_by_link,[rname] => user_name,[source] => non-db,[table] => users,[id_name] => created_by,[module] => Users,[duplicate_merge] => disabled,[importable] => false,[massupdate] => ,[inline_edit] => ),[description] => Array ([name] => description,[vname] => LBL_DESCRIPTION,[type] => text,[comment] => Full text of the note,[rows] => 6,[cols] => 80),[deleted] => Array ([name] => deleted,[vname] => LBL_DELETED,[type] => bool,[default] => 0,[reportable] => ,[comment] => Record deletion indicator),[created_by_link] => Array ([name] => created_by_link,[type] => link,[relationship] => accounts_created_by,[vname] => LBL_CREATED_BY_USER,[link_type] => one,[module] => Users,[bean_name] => User,[source] => non-db),[modified_user_link] => Array ([name] => modified_user_link,[type] => link,[relationship] => accounts_modified_user,[vname] => LBL_MODIFIED_BY_USER,[link_type] => one,[module] => Users,[bean_name] => User,[source] => non-db),[assigned_user_id] => Array ([name] => assigned_user_id,[rname] => user_name,[id_name] => assigned_user_id,[vname] => LBL_ASSIGNED_TO_ID,[group] => assigned_user_name,[type] => relate,[table] => users,[module] => Users,[reportable] => 1,[isnull] => false,[dbType] => id,[audited] => 1,[comment] => User ID assigned to record,[duplicate_merge] => disabled),[assigned_user_name] => Array ([name] => assigned_user_name,[link] => assigned_user_link,[vname] => LBL_ASSIGNED_TO_NAME,[rname] => user_name,[type] => relate,[reportable] => ,[source] => non-db,[table] => users,[id_name] => assigned_user_id,[module] => Users,[duplicate_merge] => disabled),[assigned_user_link] => Array ([name] => assigned_user_link,[type] => link,[relationship] => accounts_assigned_user,[vname] => LBL_ASSIGNED_TO_USER,[link_type] => one,[module] => Users,[bean_name] => User,[source] => non-db,[duplicate_merge] => enabled,[rname] => user_name,[id_name] => assigned_user_id,[table] => users),[SecurityGroups] => Array ([name] => SecurityGroups,[type] => link,[relationship] => securitygroups_accounts,[module] => SecurityGroups,[bean_name] => SecurityGroup,[source] => non-db,[vname] => LBL_SECURITYGROUPS),[account_type] => Array ([name] => account_type,[vname] => LBL_TYPE,[type] => enum,[options] => account_type_dom,[len] => 50,[comment] => The Company is of this type),[industry] => Array ([name] => industry,[vname] => LBL_INDUSTRY,[type] => enum,[options] => industry_dom,[len] => 50,[comment] => The company belongs in this industry,[merge_filter] => enabled),[annual_revenue] => Array ([name] => annual_revenue,[vname] => LBL_ANNUAL_REVENUE,[type] => varchar,[len] => 100,[comment] => Annual revenue for this company,[merge_filter] => enabled),[phone_fax] => Array ([name] => phone_fax,[vname] => LBL_FAX,[type] => phone,[dbType] => varchar,[len] => 100,[unified_search] => 1,[full_text_search] => Array ([boost] => 1),[comment] => The fax phone number of this company),[billing_address_street] => Array ([name] => billing_address_street,[vname] => LBL_BILLING_ADDRESS_STREET,[type] => varchar,[len] => 150,[comment] => The street address used for billing address,[group] => billing_address,[merge_filter] => enabled),[billing_address_street_2] => Array ([name] => billing_address_street_2,[vname] => LBL_BILLING_ADDRESS_STREET_2,[type] => varchar,[len] => 150,[source] => non-db),[billing_address_street_3] => Array ([name] => billing_address_street_3,[vname] => LBL_BILLING_ADDRESS_STREET_3,[type] => varchar,[len] => 150,[source] => non-db),[billing_address_street_4] => Array ([name] => billing_address_street_4,[vname] => LBL_BILLING_ADDRESS_STREET_4,[type] => varchar,[len] => 150,[source] => non-db),[billing_address_city] => Array ([name] => billing_address_city,[vname] => LBL_BILLING_ADDRESS_CITY,[type] => varchar,[len] => 100,[comment] => The city used for billing address,[group] => billing_address,[merge_filter] => enabled),[billing_address_state] => Array ([name] => billing_address_state,[vname] => LBL_BILLING_ADDRESS_STATE,[type] => varchar,[len] => 100,[group] => billing_address,[comment] => The state used for billing address,[merge_filter] => enabled),[billing_address_postalcode] => Array ([name] => billing_address_postalcode,[vname] => LBL_BILLING_ADDRESS_POSTALCODE,[type] => varchar,[len] => 20,[group] => billing_address,[comment] => The postal code used for billing address,[merge_filter] => enabled),[billing_address_country] => Array ([name] => billing_address_country,[vname] => LBL_BILLING_ADDRESS_COUNTRY,[type] => varchar,[group] => billing_address,[comment] => The country used for the billing address,[merge_filter] => enabled),[rating] => Array ([name] => rating,[vname] => LBL_RATING,[type] => varchar,[len] => 100,[comment] => An arbitrary rating for this company for use in comparisons with others),[phone_office] => Array ([name] => phone_office,[vname] => LBL_PHONE_OFFICE,[type] => phone,[dbType] => varchar,[len] => 100,[audited] => 1,[unified_search] => 1,[full_text_search] => Array ([boost] => 1),[comment] => The office phone number,[merge_filter] => enabled),[phone_alternate] => Array ([name] => phone_alternate,[vname] => LBL_PHONE_ALT,[type] => phone,[group] => phone_office,[dbType] => varchar,[len] => 100,[unified_search] => 1,[full_text_search] => Array ([boost] => 1),[comment] => An alternate phone number,[merge_filter] => enabled),[website] => Array ([name] => website,[vname] => LBL_WEBSITE,[type] => url,[dbType] => varchar,[len] => 255,[comment] => URL of website for the company),[ownership] => Array ([name] => ownership,[vname] => LBL_OWNERSHIP,[type] => varchar,[len] => 100,[comment] => ),[employees] => Array ([name] => employees,[vname] => LBL_EMPLOYEES,[type] => varchar,[len] => 10,[comment] => Number of employees, varchar to accomodate for both number (100) or range (50-100)),[ticker_symbol] => Array ([name] => ticker_symbol,[vname] => LBL_TICKER_SYMBOL,[type] => varchar,[len] => 10,[comment] => The stock trading (ticker) symbol for the company,[merge_filter] => enabled),[shipping_address_street] => Array ([name] => shipping_address_street,[vname] => LBL_SHIPPING_ADDRESS_STREET,[type] => varchar,[len] => 150,[group] => shipping_address,[comment] => The street address used for for shipping purposes,[merge_filter] => enabled),[shipping_address_street_2] => Array ([name] => shipping_address_street_2,[vname] => LBL_SHIPPING_ADDRESS_STREET_2,[type] => varchar,[len] => 150,[source] => non-db),[shipping_address_street_3] => Array ([name] => shipping_address_street_3,[vname] => LBL_SHIPPING_ADDRESS_STREET_3,[type] => varchar,[len] => 150,[source] => non-db),[shipping_address_street_4] => Array ([name] => shipping_address_street_4,[vname] => LBL_SHIPPING_ADDRESS_STREET_4,[type] => varchar,[len] => 150,[source] => non-db),[shipping_address_city] => Array ([name] => shipping_address_city,[vname] => LBL_SHIPPING_ADDRESS_CITY,[type] => varchar,[len] => 100,[group] => shipping_address,[comment] => The city used for the shipping address,[merge_filter] => enabled),[shipping_address_state] => Array ([name] => shipping_address_state,[vname] => LBL_SHIPPING_ADDRESS_STATE,[type] => varchar,[len] => 100,[group] => shipping_address,[comment] => The state used for the shipping address,[merge_filter] => enabled),[shipping_address_postalcode] => Array ([name] => shipping_address_postalcode,[vname] => LBL_SHIPPING_ADDRESS_POSTALCODE,[type] => varchar,[len] => 20,[group] => shipping_address,[comment] => The zip code used for the shipping address,[merge_filter] => enabled),[shipping_address_country] => Array ([name] => shipping_address_country,[vname] => LBL_SHIPPING_ADDRESS_COUNTRY,[type] => varchar,[group] => shipping_address,[comment] => The country used for the shipping address,[merge_filter] => enabled),[email1] => Array ([name] => email1,[vname] => LBL_EMAIL,[group] => email1,[type] => varchar,[function] => Array ([name] => getEmailAddressWidget,[returns] => html),[source] => non-db,[studio] => Array ([editField] => 1,[searchview] => ),[full_text_search] => Array ([boost] => 3,[analyzer] => whitespace)),[email_addresses_primary] => Array ([name] => email_addresses_primary,[type] => link,[relationship] => accounts_email_addresses_primary,[source] => non-db,[vname] => LBL_EMAIL_ADDRESS_PRIMARY,[duplicate_merge] => disabled,[studio] => Array ([formula] => )),[email_addresses] => Array ([name] => email_addresses,[type] => link,[relationship] => accounts_email_addresses,[source] => non-db,[vname] => LBL_EMAIL_ADDRESSES,[reportable] => ,[unified_search] => 1,[rel_fields] => Array ([primary_address] => Array ([type] => bool)),[studio] => Array ([formula] => )),[email_addresses_non_primary] => Array ([name] => email_addresses_non_primary,[type] => email,[source] => non-db,[vname] => LBL_EMAIL_NON_PRIMARY,[studio] => ,[reportable] => ,[massupdate] => ),[parent_id] => Array ([name] => parent_id,[vname] => LBL_PARENT_ACCOUNT_ID,[type] => id,[required] => ,[reportable] => ,[audited] => 1,[comment] => Account ID of the parent of this account),[sic_code] => Array ([name] => sic_code,[vname] => LBL_SIC_CODE,[type] => varchar,[len] => 10,[comment] => SIC code of the account),[parent_name] => Array ([name] => parent_name,[rname] => name,[id_name] => parent_id,[vname] => LBL_MEMBER_OF,[type] => relate,[isnull] => true,[module] => Accounts,[table] => accounts,[massupdate] => ,[source] => non-db,[len] => 36,[link] => member_of,[unified_search] => 1,[importable] => true),[members] => Array ([name] => members,[type] => link,[relationship] => member_accounts,[module] => Accounts,[bean_name] => Account,[source] => non-db,[vname] => LBL_MEMBERS),[member_of] => Array ([name] => member_of,[type] => link,[relationship] => member_accounts,[module] => Accounts,[bean_name] => Account,[link_type] => one,[source] => non-db,[vname] => LBL_MEMBER_OF,[side] => right),[email_opt_out] => Array ([name] => email_opt_out,[vname] => LBL_EMAIL_OPT_OUT,[source] => non-db,[type] => bool,[massupdate] => ,[studio] => false),[invalid_email] => Array ([name] => invalid_email,[vname] => LBL_INVALID_EMAIL,[source] => non-db,[type] => bool,[massupdate] => ,[studio] => false),[cases] => Array ([name] => cases,[type] => link,[relationship] => account_cases,[module] => Cases,[bean_name] => aCase,[source] => non-db,[vname] => LBL_CASES),[email] => Array ([name] => email,[type] => email,[query_type] => default,[source] => non-db,[operator] => subquery,[subquery] => SELECT eabr.bean_id FROM email_addr_bean_rel eabr JOIN email_addresses ea ON (ea.id = eabr.email_address_id) WHERE eabr.deleted=0 AND ea.email_address LIKE,[db_field] => Array ([0] => id),[vname] => LBL_ANY_EMAIL,[studio] => Array ([visible] => ,[searchview] => 1),[importable] => ),[tasks] => Array ([name] => tasks,[type] => link,[relationship] => account_tasks,[module] => Tasks,[bean_name] => Task,[source] => non-db,[vname] => LBL_TASKS),[notes] => Array ([name] => notes,[type] => link,[relationship] => account_notes,[module] => Notes,[bean_name] => Note,[source] => non-db,[vname] => LBL_NOTES),[meetings] => Array ([name] => meetings,[type] => link,[relationship] => account_meetings,[module] => Meetings,[bean_name] => Meeting,[source] => non-db,[vname] => LBL_MEETINGS),[calls] => Array ([name] => calls,[type] => link,[relationship] => account_calls,[module] => Calls,[bean_name] => Call,[source] => non-db,[vname] => LBL_CALLS),[emails] => Array ([name] => emails,[type] => link,[relationship] => emails_accounts_rel,[module] => Emails,[bean_name] => Email,[source] => non-db,[vname] => LBL_EMAILS,[studio] => Array ([formula] => )),[documents] => Array ([name] => documents,[type] => link,[relationship] => documents_accounts,[source] => non-db,[vname] => LBL_DOCUMENTS_SUBPANEL_TITLE),[bugs] => Array ([name] => bugs,[type] => link,[relationship] => accounts_bugs,[module] => Bugs,[bean_name] => Bug,[source] => non-db,[vname] => LBL_BUGS),[contacts] => Array ([name] => contacts,[type] => link,[relationship] => accounts_contacts,[module] => Contacts,[bean_name] => Contact,[source] => non-db,[vname] => LBL_CONTACTS),[opportunities] => Array ([name] => opportunities,[type] => link,[relationship] => accounts_opportunities,[module] => Opportunities,[bean_name] => Opportunity,[source] => non-db,[vname] => LBL_OPPORTUNITY),[project] => Array ([name] => project,[type] => link,[relationship] => projects_accounts,[module] => Project,[bean_name] => Project,[source] => non-db,[vname] => LBL_PROJECTS),[leads] => Array ([name] => leads,[type] => link,[relationship] => account_leads,[module] => Leads,[bean_name] => Lead,[source] => non-db,[vname] => LBL_LEADS),[campaigns] => Array ([name] => campaigns,[type] => link,[relationship] => account_campaign_log,[module] => CampaignLog,[bean_name] => CampaignLog,[source] => non-db,[vname] => LBL_CAMPAIGNLOG,[studio] => Array ([formula] => )),[campaign_accounts] => Array ([name] => campaign_accounts,[type] => link,[vname] => LBL_CAMPAIGNS,[relationship] => campaign_accounts,[source] => non-db),[campaign_id] => Array ([name] => campaign_id,[comment] => Campaign that generated Account,[vname] => LBL_CAMPAIGN_ID,[rname] => id,[id_name] => campaign_id,[type] => id,[table] => campaigns,[isnull] => true,[module] => Campaigns,[reportable] => ,[massupdate] => ,[duplicate_merge] => disabled),[campaign_name] => Array ([name] => campaign_name,[rname] => name,[vname] => LBL_CAMPAIGN,[type] => relate,[reportable] => ,[source] => non-db,[table] => campaigns,[id_name] => campaign_id,[link] => campaign_accounts,[module] => Campaigns,[duplicate_merge] => disabled,[comment] => The first campaign name for Account (Meta-data only)),[prospect_lists] => Array ([name] => prospect_lists,[type] => link,[relationship] => prospect_list_accounts,[module] => ProspectLists,[source] => non-db,[vname] => LBL_PROSPECT_LIST),[aos_quotes] => Array ([name] => aos_quotes,[vname] => LBL_AOS_QUOTES,[type] => link,[relationship] => account_aos_quotes,[module] => AOS_Quotes,[bean_name] => AOS_Quotes,[source] => non-db),[aos_invoices] => Array ([name] => aos_invoices,[vname] => LBL_AOS_INVOICES,[type] => link,[relationship] => account_aos_invoices,[module] => AOS_Invoices,[bean_name] => AOS_Invoices,[source] => non-db),[aos_contracts] => Array ([name] => aos_contracts,[vname] => LBL_AOS_CONTRACTS,[type] => link,[relationship] => account_aos_contracts,[module] => AOS_Contracts,[bean_name] => AOS_Contracts,[source] => non-db),[jjwg_maps_address_c] => Array ([inline_edit] => 1,[required] => ,[source] => custom_fields,[name] => jjwg_maps_address_c,[vname] => LBL_JJWG_MAPS_ADDRESS,[type] => varchar,[massupdate] => 0,[default] => ,[no_default] => ,[comments] => Address,[help] => Address,[importable] => true,[duplicate_merge] => disabled,[duplicate_merge_dom_value] => 0,[audited] => ,[reportable] => 1,[unified_search] => ,[merge_filter] => disabled,[len] => 255,[size] => 20,[id] => Accountsjjwg_maps_address_c,[custom_module] => Accounts),[jjwg_maps_geocode_status_c] => Array ([inline_edit] => 1,[required] => ,[source] => custom_fields,[name] => jjwg_maps_geocode_status_c,[vname] => LBL_JJWG_MAPS_GEOCODE_STATUS,[type] => varchar,[massupdate] => 0,[default] => ,[no_default] => ,[comments] => Geocode Status,[help] => Geocode Status,[importable] => true,[duplicate_merge] => disabled,[duplicate_merge_dom_value] => 0,[audited] => ,[reportable] => 1,[unified_search] => ,[merge_filter] => disabled,[len] => 255,[size] => 20,[id] => Accountsjjwg_maps_geocode_status_c,[custom_module] => Accounts),[jjwg_maps_lat_c] => Array ([inline_edit] => 1,[required] => ,[source] => custom_fields,[name] => jjwg_maps_lat_c,[vname] => LBL_JJWG_MAPS_LAT,[type] => float,[massupdate] => 0,[default] => 0.00000000,[no_default] => ,[comments] => ,[help] => Latitude,[importable] => true,[duplicate_merge] => disabled,[duplicate_merge_dom_value] => 0,[audited] => ,[reportable] => 1,[unified_search] => ,[merge_filter] => disabled,[len] => 10,[size] => 20,[enable_range_search] => ,[precision] => 8,[id] => Accountsjjwg_maps_lat_c,[custom_module] => Accounts),[jjwg_maps_lng_c] => Array ([inline_edit] => 1,[required] => ,[source] => custom_fields,[name] => jjwg_maps_lng_c,[vname] => LBL_JJWG_MAPS_LNG,[type] => float,[massupdate] => 0,[default] => 0.00000000,[no_default] => ,[comments] => ,[help] => Longitude,[importable] => true,[duplicate_merge] => disabled,[duplicate_merge_dom_value] => 0,[audited] => ,[reportable] => 1,[unified_search] => ,[merge_filter] => disabled,[len] => 11,[size] => 20,[enable_range_search] => ,[precision] => 8,[id] => Accountsjjwg_maps_lng_c,[custom_module] => Accounts)),[date_entered] => ,[date_modified] => ,[modified_user_id] => ,[assigned_user_id] => ,[annual_revenue] => ,[billing_address_street] => ,[billing_address_city] => ,[billing_address_state] => ,[billing_address_country] => ,[billing_address_postalcode] => ,[billing_address_street_2] => ,[billing_address_street_3] => ,[billing_address_street_4] => ,[description] => ,[email1] => ,[email2] => ,[email_opt_out] => ,[invalid_email] => ,[employees] => ,[id] => ,[industry] => ,[name] => ,[ownership] => ,[parent_id] => ,[phone_alternate] => ,[phone_fax] => ,[phone_office] => ,[rating] => ,[shipping_address_street] => ,[shipping_address_city] => ,[shipping_address_state] => ,[shipping_address_country] => ,[shipping_address_postalcode] => ,[shipping_address_street_2] => ,[shipping_address_street_3] => ,[shipping_address_street_4] => ,[campaign_id] => ,[sic_code] => ,[ticker_symbol] => ,[account_type] => ,[website] => ,[custom_fields] => DynamicField Object ([use_existing_labels] => ,[base_path] => custom/Extension/modules/Accounts/Ext/Vardefs,[db] => SqlsrvManager Object ([dbName] => SQL Server,[variant] => sqlsrv,[priority] => 10,[label] => LBL_MSSQL_SQLSRV,[] => Array ([affected_rows] => 1,[fulltext] => 1,[limit_subquery] => 1,[create_user] => 1,[create_db] => 1),[] => Array ([int] => int,[double] => float,[float] => float,[uint] => int,[ulong] => int,[long] => bigint,[short] => smallint,[varchar] => nvarchar,[text] => nvarchar(max),[longtext] => nvarchar(max),[date] => datetime,[enum] => nvarchar,[relate] => nvarchar,[multienum] => nvarchar(max),[html] => nvarchar(max),[longhtml] => nvarchar(max),[datetime] => datetime,[datetimecombo] => datetime,[time] => datetime,[bool] => bit,[tinyint] => tinyint,[char] => char,[blob] => nvarchar(max),[longblob] => nvarchar(max),[currency] => decimal(26,6),[decimal] => decimal,[decimal2] => decimal,[id] => varchar(36),[url] => nvarchar,[encrypt] => nvarchar,[file] => nvarchar,[decimal_tpl] => decimal(%d, %d)),[dbType] => mssql,[] => Array ([table] => 128,[column] => 128,[index] => 128,[alias] => 128),[] => Array ([db_host_name] => DESKTOP-9H6S3G4,[db_host_instance] => ,[db_user_name] => sa,[db_password] => Securitywhm01,[db_name] => suitecrmprod,[db_type] => mssql,[db_port] => ,[db_manager] => SqlsrvManager),[] => Array ([%Y-%m-%d] => 10,[%Y-%m] => 7,[%Y] => 4),[database] => Resource id #6,[] => ,[] => 1,[] => 0.0021419525146484,[] => ,[] => ,[] => Array (),[] => TimeDate Object ([dbDayFormat] => Y-m-d,[dbTimeFormat] => H:i:s,[] => SugarDateTime Object ([] => Array ([sec] => s,[min] => i,[hour] => G,[zhour] => H,[day] => j,[zday] => d,[days_in_month] => t,[day_of_week] => w,[day_of_year] => z,[week] => W,[month] => n,[zmonth] => m,[year] => Y,[am_pm] => A,[hour_12] => g),[] => Array ([24_hour] => hour,[day_of_week] => day_of_week_long,[day_of_week_short] => day_of_week_short,[month_name] => month_long,[hour] => hour_12),[] => ,[date] => 2017-09-15 08:46:28.000000,[timezone_type] => 3,[timezone] => UTC),[] => ,[] => 1,[] => DateTimeZone Object ([timezone_type] => 3,[timezone] => Africa/Johannesburg),[] => ,[] => ,[allow_cache] => 1,[] => Array ([yesterday] => Array ([0] => -1 day,[1] => -1 day),[today] => Array ([0] => ,[1] => ),[tomorrow] => Array ([0] => +1 day,[1] => +1 day),[last_7_days] => Array ([0] => -6 days,[1] => ),[next_7_days] => Array ([0] => ,[1] => +6 days),[last_30_days] => Array ([0] => -29 days,[1] => ),[next_30_days] => Array ([0] => ,[1] => +29 days))),[] => LoggerManager Object ([] => fatal),[] => Array ([int] => int,[double] => float,[float] => float,[uint] => int,[ulong] => bigint,[long] => bigint,[short] => int,[date] => date,[datetime] => date,[datetimecombo] => date,[time] => time,[bool] => bool,[tinyint] => int,[currency] => float,[decimal] => float,[decimal2] => float),[] => Array ([persistent] => 1,[autofree] => ,[debug] => 0,[ssl] => ),[] => Array ([ALTER TABLE] => verifyAlterTable,[DROP TABLE] => verifyDropTable,[CREATE TABLE] => verifyCreateTable,[INSERT INTO] => verifyInsertInto,[UPDATE] => verifyUpdate,[DELETE FROM] => verifyDeleteFrom),[helper] => SqlsrvManager Object ( *RECURSION*,[count_id] => 1,[references] => 34,[lastsql] => SELECT accounts.*,accounts_cstm.* FROM accounts LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c WHERE accounts.id = '' AND accounts.deleted=0),[bean] => Account Object ( *RECURSION*,[module] => Accounts),[created_by] => ,[created_by_name] => ,[modified_by_name] => ,[opportunity_id] => ,[case_id] => ,[contact_id] => ,[task_id] => ,[note_id] => ,[meeting_id] => ,[call_id] => ,[email_id] => ,[member_id] => ,[parent_name] => ,[assigned_user_name] => ,[account_id] => ,[account_name] => ,[bug_id] => ,[module_dir] => Accounts,[emailAddress] => SugarEmailAddress Object ([table_name] => email_addresses,[module_name] => EmailAddresses,[module_dir] => EmailAddresses,[object_name] => EmailAddress,[regex] => /^(?:['\.\-\+&#!$\*=\?\^_{}~/\w]+)@(?:(?:\d{1,3}.\d{1,3}.\d{1,3}.\d{1,3})|\w+(?:[.-]\w+)(?:.[\w-]{2,})+)$/,[disable_custom_fields] => 1,[db] => SqlsrvManager Object ([dbName] => SQL Server,[variant] => sqlsrv,[priority] => 10,[label] => LBL_MSSQL_SQLSRV,[] => Array ([affected_rows] => 1,[fulltext] => 1,[limit_subquery] => 1,[create_user] => 1,[create_db] => 1),[] => Array ([int] => int,[double] => float,[float] => float,[uint] => int,[ulong] => int,[long] => bigint,[short] => smallint,[varchar] => nvarchar,[text] => nvarchar(max),[longtext] => nvarchar(max),[date] => datetime,[enum] => nvarchar,[relate] => nvarchar,[multienum] => nvarchar(max),[html] => nvarchar(max),[longhtml] => nvarchar(max),[datetime] => datetime,[datetimecombo] => datetime,[time] => datetime,[bool] => bit,[tinyint] => tinyint,[char] => char,[blob] => nvarchar(max),[longblob] => nvarchar(max),[currency] => decimal(26,6),[decimal] => decimal,[decimal2] => decimal,[id] => varchar(36),[url] => nvarchar,[encrypt] => nvarchar,[file] => nvarchar,[decimal_tpl] => decimal(%d, %d)),[dbType] => mssql,[] => Array ([table] => 128,[column] => 128,[index] => 128,[alias] => 128),[] => Array ([db_host_name] => DESKTOP-9H6S3G4,[db_host_instance] => ,[db_user_name] => sa,[db_password] => Securitywhm01,[db_name] => suitecrmprod,[db_type] => mssql,[db_port] => ,[db_manager] => SqlsrvManager),[] => Array ([%Y-%m-%d] => 10,[%Y-%m] => 7,[%Y] => 4),[database] => Resource id #6,[] => ,[] => 1,[] => 0.0021419525146484,[] => ,[] => ,[] => Array (),[] => TimeDate Object ([dbDayFormat] => Y-m-d,[dbTimeFormat] => H:i:s,[] => SugarDateTime Object ([] => Array ([sec] => s,[min] => i,[hour] => G,[zhour] => H,[day] => j,[zday] => d,[days_in_month] => t,[day_of_week] => w,[day_of_year] => z,[week] => W,[month] => n,[zmonth] => m,[year] => Y,[am_pm] => A,[hour_12] => g),[] => Array ([24_hour] => hour,[day_of_week] => day_of_week_long,[day_of_week_short] => day_of_week_short,[month_name] => month_long,[hour] => hour_12),[] => ,[date] => 2017-09-15 08:46:28.000000,[timezone_type] => 3,[timezone] => UTC),[] => ,[] => 1,[] => DateTimeZone Object ([timezone_type] => 3,[timezone] => Africa/Johannesburg),[] => ,[] => ,[allow_cache] => 1,[] => Array ([yesterday] => Array ([0] => -1 day,[1] => -1 day),[today] => Array ([0] => ,[1] => ),[tomorrow] => Array ([0] => +1 day,[1] => +1 day),[last_7_days] => Array ([0] => -6 days,[1] => ),[next_7_days] => Array ([0] => ,[1] => +6 days),[last_30_days] => Array ([0] => -29 days,[1] => ),[next_30_days] => Array ([0] => ,[1] => +29 days))),[] => LoggerManager Object ([] => fatal),[] => Array ([int] => int,[double] => float,[float] => float,[uint] => int,[ulong] => bigint,[long] => bigint,[short] => int,[date] => date,[datetime] => date,[datetimecombo] => date,[time] => time,[bool] => bool,[tinyint] => int,[currency] => float,[decimal] => float,[decimal2] => float),[] => Array ([persistent] => 1,[autofree] => ,[debug] => 0,[ssl] => ),[] => Array ([ALTER TABLE] => verifyAlterTable,[DROP TABLE] => verifyDropTable,[CREATE TABLE] => verifyCreateTable,[INSERT INTO] => verifyInsertInto,[UPDATE] => verifyUpdate,[DELETE FROM] => verifyDeleteFrom),[helper] => SqlsrvManager Object ( RECURSION,[count_id] => 1,[references] => 34,[lastsql] => SELECT accounts.,accounts_cstm. FROM accounts LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c WHERE accounts.id = '' AND accounts.deleted=0),[smarty] => ,[addresses] => Array (),[view] => ,[] => ,[email_address] => ,[id] => ,[new_with_id] => ,[disable_vardefs] => ,[new_assigned_user_name] => ,[processed_dates_times] => Array (),[process_save_dates] => 1,[save_from_post] => 1,[duplicates_found] => ,[deleted] => 0,[update_date_modified] => 1,[update_modified_by] => 1,[update_date_entered] => ,[set_created_by] => 1,[ungreedy_count] => ,[field_name_map] => Array ([id] => Array ([name] => id,[type] => id,[vname] => LBL_EMAIL_ADDRESS_ID,[required] => 1),[email_address] => Array ([name] => email_address,[type] => varchar,[vname] => LBL_EMAIL_ADDRESS,[length] => 100,[required] => 1),[email_address_caps] => Array ([name] => email_address_caps,[type] => varchar,[vname] => LBL_EMAIL_ADDRESS_CAPS,[length] => 100,[required] => 1,[reportable] => ),[invalid_email] => Array ([name] => invalid_email,[type] => bool,[default] => 0,[vname] => LBL_INVALID_EMAIL),[opt_out] => Array ([name] => opt_out,[type] => bool,[default] => 0,[vname] => LBL_OPT_OUT),[date_created] => Array ([name] => date_created,[type] => datetime,[vname] => LBL_DATE_CREATE),[date_modified] => Array ([name] => date_modified,[type] => datetime,[vname] => LBL_DATE_MODIFIED),[deleted] => Array ([name] => deleted,[type] => bool,[default] => 0,[vname] => LBL_DELETED)),[field_defs] => Array ([id] => Array ([name] => id,[type] => id,[vname] => LBL_EMAIL_ADDRESS_ID,[required] => 1),[email_address] => Array ([name] => email_address,[type] => varchar,[vname] => LBL_EMAIL_ADDRESS,[length] => 100,[required] => 1),[email_address_caps] => Array ([name] => email_address_caps,[type] => varchar,[vname] => LBL_EMAIL_ADDRESS_CAPS,[length] => 100,[required] => 1,[reportable] => ),[invalid_email] => Array ([name] => invalid_email,[type] => bool,[default] => 0,[vname] => LBL_INVALID_EMAIL),[opt_out] => Array ([name] => opt_out,[type] => bool,[default] => 0,[vname] => LBL_OPT_OUT),[date_created] => Array ([name] => date_created,[type] => datetime,[vname] => LBL_DATE_CREATE),[date_modified] => Array ([name] => date_modified,[type] => datetime,[vname] => LBL_DATE_MODIFIED),[deleted] => Array ([name] => deleted,[type] => bool,[default] => 0,[vname] => LBL_DELETED)),[custom_fields] => ,[column_fields] => Array ([0] => id,[1] => email_address,[2] => email_address_caps,[3] => invalid_email,[4] => opt_out,[5] => date_created,[6] => date_modified,[7] => deleted),[list_fields] => Array (),[additional_column_fields] => Array (),[relationship_fields] => Array (),[current_notify_user] => ,[fetched_row] => ,[fetched_rel_row] => Array (),[layout_def] => ,[force_load_details] => ,[optimistic_lock] => ,[number_formatting_done] => ,[process_field_encrypted] => ,[acltype] => module,[additional_meta_fields] => Array (),[notify_inworkflow] => ,[name] => ,[description] => ,[date_entered] => ,[date_modified] => ,[modified_user_id] => ,[assigned_user_id] => ,[created_by] => ,[created_by_name] => ,[modified_by_name] => ,[importable] => ,[special_notification] => ,[in_workflow] => ,[tracker_visibility] => 1,[listview_inner_join] => Array (),[in_import] => ,[in_save] => ,[logicHookDepth] => ,[] => 10,[] => Array (),[] => ,[required_fields] => Array ([id] => 1,[email_address] => 1,[email_address_caps] => 1),[added_custom_field_defs] => 1,[invalid_email] => 0,[opt_out] => 0,[index] => 4),[table_name] => accounts,[object_name] => Account,[importable] => 1,[new_schema] => 1,[additional_column_fields] => Array ([0] => assigned_user_name,[1] => assigned_user_id,[2] => opportunity_id,[3] => bug_id,[4] => case_id,[5] => contact_id,[6] => task_id,[7] => note_id,[8] => meeting_id,[9] => call_id,[10] => email_id,[11] => parent_name,[12] => member_id),[relationship_fields] => Array ([opportunity_id] => opportunities,[bug_id] => bugs,[case_id] => cases,[contact_id] => contacts,[task_id] => tasks,[note_id] => notes,[meeting_id] => meetings,[call_id] => calls,[email_id] => emails,[member_id] => members,[project_id] => project),[push_billing] => ,[push_shipping] => ,[db] => SqlsrvManager Object ([dbName] => SQL Server,[variant] => sqlsrv,[priority] => 10,[label] => LBL_MSSQL_SQLSRV,[] => Array ([affected_rows] => 1,[fulltext] => 1,[limit_subquery] => 1,[create_user] => 1,[create_db] => 1),[] => Array ([int] => int,[double] => float,[float] => float,[uint] => int,[ulong] => int,[long] => bigint,[short] => smallint,[varchar] => nvarchar,[text] => nvarchar(max),[longtext] => nvarchar(max),[date] => datetime,[enum] => nvarchar,[relate] => nvarchar,[multienum] => nvarchar(max),[html] => nvarchar(max),[longhtml] => nvarchar(max),[datetime] => datetime,[datetimecombo] => datetime,[time] => datetime,[bool] => bit,[tinyint] => tinyint,[char] => char,[blob] => nvarchar(max),[longblob] => nvarchar(max),[currency] => decimal(26,6),[decimal] => decimal,[decimal2] => decimal,[id] => varchar(36),[url] => nvarchar,[encrypt] => nvarchar,[file] => nvarchar,[decimal_tpl] => decimal(%d, %d)),[dbType] => mssql,[] => Array ([table] => 128,[column] => 128,[index] => 128,[alias] => 128),[] => Array ([db_host_name] => DESKTOP-9H6S3G4,[db_host_instance] => ,[db_user_name] => sa,[db_password] => Securitywhm01,[db_name] => suitecrmprod,[db_type] => mssql,[db_port] => ,[db_manager] => SqlsrvManager),[] => Array ([%Y-%m-%d] => 10,[%Y-%m] => 7,[%Y] => 4),[database] => Resource id #6,[] => ,[] => 1,[] => 0.0021419525146484,[] => ,[] => ,[] => Array (),[] => TimeDate Object ([dbDayFormat] => Y-m-d,[dbTimeFormat] => H:i:s,[] => SugarDateTime Object ([] => Array ([sec] => s,[min] => i,[hour] => G,[zhour] => H,[day] => j,[zday] => d,[days_in_month] => t,[day_of_week] => w,[day_of_year] => z,[week] => W,[month] => n,[zmonth] => m,[year] => Y,[am_pm] => A,[hour_12] => g),[] => Array ([24_hour] => hour,[day_of_week] => day_of_week_long,[day_of_week_short] => day_of_week_short,[month_name] => month_long,[hour] => hour_12),[] => ,[date] => 2017-09-15 08:46:28.000000,[timezone_type] => 3,[timezone] => UTC),[] => ,[] => 1,[] => DateTimeZone Object ([timezone_type] => 3,[timezone] => Africa/Johannesburg),[] => ,[] => ,[allow_cache] => 1,[] => Array ([yesterday] => Array ([0] => -1 day,[1] => -1 day),[today] => Array ([0] => ,[1] => ),[tomorrow] => Array ([0] => +1 day,[1] => +1 day),[last_7_days] => Array ([0] => -6 days,[1] => ),[next_7_days] => Array ([0] => ,[1] => +6 days),[last_30_days] => Array ([0] => -29 days,[1] => ),[next_30_days] => Array ([0] => ,[1] => +29 days))),[] => LoggerManager Object ([] => fatal),[] => Array ([int] => int,[double] => float,[float] => float,[uint] => int,[ulong] => bigint,[long] => bigint,[short] => int,[date] => date,[datetime] => date,[datetimecombo] => date,[time] => time,[bool] => bool,[tinyint] => int,[currency] => float,[decimal] => float,[decimal2] => float),[] => Array ([persistent] => 1,[autofree] => ,[debug] => 0,[ssl] => ),[] => Array ([ALTER TABLE] => verifyAlterTable,[DROP TABLE] => verifyDropTable,[CREATE TABLE] => verifyCreateTable,[INSERT INTO] => verifyInsertInto,[UPDATE] => verifyUpdate,[DELETE FROM] => verifyDeleteFrom),[helper] => SqlsrvManager Object ( RECURSION,[count_id] => 1,[references] => 34,[lastsql] => SELECT accounts.,accounts_cstm. FROM accounts LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c WHERE accounts.id = '' AND accounts.deleted=0),[new_with_id] => ,[disable_vardefs] => ,[new_assigned_user_name] => ,[processed_dates_times] => Array (),[process_save_dates] => 1,[save_from_post] => 1,[duplicates_found] => ,[deleted] => 0,[update_date_modified] => 1,[update_modified_by] => 1,[update_date_entered] => ,[set_created_by] => 1,[ungreedy_count] => ,[module_name] => Accounts,[field_defs] => Array ([id] => Array ([name] => id,[vname] => LBL_ID,[type] => id,[required] => 1,[reportable] => 1,[comment] => Unique identifier,[inline_edit] => ),[name] => Array ([name] => name,[type] => name,[dbType] => varchar,[vname] => LBL_NAME,[len] => 150,[comment] => Name of the Company,[unified_search] => 1,[full_text_search] => Array ([boost] => 3),[audited] => 1,[required] => 1,[importable] => required,[merge_filter] => selected),[date_entered] => Array ([name] => date_entered,[vname] => LBL_DATE_ENTERED,[type] => datetime,[group] => created_by_name,[comment] => Date record created,[enable_range_search] => 1,[options] => date_range_search_dom,[inline_edit] => ),[date_modified] => Array ([name] => date_modified,[vname] => LBL_DATE_MODIFIED,[type] => datetime,[group] => modified_by_name,[comment] => Date record last modified,[enable_range_search] => 1,[options] => date_range_search_dom,[inline_edit] => ),[modified_user_id] => Array ([name] => modified_user_id,[rname] => user_name,[id_name] => modified_user_id,[vname] => LBL_MODIFIED,[type] => assigned_user_name,[table] => users,[isnull] => false,[group] => modified_by_name,[dbType] => id,[reportable] => 1,[comment] => User who last modified record,[massupdate] => ,[inline_edit] => ),[modified_by_name] => Array ([name] => modified_by_name,[vname] => LBL_MODIFIED_NAME,[type] => relate,[reportable] => ,[source] => non-db,[rname] => user_name,[table] => users,[id_name] => modified_user_id,[module] => Users,[link] => modified_user_link,[duplicate_merge] => disabled,[massupdate] => ,[inline_edit] => ),[created_by] => Array ([name] => created_by,[rname] => user_name,[id_name] => modified_user_id,[vname] => LBL_CREATED,[type] => assigned_user_name,[table] => users,[isnull] => false,[dbType] => id,[group] => created_by_name,[comment] => User who created record,[massupdate] => ,[inline_edit] => ),[created_by_name] => Array ([name] => created_by_name,[vname] => LBL_CREATED,[type] => relate,[reportable] => ,[link] => created_by_link,[rname] => user_name,[source] => non-db,[table] => users,[id_name] => created_by,[module] => Users,[duplicate_merge] => disabled,[importable] => false,[massupdate] => ,[inline_edit] => ),[description] => Array ([name] => description,[vname] => LBL_DESCRIPTION,[type] => text,[comment] => Full text of the note,[rows] => 6,[cols] => 80),[deleted] => Array ([name] => deleted,[vname] => LBL_DELETED,[type] => bool,[default] => 0,[reportable] => ,[comment] => Record deletion indicator),[created_by_link] => Array ([name] => created_by_link,[type] => link,[relationship] => accounts_created_by,[vname] => LBL_CREATED_BY_USER,[link_type] => one,[module] => Users,[bean_name] => User,[source] => non-db),[modified_user_link] => Array ([name] => modified_user_link,[type] => link,[relationship] => accounts_modified_user,[vname] => LBL_MODIFIED_BY_USER,[link_type] => one,[module] => Users,[bean_name] => User,[source] => non-db),[assigned_user_id] => Array ([name] => assigned_user_id,[rname] => user_name,[id_name] => assigned_user_id,[vname] => LBL_ASSIGNED_TO_ID,[group] => assigned_user_name,[type] => relate,[table] => users,[module] => Users,[reportable] => 1,[isnull] => false,[dbType] => id,[audited] => 1,[comment] => User ID assigned to record,[duplicate_merge] => disabled),[assigned_user_name] => Array ([name] => assigned_user_name,[link] => assigned_user_link,[vname] => LBL_ASSIGNED_TO_NAME,[rname] => user_name,[type] => relate,[reportable] => ,[source] => non-db,[table] => users,[id_name] => assigned_user_id,[module] => Users,[duplicate_merge] => disabled),[assigned_user_link] => Array ([name] => assigned_user_link,[type] => link,[relationship] => accounts_assigned_user,[vname] => LBL_ASSIGNED_TO_USER,[link_type] => one,[module] => Users,[bean_name] => User,[source] => non-db,[duplicate_merge] => enabled,[rname] => user_name,[id_name] => assigned_user_id,[table] => users),[SecurityGroups] => Array ([name] => SecurityGroups,[type] => link,[relationship] => securitygroups_accounts,[module] => SecurityGroups,[bean_name] => SecurityGroup,[source] => non-db,[vname] => LBL_SECURITYGROUPS),[account_type] => Array ([name] => account_type,[vname] => LBL_TYPE,[type] => enum,[options] => account_type_dom,[len] => 50,[comment] => The Company is of this type),[industry] => Array ([name] => industry,[vname] => LBL_INDUSTRY,[type] => enum,[options] => industry_dom,[len] => 50,[comment] => The company belongs in this industry,[merge_filter] => enabled),[annual_revenue] => Array ([name] => annual_revenue,[vname] => LBL_ANNUAL_REVENUE,[type] => varchar,[len] => 100,[comment] => Annual revenue for this company,[merge_filter] => enabled),[phone_fax] => Array ([name] => phone_fax,[vname] => LBL_FAX,[type] => phone,[dbType] => varchar,[len] => 100,[unified_search] => 1,[full_text_search] => Array ([boost] => 1),[comment] => The fax phone number of this company),[billing_address_street] => Array ([name] => billing_address_street,[vname] => LBL_BILLING_ADDRESS_STREET,[type] => varchar,[len] => 150,[comment] => The street address used for billing address,[group] => billing_address,[merge_filter] => enabled),[billing_address_street_2] => Array ([name] => billing_address_street_2,[vname] => LBL_BILLING_ADDRESS_STREET_2,[type] => varchar,[len] => 150,[source] => non-db),[billing_address_street_3] => Array ([name] => billing_address_street_3,[vname] => LBL_BILLING_ADDRESS_STREET_3,[type] => varchar,[len] => 150,[source] => non-db),[billing_address_street_4] => Array ([name] => billing_address_street_4,[vname] => LBL_BILLING_ADDRESS_STREET_4,[type] => varchar,[len] => 150,[source] => non-db),[billing_address_city] => Array ([name] => billing_address_city,[vname] => LBL_BILLING_ADDRESS_CITY,[type] => varchar,[len] => 100,[comment] => The city used for billing address,[group] => billing_address,[merge_filter] => enabled),[billing_address_state] => Array ([name] => billing_address_state,[vname] => LBL_BILLING_ADDRESS_STATE,[type] => varchar,[len] => 100,[group] => billing_address,[comment] => The state used for billing address,[merge_filter] => enabled),[billing_address_postalcode] => Array ([name] => billing_address_postalcode,[vname] => LBL_BILLING_ADDRESS_POSTALCODE,[type] => varchar,[len] => 20,[group] => billing_address,[comment] => The postal code used for billing address,[merge_filter] => enabled),[billing_address_country] => Array ([name] => billing_address_country,[vname] => LBL_BILLING_ADDRESS_COUNTRY,[type] => varchar,[group] => billing_address,[comment] => The country used for the billing address,[merge_filter] => enabled),[rating] => Array ([name] => rating,[vname] => LBL_RATING,[type] => varchar,[len] => 100,[comment] => An arbitrary rating for this company for use in comparisons with others),[phone_office] => Array ([name] => phone_office,[vname] => LBL_PHONE_OFFICE,[type] => phone,[dbType] => varchar,[len] => 100,[audited] => 1,[unified_search] => 1,[full_text_search] => Array ([boost] => 1),[comment] => The office phone number,[merge_filter] => enabled),[phone_alternate] => Array ([name] => phone_alternate,[vname] => LBL_PHONE_ALT,[type] => phone,[group] => phone_office,[dbType] => varchar,[len] => 100,[unified_search] => 1,[full_text_search] => Array ([boost] => 1),[comment] => An alternate phone number,[merge_filter] => enabled),[website] => Array ([name] => website,[vname] => LBL_WEBSITE,[type] => url,[dbType] => varchar,[len] => 255,[comment] => URL of website for the company),[ownership] => Array ([name] => ownership,[vname] => LBL_OWNERSHIP,[type] => varchar,[len] => 100,[comment] => ),[employees] => Array ([name] => employees,[vname] => LBL_EMPLOYEES,[type] => varchar,[len] => 10,[comment] => Number of employees, varchar to accomodate for both number (100) or range (50-100)),[ticker_symbol] => Array ([name] => ticker_symbol,[vname] => LBL_TICKER_SYMBOL,[type] => varchar,[len] => 10,[comment] => The stock trading (ticker) symbol for the company,[merge_filter] => enabled),[shipping_address_street] => Array ([name] => shipping_address_street,[vname] => LBL_SHIPPING_ADDRESS_STREET,[type] => varchar,[len] => 150,[group] => shipping_address,[comment] => The street address used for for shipping purposes,[merge_filter] => enabled),[shipping_address_street_2] => Array ([name] => shipping_address_street_2,[vname] => LBL_SHIPPING_ADDRESS_STREET_2,[type] => varchar,[len] => 150,[source] => non-db),[shipping_address_street_3] => Array ([name] => shipping_address_street_3,[vname] => LBL_SHIPPING_ADDRESS_STREET_3,[type] => varchar,[len] => 150,[source] => non-db),[shipping_address_street_4] => Array ([name] => shipping_address_street_4,[vname] => LBL_SHIPPING_ADDRESS_STREET_4,[type] => varchar,[len] => 150,[source] => non-db),[shipping_address_city] => Array ([name] => shipping_address_city,[vname] => LBL_SHIPPING_ADDRESS_CITY,[type] => varchar,[len] => 100,[group] => shipping_address,[comment] => The city used for the shipping address,[merge_filter] => enabled),[shipping_address_state] => Array ([name] => shipping_address_state,[vname] => LBL_SHIPPING_ADDRESS_STATE,[type] => varchar,[len] => 100,[group] => shipping_address,[comment] => The state used for the shipping address,[merge_filter] => enabled),[shipping_address_postalcode] => Array ([name] => shipping_address_postalcode,[vname] => LBL_SHIPPING_ADDRESS_POSTALCODE,[type] => varchar,[len] => 20,[group] => shipping_address,[comment] => The zip code used for the shipping address,[merge_filter] => enabled),[shipping_address_country] => Array ([name] => shipping_address_country,[vname] => LBL_SHIPPING_ADDRESS_COUNTRY,[type] => varchar,[group] => shipping_address,[comment] => The country used for the shipping address,[merge_filter] => enabled),[email1] => Array ([name] => email1,[vname] => LBL_EMAIL,[group] => email1,[type] => varchar,[function] => Array ([name] => getEmailAddressWidget,[returns] => html),[source] => non-db,[studio] => Array ([editField] => 1,[searchview] => ),[full_text_search] => Array ([boost] => 3,[analyzer] => whitespace)),[email_addresses_primary] => Array ([name] => email_addresses_primary,[type] => link,[relationship] => accounts_email_addresses_primary,[source] => non-db,[vname] => LBL_EMAIL_ADDRESS_PRIMARY,[duplicate_merge] => disabled,[studio] => Array ([formula] => )),[email_addresses] => Array ([name] => email_addresses,[type] => link,[relationship] => accounts_email_addresses,[source] => non-db,[vname] => LBL_EMAIL_ADDRESSES,[reportable] => ,[unified_search] => 1,[rel_fields] => Array ([primary_address] => Array ([type] => bool)),[studio] => Array ([formula] => )),[email_addresses_non_primary] => Array ([name] => email_addresses_non_primary,[type] => email,[source] => non-db,[vname] => LBL_EMAIL_NON_PRIMARY,[studio] => ,[reportable] => ,[massupdate] => ),[parent_id] => Array ([name] => parent_id,[vname] => LBL_PARENT_ACCOUNT_ID,[type] => id,[required] => ,[reportable] => ,[audited] => 1,[comment] => Account ID of the parent of this account),[sic_code] => Array ([name] => sic_code,[vname] => LBL_SIC_CODE,[type] => varchar,[len] => 10,[comment] => SIC code of the account),[parent_name] => Array ([name] => parent_name,[rname] => name,[id_name] => parent_id,[vname] => LBL_MEMBER_OF,[type] => relate,[isnull] => true,[module] => Accounts,[table] => accounts,[massupdate] => ,[source] => non-db,[len] => 36,[link] => member_of,[unified_search] => 1,[importable] => true),[members] => Array ([name] => members,[type] => link,[relationship] => member_accounts,[module] => Accounts,[bean_name] => Account,[source] => non-db,[vname] => LBL_MEMBERS),[member_of] => Array ([name] => member_of,[type] => link,[relationship] => member_accounts,[module] => Accounts,[bean_name] => Account,[link_type] => one,[source] => non-db,[vname] => LBL_MEMBER_OF,[side] => right),[email_opt_out] => Array ([name] => email_opt_out,[vname] => LBL_EMAIL_OPT_OUT,[source] => non-db,[type] => bool,[massupdate] => ,[studio] => false),[invalid_email] => Array ([name] => invalid_email,[vname] => LBL_INVALID_EMAIL,[source] => non-db,[type] => bool,[massupdate] => ,[studio] => false),[cases] => Array ([name] => cases,[type] => link,[relationship] => account_cases,[module] => Cases,[bean_name] => aCase,[source] => non-db,[vname] => LBL_CASES),[email] => Array ([name] => email,[type] => email,[query_type] => default,[source] => non-db,[operator] => subquery,[subquery] => SELECT eabr.bean_id FROM email_addr_bean_rel eabr JOIN email_addresses ea ON (ea.id = eabr.email_address_id) WHERE eabr.deleted=0 AND ea.email_address LIKE,[db_field] => Array ([0] => id),[vname] => LBL_ANY_EMAIL,[studio] => Array ([visible] => ,[searchview] => 1),[importable] => ),[tasks] => Array ([name] => tasks,[type] => link,[relationship] => account_tasks,[module] => Tasks,[bean_name] => Task,[source] => non-db,[vname] => LBL_TASKS),[notes] => Array ([name] => notes,[type] => link,[relationship] => account_notes,[module] => Notes,[bean_name] => Note,[source] => non-db,[vname] => LBL_NOTES),[meetings] => Array ([name] => meetings,[type] => link,[relationship] => account_meetings,[module] => Meetings,[bean_name] => Meeting,[source] => non-db,[vname] => LBL_MEETINGS),[calls] => Array ([name] => calls,[type] => link,[relationship] => account_calls,[module] => Calls,[bean_name] => Call,[source] => non-db,[vname] => LBL_CALLS),[emails] => Array ([name] => emails,[type] => link,[relationship] => emails_accounts_rel,[module] => Emails,[bean_name] => Email,[source] => non-db,[vname] => LBL_EMAILS,[studio] => Array ([formula] => )),[documents] => Array ([name] => documents,[type] => link,[relationship] => documents_accounts,[source] => non-db,[vname] => LBL_DOCUMENTS_SUBPANEL_TITLE),[bugs] => Array ([name] => bugs,[type] => link,[relationship] => accounts_bugs,[module] => Bugs,[bean_name] => Bug,[source] => non-db,[vname] => LBL_BUGS),[contacts] => Array ([name] => contacts,[type] => link,[relationship] => accounts_contacts,[module] => Contacts,[bean_name] => Contact,[source] => non-db,[vname] => LBL_CONTACTS),[opportunities] => Array ([name] => opportunities,[type] => link,[relationship] => accounts_opportunities,[module] => Opportunities,[bean_name] => Opportunity,[source] => non-db,[vname] => LBL_OPPORTUNITY),[project] => Array ([name] => project,[type] => link,[relationship] => projects_accounts,[module] => Project,[bean_name] => Project,[source] => non-db,[vname] => LBL_PROJECTS),[leads] => Array ([name] => leads,[type] => link,[relationship] => account_leads,[module] => Leads,[bean_name] => Lead,[source] => non-db,[vname] => LBL_LEADS),[campaigns] => Array ([name] => campaigns,[type] => link,[relationship] => account_campaign_log,[module] => CampaignLog,[bean_name] => CampaignLog,[source] => non-db,[vname] => LBL_CAMPAIGNLOG,[studio] => Array ([formula] => )),[campaign_accounts] => Array ([name] => campaign_accounts,[type] => link,[vname] => LBL_CAMPAIGNS,[relationship] => campaign_accounts,[source] => non-db),[campaign_id] => Array ([name] => campaign_id,[comment] => Campaign that generated Account,[vname] => LBL_CAMPAIGN_ID,[rname] => id,[id_name] => campaign_id,[type] => id,[table] => campaigns,[isnull] => true,[module] => Campaigns,[reportable] => ,[massupdate] => ,[duplicate_merge] => disabled),[campaign_name] => Array ([name] => campaign_name,[rname] => name,[vname] => LBL_CAMPAIGN,[type] => relate,[reportable] => ,[source] => non-db,[table] => campaigns,[id_name] => campaign_id,[link] => campaign_accounts,[module] => Campaigns,[duplicate_merge] => disabled,[comment] => The first campaign name for Account (Meta-data only)),[prospect_lists] => Array ([name] => prospect_lists,[type] => link,[relationship] => prospect_list_accounts,[module] => ProspectLists,[source] => non-db,[vname] => LBL_PROSPECT_LIST),[aos_quotes] => Array ([name] => aos_quotes,[vname] => LBL_AOS_QUOTES,[type] => link,[relationship] => account_aos_quotes,[module] => AOS_Quotes,[bean_name] => AOS_Quotes,[source] => non-db),[aos_invoices] => Array ([name] => aos_invoices,[vname] => LBL_AOS_INVOICES,[type] => link,[relationship] => account_aos_invoices,[module] => AOS_Invoices,[bean_name] => AOS_Invoices,[source] => non-db),[aos_contracts] => Array ([name] => aos_contracts,[vname] => LBL_AOS_CONTRACTS,[type] => link,[relationship] => account_aos_contracts,[module] => AOS_Contracts,[bean_name] => AOS_Contracts,[source] => non-db),[jjwg_maps_address_c] => Array ([inline_edit] => 1,[required] => ,[source] => custom_fields,[name] => jjwg_maps_address_c,[vname] => LBL_JJWG_MAPS_ADDRESS,[type] => varchar,[massupdate] => 0,[default] => ,[no_default] => ,[comments] => Address,[help] => Address,[importable] => true,[duplicate_merge] => disabled,[duplicate_merge_dom_value] => 0,[audited] => ,[reportable] => 1,[unified_search] => ,[merge_filter] => disabled,[len] => 255,[size] => 20,[id] => Accountsjjwg_maps_address_c,[custom_module] => Accounts),[jjwg_maps_geocode_status_c] => Array ([inline_edit] => 1,[required] => ,[source] => custom_fields,[name] => jjwg_maps_geocode_status_c,[vname] => LBL_JJWG_MAPS_GEOCODE_STATUS,[type] => varchar,[massupdate] => 0,[default] => ,[no_default] => ,[comments] => Geocode Status,[help] => Geocode Status,[importable] => true,[duplicate_merge] => disabled,[duplicate_merge_dom_value] => 0,[audited] => ,[reportable] => 1,[unified_search] => ,[merge_filter] => disabled,[len] => 255,[size] => 20,[id] => Accountsjjwg_maps_geocode_status_c,[custom_module] => Accounts),[jjwg_maps_lat_c] => Array ([inline_edit] => 1,[required] => ,[source] => custom_fields,[name] => jjwg_maps_lat_c,[vname] => LBL_JJWG_MAPS_LAT,[type] => float,[massupdate] => 0,[default] => 0.00000000,[no_default] => ,[comments] => ,[help] => Latitude,[importable] => true,[duplicate_merge] => disabled,[duplicate_merge_dom_value] => 0,[audited] => ,[reportable] => 1,[unified_search] => ,[merge_filter] => disabled,[len] => 10,[size] => 20,[enable_range_search] => ,[precision] => 8,[id] => Accountsjjwg_maps_lat_c,[custom_module] => Accounts),[jjwg_maps_lng_c] => Array ([inline_edit] => 1,[required] => ,[source] => custom_fields,[name] => jjwg_maps_lng_c,[vname] => LBL_JJWG_MAPS_LNG,[type] => float,[massupdate] => 0,[default] => 0.00000000,[no_default] => ,[comments] => ,[help] => Longitude,[importable] => true,[duplicate_merge] => disabled,[duplicate_merge_dom_value] => 0,[audited] => ,[reportable] => 1,[unified_search] => ,[merge_filter] => disabled,[len] => 11,[size] => 20,[enable_range_search] => ,[precision] => 8,[id] => Accountsjjwg_maps_lng_c,[custom_module] => Accounts)),[column_fields] => Array ([0] => id,[1] => name,[2] => date_entered,[3] => date_modified,[4] => modified_user_id,[5] => modified_by_name,[6] => created_by,[7] => created_by_name,[8] => description,[9] => deleted,[10] => created_by_link,[11] => modified_user_link,[12] => assigned_user_id,[13] => assigned_user_name,[14] => assigned_user_link,[15] => SecurityGroups,[16] => account_type,[17] => industry,[18] => annual_revenue,[19] => phone_fax,[20] => billing_address_street,[21] => billing_address_street_2,[22] => billing_address_street_3,[23] => billing_address_street_4,[24] => billing_address_city,[25] => billing_address_state,[26] => billing_address_postalcode,[27] => billing_address_country,[28] => rating,[29] => phone_office,[30] => phone_alternate,[31] => website,[32] => ownership,[33] => employees,[34] => ticker_symbol,[35] => shipping_address_street,[36] => shipping_address_street_2,[37] => shipping_address_street_3,[38] => shipping_address_street_4,[39] => shipping_address_city,[40] => shipping_address_state,[41] => shipping_address_postalcode,[42] => shipping_address_country,[43] => email1,[44] => email_addresses_primary,[45] => email_addresses,[46] => email_addresses_non_primary,[47] => parent_id,[48] => sic_code,[49] => parent_name,[50] => members,[51] => member_of,[52] => email_opt_out,[53] => invalid_email,[54] => cases,[55] => email,[56] => tasks,[57] => notes,[58] => meetings,[59] => calls,[60] => emails,[61] => documents,[62] => bugs,[63] => contacts,[64] => opportunities,[65] => project,[66] => leads,[67] => campaigns,[68] => campaign_accounts,[69] => campaign_id,[70] => campaign_name,[71] => prospect_lists,[72] => aos_quotes,[73] => aos_invoices,[74] => aos_contracts,[75] => jjwg_maps_address_c,[76] => jjwg_maps_geocode_status_c,[77] => jjwg_maps_lat_c,[78] => jjwg_maps_lng_c),[list_fields] => Array (),[current_notify_user] => ,[fetched_row] => ,[fetched_rel_row] => Array (),[layout_def] => ,[force_load_details] => ,[optimistic_lock] => 1,[disable_custom_fields] => ,[number_formatting_done] => ,[process_field_encrypted] => ,[acltype] => module,[additional_meta_fields] => Array (),[notify_inworkflow] => ,[special_notification] => ,[in_workflow] => ,[tracker_visibility] => 1,[listview_inner_join] => Array (),[in_import] => ,[in_save] => ,[logicHookDepth] => Array ([before_retrieve] => 0),[] => 10,[] => Array (),[] => ,[required_fields] => Array ([id] => 1,[name] => 1),[added_custom_field_defs] => 1,[acl_fields] => 1,[jjwg_maps_lat_c] => 0.00000000,[jjwg_maps_lng_c] => 0.00000000), , , , Array ()) called at [xxx\include\SubPanel\SubPanelDefinitions.php:729]
#1 SubPanelDefinitions->load_subpanel(delegates, , , , Array ()) called at [xxx\include\SubPanel\SubPanel.php:100]
#2 SubPanel->__construct(Accounts, , delegates, , , Array ()) called at [xxx\include\SubPanel\SubPanelSearchDisplay.php:73]
#3 require_once(xxx\include\SubPanel\SubPanelSearchDisplay.php) called at [xxx\include\MVC\Controller\SugarController.php:1074]
#4 SugarController->handleActionMaps() called at [xxx\include\MVC\Controller\SugarController.php:458]
#5 SugarController->process() called at [xxx\include\MVC\Controller\SugarController.php:366]
#6 SugarController->execute() called at [xxx\include\MVC\SugarApplication.php:105]
#7 SugarApplication->execute() called at [xxx\index.php:52]`

@jucedupp commented on GitHub (Sep 15, 2017): @pgorod Herewith the stack trace: `#0 aSubPanel->__construct(delegates, , Account Object ([field_name_map] => Array ([id] => Array ([name] => id,[vname] => LBL_ID,[type] => id,[required] => 1,[reportable] => 1,[comment] => Unique identifier,[inline_edit] => ),[name] => Array ([name] => name,[type] => name,[dbType] => varchar,[vname] => LBL_NAME,[len] => 150,[comment] => Name of the Company,[unified_search] => 1,[full_text_search] => Array ([boost] => 3),[audited] => 1,[required] => 1,[importable] => required,[merge_filter] => selected),[date_entered] => Array ([name] => date_entered,[vname] => LBL_DATE_ENTERED,[type] => datetime,[group] => created_by_name,[comment] => Date record created,[enable_range_search] => 1,[options] => date_range_search_dom,[inline_edit] => ),[date_modified] => Array ([name] => date_modified,[vname] => LBL_DATE_MODIFIED,[type] => datetime,[group] => modified_by_name,[comment] => Date record last modified,[enable_range_search] => 1,[options] => date_range_search_dom,[inline_edit] => ),[modified_user_id] => Array ([name] => modified_user_id,[rname] => user_name,[id_name] => modified_user_id,[vname] => LBL_MODIFIED,[type] => assigned_user_name,[table] => users,[isnull] => false,[group] => modified_by_name,[dbType] => id,[reportable] => 1,[comment] => User who last modified record,[massupdate] => ,[inline_edit] => ),[modified_by_name] => Array ([name] => modified_by_name,[vname] => LBL_MODIFIED_NAME,[type] => relate,[reportable] => ,[source] => non-db,[rname] => user_name,[table] => users,[id_name] => modified_user_id,[module] => Users,[link] => modified_user_link,[duplicate_merge] => disabled,[massupdate] => ,[inline_edit] => ),[created_by] => Array ([name] => created_by,[rname] => user_name,[id_name] => modified_user_id,[vname] => LBL_CREATED,[type] => assigned_user_name,[table] => users,[isnull] => false,[dbType] => id,[group] => created_by_name,[comment] => User who created record,[massupdate] => ,[inline_edit] => ),[created_by_name] => Array ([name] => created_by_name,[vname] => LBL_CREATED,[type] => relate,[reportable] => ,[link] => created_by_link,[rname] => user_name,[source] => non-db,[table] => users,[id_name] => created_by,[module] => Users,[duplicate_merge] => disabled,[importable] => false,[massupdate] => ,[inline_edit] => ),[description] => Array ([name] => description,[vname] => LBL_DESCRIPTION,[type] => text,[comment] => Full text of the note,[rows] => 6,[cols] => 80),[deleted] => Array ([name] => deleted,[vname] => LBL_DELETED,[type] => bool,[default] => 0,[reportable] => ,[comment] => Record deletion indicator),[created_by_link] => Array ([name] => created_by_link,[type] => link,[relationship] => accounts_created_by,[vname] => LBL_CREATED_BY_USER,[link_type] => one,[module] => Users,[bean_name] => User,[source] => non-db),[modified_user_link] => Array ([name] => modified_user_link,[type] => link,[relationship] => accounts_modified_user,[vname] => LBL_MODIFIED_BY_USER,[link_type] => one,[module] => Users,[bean_name] => User,[source] => non-db),[assigned_user_id] => Array ([name] => assigned_user_id,[rname] => user_name,[id_name] => assigned_user_id,[vname] => LBL_ASSIGNED_TO_ID,[group] => assigned_user_name,[type] => relate,[table] => users,[module] => Users,[reportable] => 1,[isnull] => false,[dbType] => id,[audited] => 1,[comment] => User ID assigned to record,[duplicate_merge] => disabled),[assigned_user_name] => Array ([name] => assigned_user_name,[link] => assigned_user_link,[vname] => LBL_ASSIGNED_TO_NAME,[rname] => user_name,[type] => relate,[reportable] => ,[source] => non-db,[table] => users,[id_name] => assigned_user_id,[module] => Users,[duplicate_merge] => disabled),[assigned_user_link] => Array ([name] => assigned_user_link,[type] => link,[relationship] => accounts_assigned_user,[vname] => LBL_ASSIGNED_TO_USER,[link_type] => one,[module] => Users,[bean_name] => User,[source] => non-db,[duplicate_merge] => enabled,[rname] => user_name,[id_name] => assigned_user_id,[table] => users),[SecurityGroups] => Array ([name] => SecurityGroups,[type] => link,[relationship] => securitygroups_accounts,[module] => SecurityGroups,[bean_name] => SecurityGroup,[source] => non-db,[vname] => LBL_SECURITYGROUPS),[account_type] => Array ([name] => account_type,[vname] => LBL_TYPE,[type] => enum,[options] => account_type_dom,[len] => 50,[comment] => The Company is of this type),[industry] => Array ([name] => industry,[vname] => LBL_INDUSTRY,[type] => enum,[options] => industry_dom,[len] => 50,[comment] => The company belongs in this industry,[merge_filter] => enabled),[annual_revenue] => Array ([name] => annual_revenue,[vname] => LBL_ANNUAL_REVENUE,[type] => varchar,[len] => 100,[comment] => Annual revenue for this company,[merge_filter] => enabled),[phone_fax] => Array ([name] => phone_fax,[vname] => LBL_FAX,[type] => phone,[dbType] => varchar,[len] => 100,[unified_search] => 1,[full_text_search] => Array ([boost] => 1),[comment] => The fax phone number of this company),[billing_address_street] => Array ([name] => billing_address_street,[vname] => LBL_BILLING_ADDRESS_STREET,[type] => varchar,[len] => 150,[comment] => The street address used for billing address,[group] => billing_address,[merge_filter] => enabled),[billing_address_street_2] => Array ([name] => billing_address_street_2,[vname] => LBL_BILLING_ADDRESS_STREET_2,[type] => varchar,[len] => 150,[source] => non-db),[billing_address_street_3] => Array ([name] => billing_address_street_3,[vname] => LBL_BILLING_ADDRESS_STREET_3,[type] => varchar,[len] => 150,[source] => non-db),[billing_address_street_4] => Array ([name] => billing_address_street_4,[vname] => LBL_BILLING_ADDRESS_STREET_4,[type] => varchar,[len] => 150,[source] => non-db),[billing_address_city] => Array ([name] => billing_address_city,[vname] => LBL_BILLING_ADDRESS_CITY,[type] => varchar,[len] => 100,[comment] => The city used for billing address,[group] => billing_address,[merge_filter] => enabled),[billing_address_state] => Array ([name] => billing_address_state,[vname] => LBL_BILLING_ADDRESS_STATE,[type] => varchar,[len] => 100,[group] => billing_address,[comment] => The state used for billing address,[merge_filter] => enabled),[billing_address_postalcode] => Array ([name] => billing_address_postalcode,[vname] => LBL_BILLING_ADDRESS_POSTALCODE,[type] => varchar,[len] => 20,[group] => billing_address,[comment] => The postal code used for billing address,[merge_filter] => enabled),[billing_address_country] => Array ([name] => billing_address_country,[vname] => LBL_BILLING_ADDRESS_COUNTRY,[type] => varchar,[group] => billing_address,[comment] => The country used for the billing address,[merge_filter] => enabled),[rating] => Array ([name] => rating,[vname] => LBL_RATING,[type] => varchar,[len] => 100,[comment] => An arbitrary rating for this company for use in comparisons with others),[phone_office] => Array ([name] => phone_office,[vname] => LBL_PHONE_OFFICE,[type] => phone,[dbType] => varchar,[len] => 100,[audited] => 1,[unified_search] => 1,[full_text_search] => Array ([boost] => 1),[comment] => The office phone number,[merge_filter] => enabled),[phone_alternate] => Array ([name] => phone_alternate,[vname] => LBL_PHONE_ALT,[type] => phone,[group] => phone_office,[dbType] => varchar,[len] => 100,[unified_search] => 1,[full_text_search] => Array ([boost] => 1),[comment] => An alternate phone number,[merge_filter] => enabled),[website] => Array ([name] => website,[vname] => LBL_WEBSITE,[type] => url,[dbType] => varchar,[len] => 255,[comment] => URL of website for the company),[ownership] => Array ([name] => ownership,[vname] => LBL_OWNERSHIP,[type] => varchar,[len] => 100,[comment] => ),[employees] => Array ([name] => employees,[vname] => LBL_EMPLOYEES,[type] => varchar,[len] => 10,[comment] => Number of employees, varchar to accomodate for both number (100) or range (50-100)),[ticker_symbol] => Array ([name] => ticker_symbol,[vname] => LBL_TICKER_SYMBOL,[type] => varchar,[len] => 10,[comment] => The stock trading (ticker) symbol for the company,[merge_filter] => enabled),[shipping_address_street] => Array ([name] => shipping_address_street,[vname] => LBL_SHIPPING_ADDRESS_STREET,[type] => varchar,[len] => 150,[group] => shipping_address,[comment] => The street address used for for shipping purposes,[merge_filter] => enabled),[shipping_address_street_2] => Array ([name] => shipping_address_street_2,[vname] => LBL_SHIPPING_ADDRESS_STREET_2,[type] => varchar,[len] => 150,[source] => non-db),[shipping_address_street_3] => Array ([name] => shipping_address_street_3,[vname] => LBL_SHIPPING_ADDRESS_STREET_3,[type] => varchar,[len] => 150,[source] => non-db),[shipping_address_street_4] => Array ([name] => shipping_address_street_4,[vname] => LBL_SHIPPING_ADDRESS_STREET_4,[type] => varchar,[len] => 150,[source] => non-db),[shipping_address_city] => Array ([name] => shipping_address_city,[vname] => LBL_SHIPPING_ADDRESS_CITY,[type] => varchar,[len] => 100,[group] => shipping_address,[comment] => The city used for the shipping address,[merge_filter] => enabled),[shipping_address_state] => Array ([name] => shipping_address_state,[vname] => LBL_SHIPPING_ADDRESS_STATE,[type] => varchar,[len] => 100,[group] => shipping_address,[comment] => The state used for the shipping address,[merge_filter] => enabled),[shipping_address_postalcode] => Array ([name] => shipping_address_postalcode,[vname] => LBL_SHIPPING_ADDRESS_POSTALCODE,[type] => varchar,[len] => 20,[group] => shipping_address,[comment] => The zip code used for the shipping address,[merge_filter] => enabled),[shipping_address_country] => Array ([name] => shipping_address_country,[vname] => LBL_SHIPPING_ADDRESS_COUNTRY,[type] => varchar,[group] => shipping_address,[comment] => The country used for the shipping address,[merge_filter] => enabled),[email1] => Array ([name] => email1,[vname] => LBL_EMAIL,[group] => email1,[type] => varchar,[function] => Array ([name] => getEmailAddressWidget,[returns] => html),[source] => non-db,[studio] => Array ([editField] => 1,[searchview] => ),[full_text_search] => Array ([boost] => 3,[analyzer] => whitespace)),[email_addresses_primary] => Array ([name] => email_addresses_primary,[type] => link,[relationship] => accounts_email_addresses_primary,[source] => non-db,[vname] => LBL_EMAIL_ADDRESS_PRIMARY,[duplicate_merge] => disabled,[studio] => Array ([formula] => )),[email_addresses] => Array ([name] => email_addresses,[type] => link,[relationship] => accounts_email_addresses,[source] => non-db,[vname] => LBL_EMAIL_ADDRESSES,[reportable] => ,[unified_search] => 1,[rel_fields] => Array ([primary_address] => Array ([type] => bool)),[studio] => Array ([formula] => )),[email_addresses_non_primary] => Array ([name] => email_addresses_non_primary,[type] => email,[source] => non-db,[vname] => LBL_EMAIL_NON_PRIMARY,[studio] => ,[reportable] => ,[massupdate] => ),[parent_id] => Array ([name] => parent_id,[vname] => LBL_PARENT_ACCOUNT_ID,[type] => id,[required] => ,[reportable] => ,[audited] => 1,[comment] => Account ID of the parent of this account),[sic_code] => Array ([name] => sic_code,[vname] => LBL_SIC_CODE,[type] => varchar,[len] => 10,[comment] => SIC code of the account),[parent_name] => Array ([name] => parent_name,[rname] => name,[id_name] => parent_id,[vname] => LBL_MEMBER_OF,[type] => relate,[isnull] => true,[module] => Accounts,[table] => accounts,[massupdate] => ,[source] => non-db,[len] => 36,[link] => member_of,[unified_search] => 1,[importable] => true),[members] => Array ([name] => members,[type] => link,[relationship] => member_accounts,[module] => Accounts,[bean_name] => Account,[source] => non-db,[vname] => LBL_MEMBERS),[member_of] => Array ([name] => member_of,[type] => link,[relationship] => member_accounts,[module] => Accounts,[bean_name] => Account,[link_type] => one,[source] => non-db,[vname] => LBL_MEMBER_OF,[side] => right),[email_opt_out] => Array ([name] => email_opt_out,[vname] => LBL_EMAIL_OPT_OUT,[source] => non-db,[type] => bool,[massupdate] => ,[studio] => false),[invalid_email] => Array ([name] => invalid_email,[vname] => LBL_INVALID_EMAIL,[source] => non-db,[type] => bool,[massupdate] => ,[studio] => false),[cases] => Array ([name] => cases,[type] => link,[relationship] => account_cases,[module] => Cases,[bean_name] => aCase,[source] => non-db,[vname] => LBL_CASES),[email] => Array ([name] => email,[type] => email,[query_type] => default,[source] => non-db,[operator] => subquery,[subquery] => SELECT eabr.bean_id FROM email_addr_bean_rel eabr JOIN email_addresses ea ON (ea.id = eabr.email_address_id) WHERE eabr.deleted=0 AND ea.email_address LIKE,[db_field] => Array ([0] => id),[vname] => LBL_ANY_EMAIL,[studio] => Array ([visible] => ,[searchview] => 1),[importable] => ),[tasks] => Array ([name] => tasks,[type] => link,[relationship] => account_tasks,[module] => Tasks,[bean_name] => Task,[source] => non-db,[vname] => LBL_TASKS),[notes] => Array ([name] => notes,[type] => link,[relationship] => account_notes,[module] => Notes,[bean_name] => Note,[source] => non-db,[vname] => LBL_NOTES),[meetings] => Array ([name] => meetings,[type] => link,[relationship] => account_meetings,[module] => Meetings,[bean_name] => Meeting,[source] => non-db,[vname] => LBL_MEETINGS),[calls] => Array ([name] => calls,[type] => link,[relationship] => account_calls,[module] => Calls,[bean_name] => Call,[source] => non-db,[vname] => LBL_CALLS),[emails] => Array ([name] => emails,[type] => link,[relationship] => emails_accounts_rel,[module] => Emails,[bean_name] => Email,[source] => non-db,[vname] => LBL_EMAILS,[studio] => Array ([formula] => )),[documents] => Array ([name] => documents,[type] => link,[relationship] => documents_accounts,[source] => non-db,[vname] => LBL_DOCUMENTS_SUBPANEL_TITLE),[bugs] => Array ([name] => bugs,[type] => link,[relationship] => accounts_bugs,[module] => Bugs,[bean_name] => Bug,[source] => non-db,[vname] => LBL_BUGS),[contacts] => Array ([name] => contacts,[type] => link,[relationship] => accounts_contacts,[module] => Contacts,[bean_name] => Contact,[source] => non-db,[vname] => LBL_CONTACTS),[opportunities] => Array ([name] => opportunities,[type] => link,[relationship] => accounts_opportunities,[module] => Opportunities,[bean_name] => Opportunity,[source] => non-db,[vname] => LBL_OPPORTUNITY),[project] => Array ([name] => project,[type] => link,[relationship] => projects_accounts,[module] => Project,[bean_name] => Project,[source] => non-db,[vname] => LBL_PROJECTS),[leads] => Array ([name] => leads,[type] => link,[relationship] => account_leads,[module] => Leads,[bean_name] => Lead,[source] => non-db,[vname] => LBL_LEADS),[campaigns] => Array ([name] => campaigns,[type] => link,[relationship] => account_campaign_log,[module] => CampaignLog,[bean_name] => CampaignLog,[source] => non-db,[vname] => LBL_CAMPAIGNLOG,[studio] => Array ([formula] => )),[campaign_accounts] => Array ([name] => campaign_accounts,[type] => link,[vname] => LBL_CAMPAIGNS,[relationship] => campaign_accounts,[source] => non-db),[campaign_id] => Array ([name] => campaign_id,[comment] => Campaign that generated Account,[vname] => LBL_CAMPAIGN_ID,[rname] => id,[id_name] => campaign_id,[type] => id,[table] => campaigns,[isnull] => true,[module] => Campaigns,[reportable] => ,[massupdate] => ,[duplicate_merge] => disabled),[campaign_name] => Array ([name] => campaign_name,[rname] => name,[vname] => LBL_CAMPAIGN,[type] => relate,[reportable] => ,[source] => non-db,[table] => campaigns,[id_name] => campaign_id,[link] => campaign_accounts,[module] => Campaigns,[duplicate_merge] => disabled,[comment] => The first campaign name for Account (Meta-data only)),[prospect_lists] => Array ([name] => prospect_lists,[type] => link,[relationship] => prospect_list_accounts,[module] => ProspectLists,[source] => non-db,[vname] => LBL_PROSPECT_LIST),[aos_quotes] => Array ([name] => aos_quotes,[vname] => LBL_AOS_QUOTES,[type] => link,[relationship] => account_aos_quotes,[module] => AOS_Quotes,[bean_name] => AOS_Quotes,[source] => non-db),[aos_invoices] => Array ([name] => aos_invoices,[vname] => LBL_AOS_INVOICES,[type] => link,[relationship] => account_aos_invoices,[module] => AOS_Invoices,[bean_name] => AOS_Invoices,[source] => non-db),[aos_contracts] => Array ([name] => aos_contracts,[vname] => LBL_AOS_CONTRACTS,[type] => link,[relationship] => account_aos_contracts,[module] => AOS_Contracts,[bean_name] => AOS_Contracts,[source] => non-db),[jjwg_maps_address_c] => Array ([inline_edit] => 1,[required] => ,[source] => custom_fields,[name] => jjwg_maps_address_c,[vname] => LBL_JJWG_MAPS_ADDRESS,[type] => varchar,[massupdate] => 0,[default] => ,[no_default] => ,[comments] => Address,[help] => Address,[importable] => true,[duplicate_merge] => disabled,[duplicate_merge_dom_value] => 0,[audited] => ,[reportable] => 1,[unified_search] => ,[merge_filter] => disabled,[len] => 255,[size] => 20,[id] => Accountsjjwg_maps_address_c,[custom_module] => Accounts),[jjwg_maps_geocode_status_c] => Array ([inline_edit] => 1,[required] => ,[source] => custom_fields,[name] => jjwg_maps_geocode_status_c,[vname] => LBL_JJWG_MAPS_GEOCODE_STATUS,[type] => varchar,[massupdate] => 0,[default] => ,[no_default] => ,[comments] => Geocode Status,[help] => Geocode Status,[importable] => true,[duplicate_merge] => disabled,[duplicate_merge_dom_value] => 0,[audited] => ,[reportable] => 1,[unified_search] => ,[merge_filter] => disabled,[len] => 255,[size] => 20,[id] => Accountsjjwg_maps_geocode_status_c,[custom_module] => Accounts),[jjwg_maps_lat_c] => Array ([inline_edit] => 1,[required] => ,[source] => custom_fields,[name] => jjwg_maps_lat_c,[vname] => LBL_JJWG_MAPS_LAT,[type] => float,[massupdate] => 0,[default] => 0.00000000,[no_default] => ,[comments] => ,[help] => Latitude,[importable] => true,[duplicate_merge] => disabled,[duplicate_merge_dom_value] => 0,[audited] => ,[reportable] => 1,[unified_search] => ,[merge_filter] => disabled,[len] => 10,[size] => 20,[enable_range_search] => ,[precision] => 8,[id] => Accountsjjwg_maps_lat_c,[custom_module] => Accounts),[jjwg_maps_lng_c] => Array ([inline_edit] => 1,[required] => ,[source] => custom_fields,[name] => jjwg_maps_lng_c,[vname] => LBL_JJWG_MAPS_LNG,[type] => float,[massupdate] => 0,[default] => 0.00000000,[no_default] => ,[comments] => ,[help] => Longitude,[importable] => true,[duplicate_merge] => disabled,[duplicate_merge_dom_value] => 0,[audited] => ,[reportable] => 1,[unified_search] => ,[merge_filter] => disabled,[len] => 11,[size] => 20,[enable_range_search] => ,[precision] => 8,[id] => Accountsjjwg_maps_lng_c,[custom_module] => Accounts)),[date_entered] => ,[date_modified] => ,[modified_user_id] => ,[assigned_user_id] => ,[annual_revenue] => ,[billing_address_street] => ,[billing_address_city] => ,[billing_address_state] => ,[billing_address_country] => ,[billing_address_postalcode] => ,[billing_address_street_2] => ,[billing_address_street_3] => ,[billing_address_street_4] => ,[description] => ,[email1] => ,[email2] => ,[email_opt_out] => ,[invalid_email] => ,[employees] => ,[id] => ,[industry] => ,[name] => ,[ownership] => ,[parent_id] => ,[phone_alternate] => ,[phone_fax] => ,[phone_office] => ,[rating] => ,[shipping_address_street] => ,[shipping_address_city] => ,[shipping_address_state] => ,[shipping_address_country] => ,[shipping_address_postalcode] => ,[shipping_address_street_2] => ,[shipping_address_street_3] => ,[shipping_address_street_4] => ,[campaign_id] => ,[sic_code] => ,[ticker_symbol] => ,[account_type] => ,[website] => ,[custom_fields] => DynamicField Object ([use_existing_labels] => ,[base_path] => custom/Extension/modules/Accounts/Ext/Vardefs,[db] => SqlsrvManager Object ([dbName] => SQL Server,[variant] => sqlsrv,[priority] => 10,[label] => LBL_MSSQL_SQLSRV,[] => Array ([affected_rows] => 1,[fulltext] => 1,[limit_subquery] => 1,[create_user] => 1,[create_db] => 1),[] => Array ([int] => int,[double] => float,[float] => float,[uint] => int,[ulong] => int,[long] => bigint,[short] => smallint,[varchar] => nvarchar,[text] => nvarchar(max),[longtext] => nvarchar(max),[date] => datetime,[enum] => nvarchar,[relate] => nvarchar,[multienum] => nvarchar(max),[html] => nvarchar(max),[longhtml] => nvarchar(max),[datetime] => datetime,[datetimecombo] => datetime,[time] => datetime,[bool] => bit,[tinyint] => tinyint,[char] => char,[blob] => nvarchar(max),[longblob] => nvarchar(max),[currency] => decimal(26,6),[decimal] => decimal,[decimal2] => decimal,[id] => varchar(36),[url] => nvarchar,[encrypt] => nvarchar,[file] => nvarchar,[decimal_tpl] => decimal(%d, %d)),[dbType] => mssql,[] => Array ([table] => 128,[column] => 128,[index] => 128,[alias] => 128),[] => Array ([db_host_name] => DESKTOP-9H6S3G4,[db_host_instance] => ,[db_user_name] => sa,[db_password] => Securitywhm01,[db_name] => suitecrmprod,[db_type] => mssql,[db_port] => ,[db_manager] => SqlsrvManager),[] => Array ([%Y-%m-%d] => 10,[%Y-%m] => 7,[%Y] => 4),[database] => Resource id #6,[] => ,[] => 1,[] => 0.0021419525146484,[] => ,[] => ,[] => Array (),[] => TimeDate Object ([dbDayFormat] => Y-m-d,[dbTimeFormat] => H:i:s,[] => SugarDateTime Object ([] => Array ([sec] => s,[min] => i,[hour] => G,[zhour] => H,[day] => j,[zday] => d,[days_in_month] => t,[day_of_week] => w,[day_of_year] => z,[week] => W,[month] => n,[zmonth] => m,[year] => Y,[am_pm] => A,[hour_12] => g),[] => Array ([24_hour] => hour,[day_of_week] => day_of_week_long,[day_of_week_short] => day_of_week_short,[month_name] => month_long,[hour] => hour_12),[] => ,[date] => 2017-09-15 08:46:28.000000,[timezone_type] => 3,[timezone] => UTC),[] => ,[] => 1,[] => DateTimeZone Object ([timezone_type] => 3,[timezone] => Africa/Johannesburg),[] => ,[] => ,[allow_cache] => 1,[] => Array ([yesterday] => Array ([0] => -1 day,[1] => -1 day),[today] => Array ([0] => ,[1] => ),[tomorrow] => Array ([0] => +1 day,[1] => +1 day),[last_7_days] => Array ([0] => -6 days,[1] => ),[next_7_days] => Array ([0] => ,[1] => +6 days),[last_30_days] => Array ([0] => -29 days,[1] => ),[next_30_days] => Array ([0] => ,[1] => +29 days))),[] => LoggerManager Object ([] => fatal),[] => Array ([int] => int,[double] => float,[float] => float,[uint] => int,[ulong] => bigint,[long] => bigint,[short] => int,[date] => date,[datetime] => date,[datetimecombo] => date,[time] => time,[bool] => bool,[tinyint] => int,[currency] => float,[decimal] => float,[decimal2] => float),[] => Array ([persistent] => 1,[autofree] => ,[debug] => 0,[ssl] => ),[] => Array ([ALTER TABLE] => verifyAlterTable,[DROP TABLE] => verifyDropTable,[CREATE TABLE] => verifyCreateTable,[INSERT INTO] => verifyInsertInto,[UPDATE] => verifyUpdate,[DELETE FROM] => verifyDeleteFrom),[helper] => SqlsrvManager Object ( *RECURSION*,[count_id] => 1,[references] => 34,[lastsql] => SELECT accounts.*,accounts_cstm.* FROM accounts LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c WHERE accounts.id = '' AND accounts.deleted=0),[bean] => Account Object ( *RECURSION*,[module] => Accounts),[created_by] => ,[created_by_name] => ,[modified_by_name] => ,[opportunity_id] => ,[case_id] => ,[contact_id] => ,[task_id] => ,[note_id] => ,[meeting_id] => ,[call_id] => ,[email_id] => ,[member_id] => ,[parent_name] => ,[assigned_user_name] => ,[account_id] => ,[account_name] => ,[bug_id] => ,[module_dir] => Accounts,[emailAddress] => SugarEmailAddress Object ([table_name] => email_addresses,[module_name] => EmailAddresses,[module_dir] => EmailAddresses,[object_name] => EmailAddress,[regex] => /^(?:['\.\-\+&#!$\*=\?\^_`\{\}~\/\w]+)@(?:(?:\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3})|\w+(?:[\.-]*\w+)*(?:\.[\w-]{2,})+)$/,[disable_custom_fields] => 1,[db] => SqlsrvManager Object ([dbName] => SQL Server,[variant] => sqlsrv,[priority] => 10,[label] => LBL_MSSQL_SQLSRV,[] => Array ([affected_rows] => 1,[fulltext] => 1,[limit_subquery] => 1,[create_user] => 1,[create_db] => 1),[] => Array ([int] => int,[double] => float,[float] => float,[uint] => int,[ulong] => int,[long] => bigint,[short] => smallint,[varchar] => nvarchar,[text] => nvarchar(max),[longtext] => nvarchar(max),[date] => datetime,[enum] => nvarchar,[relate] => nvarchar,[multienum] => nvarchar(max),[html] => nvarchar(max),[longhtml] => nvarchar(max),[datetime] => datetime,[datetimecombo] => datetime,[time] => datetime,[bool] => bit,[tinyint] => tinyint,[char] => char,[blob] => nvarchar(max),[longblob] => nvarchar(max),[currency] => decimal(26,6),[decimal] => decimal,[decimal2] => decimal,[id] => varchar(36),[url] => nvarchar,[encrypt] => nvarchar,[file] => nvarchar,[decimal_tpl] => decimal(%d, %d)),[dbType] => mssql,[] => Array ([table] => 128,[column] => 128,[index] => 128,[alias] => 128),[] => Array ([db_host_name] => DESKTOP-9H6S3G4,[db_host_instance] => ,[db_user_name] => sa,[db_password] => Securitywhm01,[db_name] => suitecrmprod,[db_type] => mssql,[db_port] => ,[db_manager] => SqlsrvManager),[] => Array ([%Y-%m-%d] => 10,[%Y-%m] => 7,[%Y] => 4),[database] => Resource id #6,[] => ,[] => 1,[] => 0.0021419525146484,[] => ,[] => ,[] => Array (),[] => TimeDate Object ([dbDayFormat] => Y-m-d,[dbTimeFormat] => H:i:s,[] => SugarDateTime Object ([] => Array ([sec] => s,[min] => i,[hour] => G,[zhour] => H,[day] => j,[zday] => d,[days_in_month] => t,[day_of_week] => w,[day_of_year] => z,[week] => W,[month] => n,[zmonth] => m,[year] => Y,[am_pm] => A,[hour_12] => g),[] => Array ([24_hour] => hour,[day_of_week] => day_of_week_long,[day_of_week_short] => day_of_week_short,[month_name] => month_long,[hour] => hour_12),[] => ,[date] => 2017-09-15 08:46:28.000000,[timezone_type] => 3,[timezone] => UTC),[] => ,[] => 1,[] => DateTimeZone Object ([timezone_type] => 3,[timezone] => Africa/Johannesburg),[] => ,[] => ,[allow_cache] => 1,[] => Array ([yesterday] => Array ([0] => -1 day,[1] => -1 day),[today] => Array ([0] => ,[1] => ),[tomorrow] => Array ([0] => +1 day,[1] => +1 day),[last_7_days] => Array ([0] => -6 days,[1] => ),[next_7_days] => Array ([0] => ,[1] => +6 days),[last_30_days] => Array ([0] => -29 days,[1] => ),[next_30_days] => Array ([0] => ,[1] => +29 days))),[] => LoggerManager Object ([] => fatal),[] => Array ([int] => int,[double] => float,[float] => float,[uint] => int,[ulong] => bigint,[long] => bigint,[short] => int,[date] => date,[datetime] => date,[datetimecombo] => date,[time] => time,[bool] => bool,[tinyint] => int,[currency] => float,[decimal] => float,[decimal2] => float),[] => Array ([persistent] => 1,[autofree] => ,[debug] => 0,[ssl] => ),[] => Array ([ALTER TABLE] => verifyAlterTable,[DROP TABLE] => verifyDropTable,[CREATE TABLE] => verifyCreateTable,[INSERT INTO] => verifyInsertInto,[UPDATE] => verifyUpdate,[DELETE FROM] => verifyDeleteFrom),[helper] => SqlsrvManager Object ( *RECURSION*,[count_id] => 1,[references] => 34,[lastsql] => SELECT accounts.*,accounts_cstm.* FROM accounts LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c WHERE accounts.id = '' AND accounts.deleted=0),[smarty] => ,[addresses] => Array (),[view] => ,[] => ,[email_address] => ,[id] => ,[new_with_id] => ,[disable_vardefs] => ,[new_assigned_user_name] => ,[processed_dates_times] => Array (),[process_save_dates] => 1,[save_from_post] => 1,[duplicates_found] => ,[deleted] => 0,[update_date_modified] => 1,[update_modified_by] => 1,[update_date_entered] => ,[set_created_by] => 1,[ungreedy_count] => ,[field_name_map] => Array ([id] => Array ([name] => id,[type] => id,[vname] => LBL_EMAIL_ADDRESS_ID,[required] => 1),[email_address] => Array ([name] => email_address,[type] => varchar,[vname] => LBL_EMAIL_ADDRESS,[length] => 100,[required] => 1),[email_address_caps] => Array ([name] => email_address_caps,[type] => varchar,[vname] => LBL_EMAIL_ADDRESS_CAPS,[length] => 100,[required] => 1,[reportable] => ),[invalid_email] => Array ([name] => invalid_email,[type] => bool,[default] => 0,[vname] => LBL_INVALID_EMAIL),[opt_out] => Array ([name] => opt_out,[type] => bool,[default] => 0,[vname] => LBL_OPT_OUT),[date_created] => Array ([name] => date_created,[type] => datetime,[vname] => LBL_DATE_CREATE),[date_modified] => Array ([name] => date_modified,[type] => datetime,[vname] => LBL_DATE_MODIFIED),[deleted] => Array ([name] => deleted,[type] => bool,[default] => 0,[vname] => LBL_DELETED)),[field_defs] => Array ([id] => Array ([name] => id,[type] => id,[vname] => LBL_EMAIL_ADDRESS_ID,[required] => 1),[email_address] => Array ([name] => email_address,[type] => varchar,[vname] => LBL_EMAIL_ADDRESS,[length] => 100,[required] => 1),[email_address_caps] => Array ([name] => email_address_caps,[type] => varchar,[vname] => LBL_EMAIL_ADDRESS_CAPS,[length] => 100,[required] => 1,[reportable] => ),[invalid_email] => Array ([name] => invalid_email,[type] => bool,[default] => 0,[vname] => LBL_INVALID_EMAIL),[opt_out] => Array ([name] => opt_out,[type] => bool,[default] => 0,[vname] => LBL_OPT_OUT),[date_created] => Array ([name] => date_created,[type] => datetime,[vname] => LBL_DATE_CREATE),[date_modified] => Array ([name] => date_modified,[type] => datetime,[vname] => LBL_DATE_MODIFIED),[deleted] => Array ([name] => deleted,[type] => bool,[default] => 0,[vname] => LBL_DELETED)),[custom_fields] => ,[column_fields] => Array ([0] => id,[1] => email_address,[2] => email_address_caps,[3] => invalid_email,[4] => opt_out,[5] => date_created,[6] => date_modified,[7] => deleted),[list_fields] => Array (),[additional_column_fields] => Array (),[relationship_fields] => Array (),[current_notify_user] => ,[fetched_row] => ,[fetched_rel_row] => Array (),[layout_def] => ,[force_load_details] => ,[optimistic_lock] => ,[number_formatting_done] => ,[process_field_encrypted] => ,[acltype] => module,[additional_meta_fields] => Array (),[notify_inworkflow] => ,[name] => ,[description] => ,[date_entered] => ,[date_modified] => ,[modified_user_id] => ,[assigned_user_id] => ,[created_by] => ,[created_by_name] => ,[modified_by_name] => ,[importable] => ,[special_notification] => ,[in_workflow] => ,[tracker_visibility] => 1,[listview_inner_join] => Array (),[in_import] => ,[in_save] => ,[logicHookDepth] => ,[] => 10,[] => Array (),[] => ,[required_fields] => Array ([id] => 1,[email_address] => 1,[email_address_caps] => 1),[added_custom_field_defs] => 1,[invalid_email] => 0,[opt_out] => 0,[index] => 4),[table_name] => accounts,[object_name] => Account,[importable] => 1,[new_schema] => 1,[additional_column_fields] => Array ([0] => assigned_user_name,[1] => assigned_user_id,[2] => opportunity_id,[3] => bug_id,[4] => case_id,[5] => contact_id,[6] => task_id,[7] => note_id,[8] => meeting_id,[9] => call_id,[10] => email_id,[11] => parent_name,[12] => member_id),[relationship_fields] => Array ([opportunity_id] => opportunities,[bug_id] => bugs,[case_id] => cases,[contact_id] => contacts,[task_id] => tasks,[note_id] => notes,[meeting_id] => meetings,[call_id] => calls,[email_id] => emails,[member_id] => members,[project_id] => project),[push_billing] => ,[push_shipping] => ,[db] => SqlsrvManager Object ([dbName] => SQL Server,[variant] => sqlsrv,[priority] => 10,[label] => LBL_MSSQL_SQLSRV,[] => Array ([affected_rows] => 1,[fulltext] => 1,[limit_subquery] => 1,[create_user] => 1,[create_db] => 1),[] => Array ([int] => int,[double] => float,[float] => float,[uint] => int,[ulong] => int,[long] => bigint,[short] => smallint,[varchar] => nvarchar,[text] => nvarchar(max),[longtext] => nvarchar(max),[date] => datetime,[enum] => nvarchar,[relate] => nvarchar,[multienum] => nvarchar(max),[html] => nvarchar(max),[longhtml] => nvarchar(max),[datetime] => datetime,[datetimecombo] => datetime,[time] => datetime,[bool] => bit,[tinyint] => tinyint,[char] => char,[blob] => nvarchar(max),[longblob] => nvarchar(max),[currency] => decimal(26,6),[decimal] => decimal,[decimal2] => decimal,[id] => varchar(36),[url] => nvarchar,[encrypt] => nvarchar,[file] => nvarchar,[decimal_tpl] => decimal(%d, %d)),[dbType] => mssql,[] => Array ([table] => 128,[column] => 128,[index] => 128,[alias] => 128),[] => Array ([db_host_name] => DESKTOP-9H6S3G4,[db_host_instance] => ,[db_user_name] => sa,[db_password] => Securitywhm01,[db_name] => suitecrmprod,[db_type] => mssql,[db_port] => ,[db_manager] => SqlsrvManager),[] => Array ([%Y-%m-%d] => 10,[%Y-%m] => 7,[%Y] => 4),[database] => Resource id #6,[] => ,[] => 1,[] => 0.0021419525146484,[] => ,[] => ,[] => Array (),[] => TimeDate Object ([dbDayFormat] => Y-m-d,[dbTimeFormat] => H:i:s,[] => SugarDateTime Object ([] => Array ([sec] => s,[min] => i,[hour] => G,[zhour] => H,[day] => j,[zday] => d,[days_in_month] => t,[day_of_week] => w,[day_of_year] => z,[week] => W,[month] => n,[zmonth] => m,[year] => Y,[am_pm] => A,[hour_12] => g),[] => Array ([24_hour] => hour,[day_of_week] => day_of_week_long,[day_of_week_short] => day_of_week_short,[month_name] => month_long,[hour] => hour_12),[] => ,[date] => 2017-09-15 08:46:28.000000,[timezone_type] => 3,[timezone] => UTC),[] => ,[] => 1,[] => DateTimeZone Object ([timezone_type] => 3,[timezone] => Africa/Johannesburg),[] => ,[] => ,[allow_cache] => 1,[] => Array ([yesterday] => Array ([0] => -1 day,[1] => -1 day),[today] => Array ([0] => ,[1] => ),[tomorrow] => Array ([0] => +1 day,[1] => +1 day),[last_7_days] => Array ([0] => -6 days,[1] => ),[next_7_days] => Array ([0] => ,[1] => +6 days),[last_30_days] => Array ([0] => -29 days,[1] => ),[next_30_days] => Array ([0] => ,[1] => +29 days))),[] => LoggerManager Object ([] => fatal),[] => Array ([int] => int,[double] => float,[float] => float,[uint] => int,[ulong] => bigint,[long] => bigint,[short] => int,[date] => date,[datetime] => date,[datetimecombo] => date,[time] => time,[bool] => bool,[tinyint] => int,[currency] => float,[decimal] => float,[decimal2] => float),[] => Array ([persistent] => 1,[autofree] => ,[debug] => 0,[ssl] => ),[] => Array ([ALTER TABLE] => verifyAlterTable,[DROP TABLE] => verifyDropTable,[CREATE TABLE] => verifyCreateTable,[INSERT INTO] => verifyInsertInto,[UPDATE] => verifyUpdate,[DELETE FROM] => verifyDeleteFrom),[helper] => SqlsrvManager Object ( *RECURSION*,[count_id] => 1,[references] => 34,[lastsql] => SELECT accounts.*,accounts_cstm.* FROM accounts LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c WHERE accounts.id = '' AND accounts.deleted=0),[new_with_id] => ,[disable_vardefs] => ,[new_assigned_user_name] => ,[processed_dates_times] => Array (),[process_save_dates] => 1,[save_from_post] => 1,[duplicates_found] => ,[deleted] => 0,[update_date_modified] => 1,[update_modified_by] => 1,[update_date_entered] => ,[set_created_by] => 1,[ungreedy_count] => ,[module_name] => Accounts,[field_defs] => Array ([id] => Array ([name] => id,[vname] => LBL_ID,[type] => id,[required] => 1,[reportable] => 1,[comment] => Unique identifier,[inline_edit] => ),[name] => Array ([name] => name,[type] => name,[dbType] => varchar,[vname] => LBL_NAME,[len] => 150,[comment] => Name of the Company,[unified_search] => 1,[full_text_search] => Array ([boost] => 3),[audited] => 1,[required] => 1,[importable] => required,[merge_filter] => selected),[date_entered] => Array ([name] => date_entered,[vname] => LBL_DATE_ENTERED,[type] => datetime,[group] => created_by_name,[comment] => Date record created,[enable_range_search] => 1,[options] => date_range_search_dom,[inline_edit] => ),[date_modified] => Array ([name] => date_modified,[vname] => LBL_DATE_MODIFIED,[type] => datetime,[group] => modified_by_name,[comment] => Date record last modified,[enable_range_search] => 1,[options] => date_range_search_dom,[inline_edit] => ),[modified_user_id] => Array ([name] => modified_user_id,[rname] => user_name,[id_name] => modified_user_id,[vname] => LBL_MODIFIED,[type] => assigned_user_name,[table] => users,[isnull] => false,[group] => modified_by_name,[dbType] => id,[reportable] => 1,[comment] => User who last modified record,[massupdate] => ,[inline_edit] => ),[modified_by_name] => Array ([name] => modified_by_name,[vname] => LBL_MODIFIED_NAME,[type] => relate,[reportable] => ,[source] => non-db,[rname] => user_name,[table] => users,[id_name] => modified_user_id,[module] => Users,[link] => modified_user_link,[duplicate_merge] => disabled,[massupdate] => ,[inline_edit] => ),[created_by] => Array ([name] => created_by,[rname] => user_name,[id_name] => modified_user_id,[vname] => LBL_CREATED,[type] => assigned_user_name,[table] => users,[isnull] => false,[dbType] => id,[group] => created_by_name,[comment] => User who created record,[massupdate] => ,[inline_edit] => ),[created_by_name] => Array ([name] => created_by_name,[vname] => LBL_CREATED,[type] => relate,[reportable] => ,[link] => created_by_link,[rname] => user_name,[source] => non-db,[table] => users,[id_name] => created_by,[module] => Users,[duplicate_merge] => disabled,[importable] => false,[massupdate] => ,[inline_edit] => ),[description] => Array ([name] => description,[vname] => LBL_DESCRIPTION,[type] => text,[comment] => Full text of the note,[rows] => 6,[cols] => 80),[deleted] => Array ([name] => deleted,[vname] => LBL_DELETED,[type] => bool,[default] => 0,[reportable] => ,[comment] => Record deletion indicator),[created_by_link] => Array ([name] => created_by_link,[type] => link,[relationship] => accounts_created_by,[vname] => LBL_CREATED_BY_USER,[link_type] => one,[module] => Users,[bean_name] => User,[source] => non-db),[modified_user_link] => Array ([name] => modified_user_link,[type] => link,[relationship] => accounts_modified_user,[vname] => LBL_MODIFIED_BY_USER,[link_type] => one,[module] => Users,[bean_name] => User,[source] => non-db),[assigned_user_id] => Array ([name] => assigned_user_id,[rname] => user_name,[id_name] => assigned_user_id,[vname] => LBL_ASSIGNED_TO_ID,[group] => assigned_user_name,[type] => relate,[table] => users,[module] => Users,[reportable] => 1,[isnull] => false,[dbType] => id,[audited] => 1,[comment] => User ID assigned to record,[duplicate_merge] => disabled),[assigned_user_name] => Array ([name] => assigned_user_name,[link] => assigned_user_link,[vname] => LBL_ASSIGNED_TO_NAME,[rname] => user_name,[type] => relate,[reportable] => ,[source] => non-db,[table] => users,[id_name] => assigned_user_id,[module] => Users,[duplicate_merge] => disabled),[assigned_user_link] => Array ([name] => assigned_user_link,[type] => link,[relationship] => accounts_assigned_user,[vname] => LBL_ASSIGNED_TO_USER,[link_type] => one,[module] => Users,[bean_name] => User,[source] => non-db,[duplicate_merge] => enabled,[rname] => user_name,[id_name] => assigned_user_id,[table] => users),[SecurityGroups] => Array ([name] => SecurityGroups,[type] => link,[relationship] => securitygroups_accounts,[module] => SecurityGroups,[bean_name] => SecurityGroup,[source] => non-db,[vname] => LBL_SECURITYGROUPS),[account_type] => Array ([name] => account_type,[vname] => LBL_TYPE,[type] => enum,[options] => account_type_dom,[len] => 50,[comment] => The Company is of this type),[industry] => Array ([name] => industry,[vname] => LBL_INDUSTRY,[type] => enum,[options] => industry_dom,[len] => 50,[comment] => The company belongs in this industry,[merge_filter] => enabled),[annual_revenue] => Array ([name] => annual_revenue,[vname] => LBL_ANNUAL_REVENUE,[type] => varchar,[len] => 100,[comment] => Annual revenue for this company,[merge_filter] => enabled),[phone_fax] => Array ([name] => phone_fax,[vname] => LBL_FAX,[type] => phone,[dbType] => varchar,[len] => 100,[unified_search] => 1,[full_text_search] => Array ([boost] => 1),[comment] => The fax phone number of this company),[billing_address_street] => Array ([name] => billing_address_street,[vname] => LBL_BILLING_ADDRESS_STREET,[type] => varchar,[len] => 150,[comment] => The street address used for billing address,[group] => billing_address,[merge_filter] => enabled),[billing_address_street_2] => Array ([name] => billing_address_street_2,[vname] => LBL_BILLING_ADDRESS_STREET_2,[type] => varchar,[len] => 150,[source] => non-db),[billing_address_street_3] => Array ([name] => billing_address_street_3,[vname] => LBL_BILLING_ADDRESS_STREET_3,[type] => varchar,[len] => 150,[source] => non-db),[billing_address_street_4] => Array ([name] => billing_address_street_4,[vname] => LBL_BILLING_ADDRESS_STREET_4,[type] => varchar,[len] => 150,[source] => non-db),[billing_address_city] => Array ([name] => billing_address_city,[vname] => LBL_BILLING_ADDRESS_CITY,[type] => varchar,[len] => 100,[comment] => The city used for billing address,[group] => billing_address,[merge_filter] => enabled),[billing_address_state] => Array ([name] => billing_address_state,[vname] => LBL_BILLING_ADDRESS_STATE,[type] => varchar,[len] => 100,[group] => billing_address,[comment] => The state used for billing address,[merge_filter] => enabled),[billing_address_postalcode] => Array ([name] => billing_address_postalcode,[vname] => LBL_BILLING_ADDRESS_POSTALCODE,[type] => varchar,[len] => 20,[group] => billing_address,[comment] => The postal code used for billing address,[merge_filter] => enabled),[billing_address_country] => Array ([name] => billing_address_country,[vname] => LBL_BILLING_ADDRESS_COUNTRY,[type] => varchar,[group] => billing_address,[comment] => The country used for the billing address,[merge_filter] => enabled),[rating] => Array ([name] => rating,[vname] => LBL_RATING,[type] => varchar,[len] => 100,[comment] => An arbitrary rating for this company for use in comparisons with others),[phone_office] => Array ([name] => phone_office,[vname] => LBL_PHONE_OFFICE,[type] => phone,[dbType] => varchar,[len] => 100,[audited] => 1,[unified_search] => 1,[full_text_search] => Array ([boost] => 1),[comment] => The office phone number,[merge_filter] => enabled),[phone_alternate] => Array ([name] => phone_alternate,[vname] => LBL_PHONE_ALT,[type] => phone,[group] => phone_office,[dbType] => varchar,[len] => 100,[unified_search] => 1,[full_text_search] => Array ([boost] => 1),[comment] => An alternate phone number,[merge_filter] => enabled),[website] => Array ([name] => website,[vname] => LBL_WEBSITE,[type] => url,[dbType] => varchar,[len] => 255,[comment] => URL of website for the company),[ownership] => Array ([name] => ownership,[vname] => LBL_OWNERSHIP,[type] => varchar,[len] => 100,[comment] => ),[employees] => Array ([name] => employees,[vname] => LBL_EMPLOYEES,[type] => varchar,[len] => 10,[comment] => Number of employees, varchar to accomodate for both number (100) or range (50-100)),[ticker_symbol] => Array ([name] => ticker_symbol,[vname] => LBL_TICKER_SYMBOL,[type] => varchar,[len] => 10,[comment] => The stock trading (ticker) symbol for the company,[merge_filter] => enabled),[shipping_address_street] => Array ([name] => shipping_address_street,[vname] => LBL_SHIPPING_ADDRESS_STREET,[type] => varchar,[len] => 150,[group] => shipping_address,[comment] => The street address used for for shipping purposes,[merge_filter] => enabled),[shipping_address_street_2] => Array ([name] => shipping_address_street_2,[vname] => LBL_SHIPPING_ADDRESS_STREET_2,[type] => varchar,[len] => 150,[source] => non-db),[shipping_address_street_3] => Array ([name] => shipping_address_street_3,[vname] => LBL_SHIPPING_ADDRESS_STREET_3,[type] => varchar,[len] => 150,[source] => non-db),[shipping_address_street_4] => Array ([name] => shipping_address_street_4,[vname] => LBL_SHIPPING_ADDRESS_STREET_4,[type] => varchar,[len] => 150,[source] => non-db),[shipping_address_city] => Array ([name] => shipping_address_city,[vname] => LBL_SHIPPING_ADDRESS_CITY,[type] => varchar,[len] => 100,[group] => shipping_address,[comment] => The city used for the shipping address,[merge_filter] => enabled),[shipping_address_state] => Array ([name] => shipping_address_state,[vname] => LBL_SHIPPING_ADDRESS_STATE,[type] => varchar,[len] => 100,[group] => shipping_address,[comment] => The state used for the shipping address,[merge_filter] => enabled),[shipping_address_postalcode] => Array ([name] => shipping_address_postalcode,[vname] => LBL_SHIPPING_ADDRESS_POSTALCODE,[type] => varchar,[len] => 20,[group] => shipping_address,[comment] => The zip code used for the shipping address,[merge_filter] => enabled),[shipping_address_country] => Array ([name] => shipping_address_country,[vname] => LBL_SHIPPING_ADDRESS_COUNTRY,[type] => varchar,[group] => shipping_address,[comment] => The country used for the shipping address,[merge_filter] => enabled),[email1] => Array ([name] => email1,[vname] => LBL_EMAIL,[group] => email1,[type] => varchar,[function] => Array ([name] => getEmailAddressWidget,[returns] => html),[source] => non-db,[studio] => Array ([editField] => 1,[searchview] => ),[full_text_search] => Array ([boost] => 3,[analyzer] => whitespace)),[email_addresses_primary] => Array ([name] => email_addresses_primary,[type] => link,[relationship] => accounts_email_addresses_primary,[source] => non-db,[vname] => LBL_EMAIL_ADDRESS_PRIMARY,[duplicate_merge] => disabled,[studio] => Array ([formula] => )),[email_addresses] => Array ([name] => email_addresses,[type] => link,[relationship] => accounts_email_addresses,[source] => non-db,[vname] => LBL_EMAIL_ADDRESSES,[reportable] => ,[unified_search] => 1,[rel_fields] => Array ([primary_address] => Array ([type] => bool)),[studio] => Array ([formula] => )),[email_addresses_non_primary] => Array ([name] => email_addresses_non_primary,[type] => email,[source] => non-db,[vname] => LBL_EMAIL_NON_PRIMARY,[studio] => ,[reportable] => ,[massupdate] => ),[parent_id] => Array ([name] => parent_id,[vname] => LBL_PARENT_ACCOUNT_ID,[type] => id,[required] => ,[reportable] => ,[audited] => 1,[comment] => Account ID of the parent of this account),[sic_code] => Array ([name] => sic_code,[vname] => LBL_SIC_CODE,[type] => varchar,[len] => 10,[comment] => SIC code of the account),[parent_name] => Array ([name] => parent_name,[rname] => name,[id_name] => parent_id,[vname] => LBL_MEMBER_OF,[type] => relate,[isnull] => true,[module] => Accounts,[table] => accounts,[massupdate] => ,[source] => non-db,[len] => 36,[link] => member_of,[unified_search] => 1,[importable] => true),[members] => Array ([name] => members,[type] => link,[relationship] => member_accounts,[module] => Accounts,[bean_name] => Account,[source] => non-db,[vname] => LBL_MEMBERS),[member_of] => Array ([name] => member_of,[type] => link,[relationship] => member_accounts,[module] => Accounts,[bean_name] => Account,[link_type] => one,[source] => non-db,[vname] => LBL_MEMBER_OF,[side] => right),[email_opt_out] => Array ([name] => email_opt_out,[vname] => LBL_EMAIL_OPT_OUT,[source] => non-db,[type] => bool,[massupdate] => ,[studio] => false),[invalid_email] => Array ([name] => invalid_email,[vname] => LBL_INVALID_EMAIL,[source] => non-db,[type] => bool,[massupdate] => ,[studio] => false),[cases] => Array ([name] => cases,[type] => link,[relationship] => account_cases,[module] => Cases,[bean_name] => aCase,[source] => non-db,[vname] => LBL_CASES),[email] => Array ([name] => email,[type] => email,[query_type] => default,[source] => non-db,[operator] => subquery,[subquery] => SELECT eabr.bean_id FROM email_addr_bean_rel eabr JOIN email_addresses ea ON (ea.id = eabr.email_address_id) WHERE eabr.deleted=0 AND ea.email_address LIKE,[db_field] => Array ([0] => id),[vname] => LBL_ANY_EMAIL,[studio] => Array ([visible] => ,[searchview] => 1),[importable] => ),[tasks] => Array ([name] => tasks,[type] => link,[relationship] => account_tasks,[module] => Tasks,[bean_name] => Task,[source] => non-db,[vname] => LBL_TASKS),[notes] => Array ([name] => notes,[type] => link,[relationship] => account_notes,[module] => Notes,[bean_name] => Note,[source] => non-db,[vname] => LBL_NOTES),[meetings] => Array ([name] => meetings,[type] => link,[relationship] => account_meetings,[module] => Meetings,[bean_name] => Meeting,[source] => non-db,[vname] => LBL_MEETINGS),[calls] => Array ([name] => calls,[type] => link,[relationship] => account_calls,[module] => Calls,[bean_name] => Call,[source] => non-db,[vname] => LBL_CALLS),[emails] => Array ([name] => emails,[type] => link,[relationship] => emails_accounts_rel,[module] => Emails,[bean_name] => Email,[source] => non-db,[vname] => LBL_EMAILS,[studio] => Array ([formula] => )),[documents] => Array ([name] => documents,[type] => link,[relationship] => documents_accounts,[source] => non-db,[vname] => LBL_DOCUMENTS_SUBPANEL_TITLE),[bugs] => Array ([name] => bugs,[type] => link,[relationship] => accounts_bugs,[module] => Bugs,[bean_name] => Bug,[source] => non-db,[vname] => LBL_BUGS),[contacts] => Array ([name] => contacts,[type] => link,[relationship] => accounts_contacts,[module] => Contacts,[bean_name] => Contact,[source] => non-db,[vname] => LBL_CONTACTS),[opportunities] => Array ([name] => opportunities,[type] => link,[relationship] => accounts_opportunities,[module] => Opportunities,[bean_name] => Opportunity,[source] => non-db,[vname] => LBL_OPPORTUNITY),[project] => Array ([name] => project,[type] => link,[relationship] => projects_accounts,[module] => Project,[bean_name] => Project,[source] => non-db,[vname] => LBL_PROJECTS),[leads] => Array ([name] => leads,[type] => link,[relationship] => account_leads,[module] => Leads,[bean_name] => Lead,[source] => non-db,[vname] => LBL_LEADS),[campaigns] => Array ([name] => campaigns,[type] => link,[relationship] => account_campaign_log,[module] => CampaignLog,[bean_name] => CampaignLog,[source] => non-db,[vname] => LBL_CAMPAIGNLOG,[studio] => Array ([formula] => )),[campaign_accounts] => Array ([name] => campaign_accounts,[type] => link,[vname] => LBL_CAMPAIGNS,[relationship] => campaign_accounts,[source] => non-db),[campaign_id] => Array ([name] => campaign_id,[comment] => Campaign that generated Account,[vname] => LBL_CAMPAIGN_ID,[rname] => id,[id_name] => campaign_id,[type] => id,[table] => campaigns,[isnull] => true,[module] => Campaigns,[reportable] => ,[massupdate] => ,[duplicate_merge] => disabled),[campaign_name] => Array ([name] => campaign_name,[rname] => name,[vname] => LBL_CAMPAIGN,[type] => relate,[reportable] => ,[source] => non-db,[table] => campaigns,[id_name] => campaign_id,[link] => campaign_accounts,[module] => Campaigns,[duplicate_merge] => disabled,[comment] => The first campaign name for Account (Meta-data only)),[prospect_lists] => Array ([name] => prospect_lists,[type] => link,[relationship] => prospect_list_accounts,[module] => ProspectLists,[source] => non-db,[vname] => LBL_PROSPECT_LIST),[aos_quotes] => Array ([name] => aos_quotes,[vname] => LBL_AOS_QUOTES,[type] => link,[relationship] => account_aos_quotes,[module] => AOS_Quotes,[bean_name] => AOS_Quotes,[source] => non-db),[aos_invoices] => Array ([name] => aos_invoices,[vname] => LBL_AOS_INVOICES,[type] => link,[relationship] => account_aos_invoices,[module] => AOS_Invoices,[bean_name] => AOS_Invoices,[source] => non-db),[aos_contracts] => Array ([name] => aos_contracts,[vname] => LBL_AOS_CONTRACTS,[type] => link,[relationship] => account_aos_contracts,[module] => AOS_Contracts,[bean_name] => AOS_Contracts,[source] => non-db),[jjwg_maps_address_c] => Array ([inline_edit] => 1,[required] => ,[source] => custom_fields,[name] => jjwg_maps_address_c,[vname] => LBL_JJWG_MAPS_ADDRESS,[type] => varchar,[massupdate] => 0,[default] => ,[no_default] => ,[comments] => Address,[help] => Address,[importable] => true,[duplicate_merge] => disabled,[duplicate_merge_dom_value] => 0,[audited] => ,[reportable] => 1,[unified_search] => ,[merge_filter] => disabled,[len] => 255,[size] => 20,[id] => Accountsjjwg_maps_address_c,[custom_module] => Accounts),[jjwg_maps_geocode_status_c] => Array ([inline_edit] => 1,[required] => ,[source] => custom_fields,[name] => jjwg_maps_geocode_status_c,[vname] => LBL_JJWG_MAPS_GEOCODE_STATUS,[type] => varchar,[massupdate] => 0,[default] => ,[no_default] => ,[comments] => Geocode Status,[help] => Geocode Status,[importable] => true,[duplicate_merge] => disabled,[duplicate_merge_dom_value] => 0,[audited] => ,[reportable] => 1,[unified_search] => ,[merge_filter] => disabled,[len] => 255,[size] => 20,[id] => Accountsjjwg_maps_geocode_status_c,[custom_module] => Accounts),[jjwg_maps_lat_c] => Array ([inline_edit] => 1,[required] => ,[source] => custom_fields,[name] => jjwg_maps_lat_c,[vname] => LBL_JJWG_MAPS_LAT,[type] => float,[massupdate] => 0,[default] => 0.00000000,[no_default] => ,[comments] => ,[help] => Latitude,[importable] => true,[duplicate_merge] => disabled,[duplicate_merge_dom_value] => 0,[audited] => ,[reportable] => 1,[unified_search] => ,[merge_filter] => disabled,[len] => 10,[size] => 20,[enable_range_search] => ,[precision] => 8,[id] => Accountsjjwg_maps_lat_c,[custom_module] => Accounts),[jjwg_maps_lng_c] => Array ([inline_edit] => 1,[required] => ,[source] => custom_fields,[name] => jjwg_maps_lng_c,[vname] => LBL_JJWG_MAPS_LNG,[type] => float,[massupdate] => 0,[default] => 0.00000000,[no_default] => ,[comments] => ,[help] => Longitude,[importable] => true,[duplicate_merge] => disabled,[duplicate_merge_dom_value] => 0,[audited] => ,[reportable] => 1,[unified_search] => ,[merge_filter] => disabled,[len] => 11,[size] => 20,[enable_range_search] => ,[precision] => 8,[id] => Accountsjjwg_maps_lng_c,[custom_module] => Accounts)),[column_fields] => Array ([0] => id,[1] => name,[2] => date_entered,[3] => date_modified,[4] => modified_user_id,[5] => modified_by_name,[6] => created_by,[7] => created_by_name,[8] => description,[9] => deleted,[10] => created_by_link,[11] => modified_user_link,[12] => assigned_user_id,[13] => assigned_user_name,[14] => assigned_user_link,[15] => SecurityGroups,[16] => account_type,[17] => industry,[18] => annual_revenue,[19] => phone_fax,[20] => billing_address_street,[21] => billing_address_street_2,[22] => billing_address_street_3,[23] => billing_address_street_4,[24] => billing_address_city,[25] => billing_address_state,[26] => billing_address_postalcode,[27] => billing_address_country,[28] => rating,[29] => phone_office,[30] => phone_alternate,[31] => website,[32] => ownership,[33] => employees,[34] => ticker_symbol,[35] => shipping_address_street,[36] => shipping_address_street_2,[37] => shipping_address_street_3,[38] => shipping_address_street_4,[39] => shipping_address_city,[40] => shipping_address_state,[41] => shipping_address_postalcode,[42] => shipping_address_country,[43] => email1,[44] => email_addresses_primary,[45] => email_addresses,[46] => email_addresses_non_primary,[47] => parent_id,[48] => sic_code,[49] => parent_name,[50] => members,[51] => member_of,[52] => email_opt_out,[53] => invalid_email,[54] => cases,[55] => email,[56] => tasks,[57] => notes,[58] => meetings,[59] => calls,[60] => emails,[61] => documents,[62] => bugs,[63] => contacts,[64] => opportunities,[65] => project,[66] => leads,[67] => campaigns,[68] => campaign_accounts,[69] => campaign_id,[70] => campaign_name,[71] => prospect_lists,[72] => aos_quotes,[73] => aos_invoices,[74] => aos_contracts,[75] => jjwg_maps_address_c,[76] => jjwg_maps_geocode_status_c,[77] => jjwg_maps_lat_c,[78] => jjwg_maps_lng_c),[list_fields] => Array (),[current_notify_user] => ,[fetched_row] => ,[fetched_rel_row] => Array (),[layout_def] => ,[force_load_details] => ,[optimistic_lock] => 1,[disable_custom_fields] => ,[number_formatting_done] => ,[process_field_encrypted] => ,[acltype] => module,[additional_meta_fields] => Array (),[notify_inworkflow] => ,[special_notification] => ,[in_workflow] => ,[tracker_visibility] => 1,[listview_inner_join] => Array (),[in_import] => ,[in_save] => ,[logicHookDepth] => Array ([before_retrieve] => 0),[] => 10,[] => Array (),[] => ,[required_fields] => Array ([id] => 1,[name] => 1),[added_custom_field_defs] => 1,[acl_fields] => 1,[jjwg_maps_lat_c] => 0.00000000,[jjwg_maps_lng_c] => 0.00000000), , , , Array ()) called at [xxx\include\SubPanel\SubPanelDefinitions.php:729] #1 SubPanelDefinitions->load_subpanel(delegates, , , , Array ()) called at [xxx\include\SubPanel\SubPanel.php:100] #2 SubPanel->__construct(Accounts, , delegates, , , Array ()) called at [xxx\include\SubPanel\SubPanelSearchDisplay.php:73] #3 require_once(xxx\include\SubPanel\SubPanelSearchDisplay.php) called at [xxx\include\MVC\Controller\SugarController.php:1074] #4 SugarController->handleActionMaps() called at [xxx\include\MVC\Controller\SugarController.php:458] #5 SugarController->process() called at [xxx\include\MVC\Controller\SugarController.php:366] #6 SugarController->execute() called at [xxx\include\MVC\SugarApplication.php:105] #7 SugarApplication->execute() called at [xxx\index.php:52]`
Author
Owner

@pgorod commented on GitHub (Sep 15, 2017):

I'm sorry, I tried looking around the code but couldn't find anything relevant. I'm not the best person to help you since I can't do a full debug right now.

@pgorod commented on GitHub (Sep 15, 2017): I'm sorry, I tried looking around the code but couldn't find anything relevant. I'm not the best person to help you since I can't do a full debug right now.
Author
Owner

@japio commented on GitHub (Nov 8, 2017):

Still not working in 7.9.7.
tested it on the demo site.
no delegates button
After clicking on 'Name' to sort the button displays
delegates button
When you click on 'Select Delegates' a pop-up window is displayed, which remains grey, and you can't select any of the options.
popup grey

@japio commented on GitHub (Nov 8, 2017): Still not working in 7.9.7. tested it on the demo site. ![no delegates button](https://user-images.githubusercontent.com/1961784/32553691-e076f554-c497-11e7-82f9-8e80ed5d6210.png) After clicking on 'Name' to sort the button displays ![delegates button](https://user-images.githubusercontent.com/1961784/32553768-104a957e-c498-11e7-9544-457bd812e1e8.png) When you click on 'Select Delegates' a pop-up window is displayed, which remains grey, and you can't select any of the options. ![popup grey](https://user-images.githubusercontent.com/1961784/32553837-37f40c90-c498-11e7-8871-d94605d8504b.png)
Author
Owner

@Dillon-Brown commented on GitHub (Nov 8, 2017):

@japio this still needs a proper fix but you can use #4643 for a temporary workaround for the grey screen and checkbox issue.

@Dillon-Brown commented on GitHub (Nov 8, 2017): @japio this still needs a proper fix but you can use #4643 for a temporary workaround for the grey screen and checkbox issue.
Author
Owner

@ndarr commented on GitHub (Nov 14, 2017):

Is there any hope that this will be fixed at some point? The issue @japio described breaks the whole functionality of the events module

@ndarr commented on GitHub (Nov 14, 2017): Is there any hope that this will be fixed at some point? The issue @japio described breaks the whole functionality of the events module
Author
Owner

@pgorod commented on GitHub (Nov 14, 2017):

The greyed out screen is a simple z-index issue, it can be fixed in seconds on the browser's Inspector window.

However, when I looked for it in the code, I had a hard time finding out where that z-index value was coming from. Of course with more time it can be discovered, but I don't have it right now...

@pgorod commented on GitHub (Nov 14, 2017): The greyed out screen is a simple z-index issue, it can be fixed in seconds on the browser's Inspector window. However, when I looked for it in the code, I had a hard time finding out where that z-index value was coming from. Of course with more time it can be discovered, but I don't have it right now...
Author
Owner

@pgorod commented on GitHub (Mar 9, 2018):

I just tried this on the Softaculous demo (which is on 7.9.14) and on our live demo (7.10.1) and it works well on both. Can use filter correctly, no errors on screen, and no z-index issues with greyed out screens.

Can anybody still reproduce this on the latest versions?

@pgorod commented on GitHub (Mar 9, 2018): I just tried this on the Softaculous demo (which is on 7.9.14) and on our live demo (7.10.1) and it works well on both. Can use filter correctly, no errors on screen, and no z-index issues with greyed out screens. Can anybody still reproduce this on the latest versions?
Author
Owner

@QuickCRM commented on GitHub (Mar 12, 2018):

Well, it looks like it has finally been fixed :-) (I tried on latest 7.8 and 7.10).

Thanks


support@quickcrm.fr
www.quickcrm.fr/mobile http://www.quickcrm.fr/mobile
Visit our FAQ http://www.quickcrm.fr/mobile/en/content/16-faq

Le 9 mars 2018 à 18:51, pgorod notifications@github.com a écrit :

I just tried this on the Softaculous demo (which is on 7.9.14) and on our live demo (7.10.1) and it works well on both. Can use filter correctly, no errors on screen, and no z-index issues with greyed out screens.

Can anybody still reproduce this on the latest versions?


You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHub https://github.com/salesagility/SuiteCRM/issues/2106#issuecomment-371890729, or mute the thread https://github.com/notifications/unsubscribe-auth/AH3OMgv4WdQqilwSYO_2xU8xTSDOBqH7ks5tcsEWgaJpZM4JyyxU.

@QuickCRM commented on GitHub (Mar 12, 2018): Well, it looks like it has finally been fixed :-) (I tried on latest 7.8 and 7.10). Thanks — support@quickcrm.fr www.quickcrm.fr/mobile <http://www.quickcrm.fr/mobile> Visit our FAQ <http://www.quickcrm.fr/mobile/en/content/16-faq> > Le 9 mars 2018 à 18:51, pgorod <notifications@github.com> a écrit : > > I just tried this on the Softaculous demo (which is on 7.9.14) and on our live demo (7.10.1) and it works well on both. Can use filter correctly, no errors on screen, and no z-index issues with greyed out screens. > > Can anybody still reproduce this on the latest versions? > > — > You are receiving this because you were mentioned. > Reply to this email directly, view it on GitHub <https://github.com/salesagility/SuiteCRM/issues/2106#issuecomment-371890729>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AH3OMgv4WdQqilwSYO_2xU8xTSDOBqH7ks5tcsEWgaJpZM4JyyxU>. >
Sign in to join this conversation.
No milestone
No project
No assignees
1 participant
Notifications
Due date
The due date is invalid or out of range. Please use the format "yyyy-mm-dd".

No due date set.

Dependencies

No dependencies set.

Reference
starred/SuiteCRM-SuiteCRM#1157
No description provided.