Suitecrm: Filter events delegates does not work

[QuickCRM]

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

[vladbar]

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)

[samus-aran]

@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.

[QuickCRM]

Hi,

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

Thanks

--
[email protected]
NS-Team
www.quickcrm.fr/mobile

Le 17 janv. 2017 à 18:08, Ashley Nicolson [e-mail] 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.

[horus68]

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

1- Error when hitting the "Select Delegates / Filter" when no delegates created

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

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

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)

but sometimes it works (see the modal on the middle now in white)

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

[samus-aran]

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

[chris001]

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?

[jucedupp]

@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.

[pgorod]

@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?

[jucedupp]

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

[jucedupp]

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]

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

[jucedupp]

@pgorod Bump.

[jucedupp]

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.

[pgorod]

@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.

[jucedupp]

@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 [xxxinclude\SubPanel\SubPanelDefinitions.php:729]

1 SubPanelDefinitions->load_subpanel(delegates, , , , Array ()) called at [xxxinclude\SubPanel\SubPanel.php:100]

2 SubPanel->__construct(Accounts, , delegates, , , Array ()) called at [xxxinclude\SubPanel\SubPanelSearchDisplay.php:73]

3 require_once(xxxinclude\SubPanel\SubPanelSearchDisplay.php) called at [xxxinclude\MVC\Controller\SugarController.php:1074]

4 SugarController->handleActionMaps() called at [xxxinclude\MVC\Controller\SugarController.php:458]

5 SugarController->process() called at [xxxinclude\MVC\Controller\SugarController.php:366]

6 SugarController->execute() called at [xxxinclude\MVC\SugarApplication.php:105]

7 SugarApplication->execute() called at [xxx\index.php:52]`

[pgorod]

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.

[japio]

Still not working in 7.9.7.
tested it on the demo site.

After clicking on 'Name' to sort the button displays

When you click on 'Select Delegates' a pop-up window is displayed, which remains grey, and you can't select any of the options.

[Dillon-Brown]

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

[ndarr]

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

[pgorod]

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]

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?

[QuickCRM]

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

Thanks

—
[email protected]
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 [e-mail] 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.