Unable to fetch results in Catalog Report after upgrading to 17.4 RU1

Products

• CA Service Catalog

Issue/Introduction

Issue:

After upgrading to 17.4 RU1 from 17.3 noted discrepancies in fetching the report data.

Steps:

->  Create a report builder object with the below query with a variable

ex: SELECT id,name FROM ca_country WHERE (ca_country.name like N'%%%STRING%%%')  and len ('%%%STRING%%%) >2

-> Create a form with attributes like select box and other elements:

->  For the select box, add the report plug-in ID which is created above,  Add the report-plug-in variable as "$({'STRING':_val})
Associate the form with any of the service catalog offerings.

-> Create a request by selecting the offering that is mentioned in the pre-requisite enter the country names with more than 3 letters and verify

Expected Result -  Should display the list of country names based on the search with more than 3 letters.

Environment

USVCT 17.4 RU1

Resolution

The fix is included in 17.4 RU2.