Problem with subpanel navigation

pgr · 3 September 2020 15:59

Hi, welcome to the Community

This might help you

They suggest a workaround: clearing the list view filter and starting again.

There is also an issue here with a fix, which is already included in the latest SuiteCRM:

github.com/salesagility/SuiteCRM

Pagination not working on list views

opened 08:14AM - 11 Sep 18 UTC

closed 04:50PM - 20 Feb 19 UTC

simong1984

Type: Bug Status:Fix Proposed Priority:Critical

### Issue Pagination does not work on Accounts/Opportunities/Contacts list view… (I do not have enough data in other tables to test pagination in those), when either of the "User", "Assigned To" or "Modified By" columns are modified to be displayed/hidden in the Column Chooser. This issue does already exist, however I have added it as a new issue at the request of pgr on the SuiteCRM forums. ### Actual Behavior Upon attempting to navigate through the table, using any of the pagination arrows, the table remains on the same page. If the "User" column is visible by default in the list view, pagination works and only breaks upon hiding it. If the "User" column is hidden by default in the list view, pagination works and only breaks upon displaying it. No log errors or java console errors. See Database User Preferences Table section below. ### Steps to Reproduce 1. Ensure any one of "User" / "Assigned To" / "Modified By" columns are available in default list view, through Studio, either as displayed or hidden. 1. Go to either Accounts / Opportunities / Contacts list view. 2. Set Column Chooser to display/hide "User" or "Assigned To" column and save changes (the opposite of whatever is the default setting). 3. Pagination will not work (either on that page of the table, or after the first navigation through to the next page). ### Workaround Clearing the filter. In my case, I could clear the filter to set the columns back to hidden. 1. Open filter on list view 2. Press "Clear" 3. Press "Search" 4. Pagination works again because "User", "Assigned To" and "Modified By" column are set back to default. ### Attempted fixes that don't work 1. Ensure file/folder permissions set on server 2. Quick Repair/Rebuild 3. Repair JS Files and all other JS related repairs through admin panel ### Database User Preferences Table The following are the base64 decoded values for my user account's global user preferences from the database, before and after pagination works; #### Broken pagination by simply sorting by 'user'; ``` a:81:{s:20:"calendar_publish_key";s:36:"3a7431ed-2e8e-bab7-e7a8-5588ff304018";s:10:"user_theme";s:6:"SuiteP";s:13:"reminder_time";s:4:"1800";s:12:"mailmerge_on";s:2:"on";s:8:"timezone";s:13:"Europe/London";s:16:"swap_last_viewed";s:0:"";s:14:"swap_shortcuts";s:0:"";s:19:"navigation_paradigm";s:2:"gm";s:13:"subpanel_tabs";s:0:"";s:14:"module_favicon";s:0:"";s:9:"hide_tabs";a:0:{}s:11:"remove_tabs";a:0:{}s:7:"no_opps";s:3:"off";s:19:"email_reminder_time";s:2:"60";s:2:"ut";s:1:"1";s:8:"currency";s:3:"-99";s:35:"default_currency_significant_digits";s:1:"2";s:11:"num_grp_sep";s:1:",";s:7:"dec_sep";s:1:".";s:5:"datef";s:5:"d/m/Y";s:5:"timef";s:4:"h:ia";s:26:"default_locale_name_format";s:5:"s f l";s:14:"use_real_names";s:2:"on";s:17:"mail_smtpauth_req";s:0:"";s:12:"mail_smtpssl";i:0;s:17:"email_show_counts";i:0;s:19:"theme_current_group";s:3:"All";s:6:"UsersQ";a:1:{s:13:"searchFormTab";s:15:"advanced_search";}s:11:"editor_type";s:6:"mozaik";s:20:"sort_modules_by_name";s:2:"on";s:16:"reminder_checked";s:1:"0";s:22:"email_reminder_checked";s:1:"0";s:4:"fdow";s:1:"1";s:16:"export_delimiter";s:1:",";s:22:"default_export_charset";s:10:"ISO-8859-9";s:15:"email_link_type";s:6:"mailto";s:8:"subtheme";s:4:"Dawn";s:15:"loginexpiration";s:1:"0";s:7:"lockout";s:0:"";s:11:"loginfailed";s:1:"0";s:10:"OAuthKeysQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:34:"InboundEmail_InboundEmail_ORDER_BY";s:12:"date_entered";s:9:"ACLRolesQ";a:1:{s:13:"searchFormTab";s:15:"advanced_search";}s:15:"SecurityGroupsQ";a:1:{s:13:"searchFormTab";s:15:"advanced_search";}s:10:"EmployeesQ";a:4:{s:6:"module";s:9:"Employees";s:6:"action";s:5:"index";s:5:"query";s:4:"true";s:13:"searchFormTab";s:12:"basic_search";}s:14:"OpportunitiesQ";a:43:{s:13:"return_action";s:0:"";s:13:"return_module";s:0:"";s:6:"module";s:13:"Opportunities";s:6:"action";s:5:"index";s:4:"lvso";s:3:"asc";s:35:"Opportunities2_OPPORTUNITY_ORDER_BY";s:0:"";s:18:"select_entire_list";s:1:"0";s:33:"Opportunities2_OPPORTUNITY_offset";s:2:"20";s:9:"show_plus";s:0:"";s:18:"assigned_user_name";s:0:"";s:16:"assigned_user_id";s:0:"";s:16:"opportunity_type";s:0:"";s:12:"account_name";s:0:"";s:10:"account_id";s:0:"";s:11:"lead_source";s:0:"";s:11:"date_closed";s:0:"";s:11:"sales_stage";s:0:"";s:22:"department_type_list_c";s:0:"";s:14:"displayColumns";s:135:"NAME|ACCOUNT_NAME|SITES_SITES_OPPORTUNITIES_NAME|PRODUCT_C|SALES_STAGE|AMOUNT|DATE_CLOSED|DATE_MODIFIED|DATE_ENTERED|ASSIGNED_USER_NAME";s:5:"query";s:4:"true";s:16:"use_stored_query";s:4:"true";s:19:"update_stored_query";s:4:"true";s:23:"update_stored_query_key";s:14:"displayColumns";s:15:"last_search_tab";s:8:"advanced";s:18:"save_columns_order";s:4:"true";s:13:"searchFormTab";s:15:"advanced_search";s:13:"name_advanced";s:0:"";s:21:"account_name_advanced";s:0:"";s:28:"amount_advanced_range_choice";s:1:"=";s:21:"range_amount_advanced";s:0:"";s:27:"start_range_amount_advanced";s:0:"";s:25:"end_range_amount_advanced";s:0:"";s:33:"date_closed_advanced_range_choice";s:1:"=";s:26:"range_date_closed_advanced";s:0:"";s:32:"start_range_date_closed_advanced";s:0:"";s:30:"end_range_date_closed_advanced";s:0:"";s:18:"next_step_advanced";s:0:"";s:17:"saved_search_name";s:0:"";s:13:"search_module";s:0:"";s:19:"saved_search_action";s:0:"";s:8:"hideTabs";s:231:"CLOSE_DATE_C|PROBABILITY|PRODUCT_CATEGORY_C|DEPARTMENT_C|OPPORTUNITY_TYPE|UNIT_QUANTITY_C|LEAD_SOURCE|NEXT_STEP|MODIFIED_BY_NAME|AMOUNT_WEIGHTED_C|NEXT_STEP_DATETIME_C|EXPECTED_CLOSE_QUARTER_C|AMOUNT_USDOLLAR|DEPARTMENT_TYPE_LIST_C";s:7:"orderBy";s:4:"NAME";s:6:"button";s:6:"Search";}s:23:"AOS_Product_CategoriesQ";a:1:{s:13:"searchFormTab";s:15:"advanced_search";}s:13:"AOS_ProductsQ";a:10:{s:6:"module";s:12:"AOS_Products";s:6:"action";s:5:"index";s:14:"displayColumns";s:66:"NAME|PART_NUMBER|COST|PRICE|AOS_PRODUCT_CATEGORY_NAME|DATE_ENTERED";s:5:"query";s:4:"true";s:16:"use_stored_query";s:4:"true";s:19:"update_stored_query";s:4:"true";s:23:"update_stored_query_key";s:14:"displayColumns";s:15:"last_search_tab";s:8:"advanced";s:18:"save_columns_order";s:4:"true";s:13:"searchFormTab";s:15:"advanced_search";}s:12:"AOR_ReportsQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:9:"AccountsQ";a:1:{s:13:"searchFormTab";s:15:"advanced_search";}s:13:"AOW_WorkFlowQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:7:"EmailsQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:15:"EmailTemplatesQ";a:1:{s:13:"searchFormTab";s:15:"advanced_search";}s:22:"OutboundEmailAccountsQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:22:"AOR_Scheduled_ReportsQ";a:1:{s:13:"searchFormTab";s:15:"advanced_search";}s:8:"SurveysQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:6:"LeadsQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:6:"TasksQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:9:"ContactsQ";a:1:{s:13:"searchFormTab";s:15:"advanced_search";}s:19:"jjwg_Address_CacheQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:11:"SchedulersQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:14:"OAuth2ClientsQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:11:"AOS_QuotesQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:10:"DocumentsQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:8:"ProjectQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:30:"AOK_Knowledge_Base_CategoriesQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:6:"NotesQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:25:"Releases_RELEASE_ORDER_BY";s:10:"list_order";s:18:"AOS_PDF_TemplatesQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:14:"AOW_ProcessedQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:9:"MeetingsQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:6:"CallsQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:9:"EmailManQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:14:"AOS_ContractsQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:6:"SpotsQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:13:"AOS_InvoicesQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:11:"jjwg_AreasQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:17:"Calls_RescheduleQ";a:1:{s:13:"searchFormTab";s:15:"advanced_search";}s:19:"FP_Event_LocationsQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:12:"sites_SitesQ";a:25:{s:6:"module";s:11:"sites_Sites";s:6:"action";s:5:"index";s:13:"searchFormTab";s:15:"advanced_search";s:5:"query";s:4:"true";s:13:"name_advanced";s:0:"";s:23:"address_street_advanced";s:0:"";s:14:"phone_advanced";s:0:"";s:21:"address_city_advanced";s:0:"";s:22:"address_state_advanced";s:0:"";s:27:"address_postalcode_advanced";s:0:"";s:24:"address_country_advanced";s:0:"";s:26:"organisation_code_advanced";s:0:"";s:35:"organisation_sub_type_code_advanced";s:0:"";s:26:"national_grouping_advanced";s:0:"";s:36:"high_level_health_geography_advanced";s:0:"";s:33:"parent_organisation_code_advanced";s:0:"";s:17:"gor_code_advanced";s:0:"";s:34:"sites_sites_accounts_name_advanced";s:0:"";s:17:"saved_search_name";s:0:"";s:13:"search_module";s:0:"";s:19:"saved_search_action";s:0:"";s:14:"displayColumns";s:0:"";s:8:"hideTabs";s:205:"HIGH_LEVEL_HEALTH_GEOGRAPHY|BILLING_ADDRESS_STREET|BILLING_ADDRESS_POSTALCODE|OPEN_CDATE|CLOSE_DATE|ORGANISATION_SUB_TYPE_CODE|PARENT_ORGANISATION_CODE|GOR_CODE|NATIONAL_GROUPING|DATE_ENTERED|DATE_MODIFIED";s:7:"orderBy";s:4:"NAME";s:6:"button";s:6:"Search";}s:10:"jjwg_MapsQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}} ``` #### Pagination working again after clearing the filter; ``` a:81:{s:20:"calendar_publish_key";s:36:"3a7431ed-2e8e-bab7-e7a8-5588ff304018";s:10:"user_theme";s:6:"SuiteP";s:13:"reminder_time";s:4:"1800";s:12:"mailmerge_on";s:2:"on";s:8:"timezone";s:13:"Europe/London";s:16:"swap_last_viewed";s:0:"";s:14:"swap_shortcuts";s:0:"";s:19:"navigation_paradigm";s:2:"gm";s:13:"subpanel_tabs";s:0:"";s:14:"module_favicon";s:0:"";s:9:"hide_tabs";a:0:{}s:11:"remove_tabs";a:0:{}s:7:"no_opps";s:3:"off";s:19:"email_reminder_time";s:2:"60";s:2:"ut";s:1:"1";s:8:"currency";s:3:"-99";s:35:"default_currency_significant_digits";s:1:"2";s:11:"num_grp_sep";s:1:",";s:7:"dec_sep";s:1:".";s:5:"datef";s:5:"d/m/Y";s:5:"timef";s:4:"h:ia";s:26:"default_locale_name_format";s:5:"s f l";s:14:"use_real_names";s:2:"on";s:17:"mail_smtpauth_req";s:0:"";s:12:"mail_smtpssl";i:0;s:17:"email_show_counts";i:0;s:19:"theme_current_group";s:3:"All";s:6:"UsersQ";a:1:{s:13:"searchFormTab";s:15:"advanced_search";}s:11:"editor_type";s:6:"mozaik";s:20:"sort_modules_by_name";s:2:"on";s:16:"reminder_checked";s:1:"0";s:22:"email_reminder_checked";s:1:"0";s:4:"fdow";s:1:"1";s:16:"export_delimiter";s:1:",";s:22:"default_export_charset";s:10:"ISO-8859-9";s:15:"email_link_type";s:6:"mailto";s:8:"subtheme";s:4:"Dawn";s:15:"loginexpiration";s:1:"0";s:7:"lockout";s:0:"";s:11:"loginfailed";s:1:"0";s:10:"OAuthKeysQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:34:"InboundEmail_InboundEmail_ORDER_BY";s:12:"date_entered";s:9:"ACLRolesQ";a:1:{s:13:"searchFormTab";s:15:"advanced_search";}s:15:"SecurityGroupsQ";a:1:{s:13:"searchFormTab";s:15:"advanced_search";}s:10:"EmployeesQ";a:4:{s:6:"module";s:9:"Employees";s:6:"action";s:5:"index";s:5:"query";s:4:"true";s:13:"searchFormTab";s:12:"basic_search";}s:14:"OpportunitiesQ";a:38:{s:13:"return_action";s:0:"";s:13:"return_module";s:0:"";s:6:"module";s:13:"Opportunities";s:6:"action";s:5:"index";s:4:"lvso";s:3:"asc";s:35:"Opportunities2_OPPORTUNITY_ORDER_BY";s:0:"";s:18:"select_entire_list";s:1:"0";s:33:"Opportunities2_OPPORTUNITY_offset";s:2:"20";s:9:"show_plus";s:0:"";s:18:"assigned_user_name";s:0:"";s:16:"assigned_user_id";s:0:"";s:16:"opportunity_type";s:0:"";s:12:"account_name";s:0:"";s:10:"account_id";s:0:"";s:11:"lead_source";s:0:"";s:11:"date_closed";s:0:"";s:11:"sales_stage";s:0:"";s:22:"department_type_list_c";s:0:"";s:13:"searchFormTab";s:15:"advanced_search";s:5:"query";s:4:"true";s:13:"name_advanced";s:0:"";s:21:"account_name_advanced";s:0:"";s:28:"amount_advanced_range_choice";s:1:"=";s:21:"range_amount_advanced";s:0:"";s:27:"start_range_amount_advanced";s:0:"";s:25:"end_range_amount_advanced";s:0:"";s:33:"date_closed_advanced_range_choice";s:1:"=";s:26:"range_date_closed_advanced";s:0:"";s:32:"start_range_date_closed_advanced";s:0:"";s:30:"end_range_date_closed_advanced";s:0:"";s:18:"next_step_advanced";s:0:"";s:17:"saved_search_name";s:0:"";s:13:"search_module";s:0:"";s:19:"saved_search_action";s:0:"";s:14:"displayColumns";s:0:"";s:8:"hideTabs";s:231:"CLOSE_DATE_C|PROBABILITY|PRODUCT_CATEGORY_C|DEPARTMENT_C|OPPORTUNITY_TYPE|UNIT_QUANTITY_C|LEAD_SOURCE|NEXT_STEP|MODIFIED_BY_NAME|AMOUNT_WEIGHTED_C|NEXT_STEP_DATETIME_C|EXPECTED_CLOSE_QUARTER_C|AMOUNT_USDOLLAR|DEPARTMENT_TYPE_LIST_C";s:7:"orderBy";s:4:"NAME";s:6:"button";s:6:"Search";}s:23:"AOS_Product_CategoriesQ";a:1:{s:13:"searchFormTab";s:15:"advanced_search";}s:13:"AOS_ProductsQ";a:10:{s:6:"module";s:12:"AOS_Products";s:6:"action";s:5:"index";s:14:"displayColumns";s:66:"NAME|PART_NUMBER|COST|PRICE|AOS_PRODUCT_CATEGORY_NAME|DATE_ENTERED";s:5:"query";s:4:"true";s:16:"use_stored_query";s:4:"true";s:19:"update_stored_query";s:4:"true";s:23:"update_stored_query_key";s:14:"displayColumns";s:15:"last_search_tab";s:8:"advanced";s:18:"save_columns_order";s:4:"true";s:13:"searchFormTab";s:15:"advanced_search";}s:12:"AOR_ReportsQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:9:"AccountsQ";a:1:{s:13:"searchFormTab";s:15:"advanced_search";}s:13:"AOW_WorkFlowQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:7:"EmailsQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:15:"EmailTemplatesQ";a:1:{s:13:"searchFormTab";s:15:"advanced_search";}s:22:"OutboundEmailAccountsQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:22:"AOR_Scheduled_ReportsQ";a:1:{s:13:"searchFormTab";s:15:"advanced_search";}s:8:"SurveysQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:6:"LeadsQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:6:"TasksQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:9:"ContactsQ";a:1:{s:13:"searchFormTab";s:15:"advanced_search";}s:19:"jjwg_Address_CacheQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:11:"SchedulersQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:14:"OAuth2ClientsQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:11:"AOS_QuotesQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:10:"DocumentsQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:8:"ProjectQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:30:"AOK_Knowledge_Base_CategoriesQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:6:"NotesQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:25:"Releases_RELEASE_ORDER_BY";s:10:"list_order";s:18:"AOS_PDF_TemplatesQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:14:"AOW_ProcessedQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:9:"MeetingsQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:6:"CallsQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:9:"EmailManQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:14:"AOS_ContractsQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:6:"SpotsQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:13:"AOS_InvoicesQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:11:"jjwg_AreasQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:17:"Calls_RescheduleQ";a:1:{s:13:"searchFormTab";s:15:"advanced_search";}s:19:"FP_Event_LocationsQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}s:12:"sites_SitesQ";a:25:{s:6:"module";s:11:"sites_Sites";s:6:"action";s:5:"index";s:13:"searchFormTab";s:15:"advanced_search";s:5:"query";s:4:"true";s:13:"name_advanced";s:0:"";s:23:"address_street_advanced";s:0:"";s:14:"phone_advanced";s:0:"";s:21:"address_city_advanced";s:0:"";s:22:"address_state_advanced";s:0:"";s:27:"address_postalcode_advanced";s:0:"";s:24:"address_country_advanced";s:0:"";s:26:"organisation_code_advanced";s:0:"";s:35:"organisation_sub_type_code_advanced";s:0:"";s:26:"national_grouping_advanced";s:0:"";s:36:"high_level_health_geography_advanced";s:0:"";s:33:"parent_organisation_code_advanced";s:0:"";s:17:"gor_code_advanced";s:0:"";s:34:"sites_sites_accounts_name_advanced";s:0:"";s:17:"saved_search_name";s:0:"";s:13:"search_module";s:0:"";s:19:"saved_search_action";s:0:"";s:14:"displayColumns";s:0:"";s:8:"hideTabs";s:205:"HIGH_LEVEL_HEALTH_GEOGRAPHY|BILLING_ADDRESS_STREET|BILLING_ADDRESS_POSTALCODE|OPEN_CDATE|CLOSE_DATE|ORGANISATION_SUB_TYPE_CODE|PARENT_ORGANISATION_CODE|GOR_CODE|NATIONAL_GROUPING|DATE_ENTERED|DATE_MODIFIED";s:7:"orderBy";s:4:"NAME";s:6:"button";s:6:"Search";}s:10:"jjwg_MapsQ";a:1:{s:13:"searchFormTab";s:12:"basic_search";}} ``` #### Environment * SuiteCRM Version used: 7.10.7 - upgraded from 7.10.4 * Browser name and version: Chrome 68.0.3440.106 (64-bit) * Environment name and version: MySQL / PHP 7 * Operating System and version: Debian 9

The fix is simple, in case you want to try it manually: Fixed #6298 - Pagination not working on list views · salesagility/SuiteCRM@e90e724 · GitHub