Description
In the mobile application, using application search on a cmdb_ci list results in the following error:
Syntax Error or Access Rule Violation detected by database (Unknown column 'core_company0.sys_class_name' in 'where clause')
Steps to Reproduce
-
In the filter navigator, enter cmdb_ci.list.
-
Click the Favorites (star icon) button in the filter navigator.
-
Drag the All from the Configuration Items filter from the banner frame to the Navigator frame (Favorites tab).
This creates a favorite named cmdb_ci: All.
-
Go to mobile mode and open your favorites.
-
Tap/click the cmdb_ci: All favorite.
-
In the Application Search field, start typing a string that matches something you see in the list.
Expected behavior: The list should be filtered to match items match the string you typed in the Application Search field.
Actual behavior: The following error is displayed twice for each character entered in the Application Search:
Syntax Error or Access Rule Violation detected by database (Unknown column 'core_company0.sys_class_name' in 'where clause')
Workaround
Create a new sys_ui_title record and add the desired search fields to it. For example:
-
As admin, in the filter navigator, enter sys_ui_title.list.
-
Click New.
-
Select the table that corresponds to the list, for example, Configuration Item [cmdb_ci].
-
Click the lock icon to the right of Search Fields and add the fields you want users to be able to check against when entering search terms on mobile.
-
Click Submit.
Users should be able to search the corresponding list on mobile for matching strings in the Search Fields.
Related Problem: PRB1236425