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