Searching report query in Service Point does not pass the first page

Products

• CA Service Catalog

Issue/Introduction

SM 17.3 

I have a report builder data object in Service Catalog that is a query to a SQL Server Database.

The data object populates a drop down with 6 pages. In Service Catalog, I can type a word like "Crypto", and the word will populate. However, when using the same drop-down in Service Point, it will not find "Crypto". It does not search past the first page. I have to search through the pages to find it.

 

Environment

Release : 17.3

Resolution

You can use Report/Plug-in Variables.

For example, you can use this in the report database object where statement:  

resource_name Like N'%%%STRING%%%'

and then in the form field property "Report/Plug-in Variables" enter 

$({'STRING':_val})