01-07-2020, 04:33 PM
I added the line of code and started in dev mode but, I think I might be getting a different error. When I try to group on the building column (which is a related column, the table is lpc/tenant as a child to lpc/building)
ticket: 161dfa0890e97d4700c
( 'tactic.ui.panel.table_layout_wdg.FastTableLayoutWdg',
{ 'args': { 'badge_view': '',
'base_dir': '',
'checkin_context': '',
'checkin_type': '',
'column_widths': [ 168,
210,
112,
100,
116,
138,
100,
100,
100,
134],
'custom_search_view': '',
'custom_views': '{}',
'default_data': '',
'do_initial_search': '',
'do_search': 'true',
'edit_view': '',
'element_names': [ 'building',
'name',
'code',
'accountnumber',
'unit',
'monthly_total_charges',
'recession_rating',
'primary_email',
'primary_name',
'primary_phone'],
'expression': '',
'extra_columns': '',
'extra_data': '',
'extra_keys': 'select_color,js_load,extra_columns',
'file_system_edit': '',
'filter_view': '',
'gear_settings': '',
'group_elements': '',
'height': '',
'ingest_custom_view': '',
'ingest_data_view': '',
'init_load_num': '',
'insert_view': '',
'is_refresh': 'true',
'js_load': '',
'mode': 'widget',
'no_results_msg': '',
'order_by': '',
'parent_key': '',
'parent_mode': '',
'search_class': '',
'search_dialog_id': 'dialog3339',
'search_key': '',
'search_keys': [],
'search_limit': '',
'search_limit_mode': '',
'search_type': 'lpc/tenant',
'search_view': 'link_search:tenant_export',
'select_color': '',
'settings': '',
'shelf_view': '',
'show_border': '',
'show_collection_tool': '',
'show_column_manager': '',
'show_context_menu': '',
'show_expand': '',
'show_gear': '',
'show_help': '',
'show_insert': '',
'show_keyword_search': '',
'show_layout_switcher': '',
'show_search': 'true',
'show_search_limit': '',
'show_select': '',
'show_shelf': '',
'simple_search_config': '',
'simple_search_mode': '',
'simple_search_view': '',
'state': '{}',
'table_id': 'main_body_table_4017',
'view': 'tenant_export',
'view_attrs': "{'layout': 'TableLayoutWdg'}"},
'libraries': { 'spt_button': True,
'spt_calendar': True,
'spt_help': True,
'spt_html5upload': True,
'spt_icon_button': True,
'spt_popup': True,
'spt_tab': True,
'spt_table': True,
'spt_view_panel': True},
'values': { 'json': '[{"prefix":"filter_mode","filter_mode":"and"},{"prefix":"custom","custom_enabled":"","filter_type":"_column","custom_column":""},{"prefix":"main_body","main_body_enabled":"","filter_type":"_column","main_body_column":"recession_rating","main_body_relation":"is '
'greater '
'than","main_body_value":"3"},{"prefix":"main_body","main_body_enabled":"","filter_type":"building","main_body_column":"","main_body_relation":"is","main_body_value":""},{"prefix":"main_body","main_body_enabled":"","filter_type":"_related","main_body_search_type":"","main_body_column":"","main_body_relation":"is","main_body_value":""},{"prefix":"search_ops","levels":[0,0],"ops":["and","and"],"modes":["child","child"]},{"prefix":"keyword","value":""},{"prefix":"search_limit","Prev":"","Showing":"1 '
'- '
'66","Next":"","search_limit":"","limit_select":"100","custom_limit":"","Showing_last_search_offset":"0"},{"prefix":"group","group":"building","interval":"","order":"","show_retired":""}]'}})
--------------------------------------------------
From ExceptionLog.log
--------------------------------------------------
File "/opt/tactic/tactic/src/pyasm/prod/service/api_xmlrpc.py", line 5401, in get_widget
html = widget.get_buffer_display()
File "/opt/tactic/tactic/src/pyasm/web/widget.py", line 480, in get_buffer_display
buffer = self.get_buffer(cls)
File "/opt/tactic/tactic/src/pyasm/web/widget.py", line 471, in get_buffer
self.explicit_display(cls)
File "/opt/tactic/tactic/src/pyasm/web/widget.py", line 429, in explicit_display
child = self.get_display()
File "/opt/tactic/tactic/src/tactic/ui/panel/table_layout_wdg.py", line 612, in get_display
self.sobjects = self.order_sobjects(self.sobjects, self.group_columns)
File "/opt/tactic/tactic/src/tactic/ui/panel/table_layout_wdg.py", line 1639, in order_sobjects
sobjects = Common.sort_dict(self.group_dict, reverse=reverse)
File "/opt/tactic/tactic/src/pyasm/common/common.py", line 687, in sort_dict
keys.sort(reverse=reverse)
'<' not supported between instances of 'str' and 'bytes'
--------------------------------------------------
Duration: 0.249 seconds (request_id: 140466249242368 - #0000007)
Memory: 76492 KB
Increment: 364 KB
ticket: 161dfa0890e97d4700c
( 'tactic.ui.panel.table_layout_wdg.FastTableLayoutWdg',
{ 'args': { 'badge_view': '',
'base_dir': '',
'checkin_context': '',
'checkin_type': '',
'column_widths': [ 168,
210,
112,
100,
116,
138,
100,
100,
100,
134],
'custom_search_view': '',
'custom_views': '{}',
'default_data': '',
'do_initial_search': '',
'do_search': 'true',
'edit_view': '',
'element_names': [ 'building',
'name',
'code',
'accountnumber',
'unit',
'monthly_total_charges',
'recession_rating',
'primary_email',
'primary_name',
'primary_phone'],
'expression': '',
'extra_columns': '',
'extra_data': '',
'extra_keys': 'select_color,js_load,extra_columns',
'file_system_edit': '',
'filter_view': '',
'gear_settings': '',
'group_elements': '',
'height': '',
'ingest_custom_view': '',
'ingest_data_view': '',
'init_load_num': '',
'insert_view': '',
'is_refresh': 'true',
'js_load': '',
'mode': 'widget',
'no_results_msg': '',
'order_by': '',
'parent_key': '',
'parent_mode': '',
'search_class': '',
'search_dialog_id': 'dialog3339',
'search_key': '',
'search_keys': [],
'search_limit': '',
'search_limit_mode': '',
'search_type': 'lpc/tenant',
'search_view': 'link_search:tenant_export',
'select_color': '',
'settings': '',
'shelf_view': '',
'show_border': '',
'show_collection_tool': '',
'show_column_manager': '',
'show_context_menu': '',
'show_expand': '',
'show_gear': '',
'show_help': '',
'show_insert': '',
'show_keyword_search': '',
'show_layout_switcher': '',
'show_search': 'true',
'show_search_limit': '',
'show_select': '',
'show_shelf': '',
'simple_search_config': '',
'simple_search_mode': '',
'simple_search_view': '',
'state': '{}',
'table_id': 'main_body_table_4017',
'view': 'tenant_export',
'view_attrs': "{'layout': 'TableLayoutWdg'}"},
'libraries': { 'spt_button': True,
'spt_calendar': True,
'spt_help': True,
'spt_html5upload': True,
'spt_icon_button': True,
'spt_popup': True,
'spt_tab': True,
'spt_table': True,
'spt_view_panel': True},
'values': { 'json': '[{"prefix":"filter_mode","filter_mode":"and"},{"prefix":"custom","custom_enabled":"","filter_type":"_column","custom_column":""},{"prefix":"main_body","main_body_enabled":"","filter_type":"_column","main_body_column":"recession_rating","main_body_relation":"is '
'greater '
'than","main_body_value":"3"},{"prefix":"main_body","main_body_enabled":"","filter_type":"building","main_body_column":"","main_body_relation":"is","main_body_value":""},{"prefix":"main_body","main_body_enabled":"","filter_type":"_related","main_body_search_type":"","main_body_column":"","main_body_relation":"is","main_body_value":""},{"prefix":"search_ops","levels":[0,0],"ops":["and","and"],"modes":["child","child"]},{"prefix":"keyword","value":""},{"prefix":"search_limit","Prev":"","Showing":"1 '
'- '
'66","Next":"","search_limit":"","limit_select":"100","custom_limit":"","Showing_last_search_offset":"0"},{"prefix":"group","group":"building","interval":"","order":"","show_retired":""}]'}})
--------------------------------------------------
From ExceptionLog.log
--------------------------------------------------
File "/opt/tactic/tactic/src/pyasm/prod/service/api_xmlrpc.py", line 5401, in get_widget
html = widget.get_buffer_display()
File "/opt/tactic/tactic/src/pyasm/web/widget.py", line 480, in get_buffer_display
buffer = self.get_buffer(cls)
File "/opt/tactic/tactic/src/pyasm/web/widget.py", line 471, in get_buffer
self.explicit_display(cls)
File "/opt/tactic/tactic/src/pyasm/web/widget.py", line 429, in explicit_display
child = self.get_display()
File "/opt/tactic/tactic/src/tactic/ui/panel/table_layout_wdg.py", line 612, in get_display
self.sobjects = self.order_sobjects(self.sobjects, self.group_columns)
File "/opt/tactic/tactic/src/tactic/ui/panel/table_layout_wdg.py", line 1639, in order_sobjects
sobjects = Common.sort_dict(self.group_dict, reverse=reverse)
File "/opt/tactic/tactic/src/pyasm/common/common.py", line 687, in sort_dict
keys.sort(reverse=reverse)
'<' not supported between instances of 'str' and 'bytes'
--------------------------------------------------
Duration: 0.249 seconds (request_id: 140466249242368 - #0000007)
Memory: 76492 KB
Increment: 364 KB