Filter condition based on related list on cmdb_ci returns no results and causes "Syntax Error or Access Rule Violation detected by database" error.

Steps to Reproduce

  1. Make sure that the List V3 plugin is active.

    For more information, see the product documentation topic Activate List v3. Adding a filter condition based on a related list works only with List V3.

  2. Go to cmdb_ci.LIST.

  3. Apply a filter condition with following details in Related List Conditions:

    Table: Certification Element > Configuration Item
    State is pending

  4. Click Run.

    Note that the no results are returned and the following error message appears:

    Syntax Error or Access Rule Violation detected by database (Unknown column 'sj0.configuration_item' in 'on clause')


This issue is under review. To receive notifications when more information is available, subscribe to this Known Error article by clicking the Subscribe button at the top right of the article. If you are able to upgrade, review the Fixed In or Intended Fix Version fields to determine whether any versions have a planned or permanent fix.


Related Problem: PRB1255228

Seen In

There is no data to report.

Fixed In

London Patch 6
Madrid Patch 1
New York

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2020-02-24 06:37:28