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

  1. In the filter navigator, enter cmdb_ci.list.

  2. Click the Favorites (star icon) button in the filter navigator.

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

  4. Go to mobile mode and open your favorites.

  5. Tap/click the cmdb_ci: All favorite.

  6. 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')


Create a new sys_ui_title record and add the desired search fields to it. For example:

  1. As admin, in the filter navigator, enter sys_ui_title.list.

  2. Click New.

  3. Select the table that corresponds to the list, for example, Configuration Item [cmdb_ci].

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

  5. Click Submit.

    Users should be able to search the corresponding list on mobile for matching strings in the Search Fields.


Related Problem: PRB1236425

Seen In

There is no data to report.

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2020-11-15 12:20:30