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
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.
Go to cmdb_ci.LIST.
Apply a filter condition with following details in Related List Conditions:
Table: Certification Element > Configuration Item
State is pending
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