Notifications

33 views

Description

Since New York, the CONTAINS filter condition does not work on the [sc_catalogs] field in database views.

Steps to Reproduce

1. In a NewYork instance, create a database view between sc_category and sc_cat_item. For example, name it "dbview".
2. The configuration for the database view would be following.
a. Create view table 1
table: Category [sc_category]
order: 100
variable prefix: sccategory
b. Create view table 2
table: Item [sc_cat_item]
order: 200
variable prefix:scitem
where clause: sccategory_sys_id =scitem_sc_category
3. Access the database view: dbview_list.do
4. Add a filter: Catalogs CONTAINS Service Catalogs, then run filter. Note the field is "Catalogs", there is another field "Catalog".
5. Syntax error returned: Syntax Error or Access Rule Violation detected by database ((conn=560536) Unknown column 'sc_cat_item0.sys_id' in 'on clause')
6. Change the filter to Does Not Contain, it works.
8. The field "Catalogs" is in sc_cat_item table, run the Contains filer on the table directly, it works fine.
7. Create same db view and run same fitler in Madrid or London, it works fine.

Workaround

This problem is under review and targeted to be fixed in a future release. To receive notifications when more information becomes available, subscribe to this Known Error article by clicking the Subscribe button at the top right of this form.



Related Problem: PRB1371431

Seen In

SR - Security - Integration Framework - Madrid 2019 Q2
SR - Security - Support Common - Madrid 2019 Q2
SR - Security - Support Orchestration - Madrid 2019 Q2
SR - SIR - Security Incident Response - Madrid 2019 Q2
SR - SIR - Security Incident Response PA Content - New York 2019 Q3
SR - SIR - Store SecOps Setup Assistant - Madrid 2019 Q2
SR - SIR - Store Threat Core - Madrid 2019 Q2
SR - SIR - Store Trusted Security Circles Client - New York 2019 Q3
SR - VR - Qualys - New York 2019 Q3
SR - VR - Vulnerability Response - New York 2019 Q3
SR - VR - Vulnerability Response PA Content - Madrid 2019 Q2

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2020-07-09 05:44:23
Published:2020-07-09