Guest

Preview Tool

Cisco Bug: CSCup71788 - DDR with SQL clause "Select Where In" could not pick multiple string

Last Modified

Jan 26, 2017

Products (1)

  • Cisco Prime Service Catalog

Known Affected Releases

10.0_R2_tanggula 10.0_tanggula 10.1_tanggula 9.3.2_voyager 9.4.1_R2_Vortex 9.4.1_Vortex

Description (partial)

Symptom:
Data Retrieval Rule - does not retrieve any value "Select .. Where column_name IN (Select statement)" and  "IN (Select statement)" result set contain multiple strings.

P.S. This issue cannot be avoided if two different datasources involved.

Conditions:
a. returns integers (single or multi)
SQL: select Name from DirPerson where PersonID IN (select PersonID from DirNetworkInfo) 
select PersonID from DirPerson where PersonID IN (121, 123, 122)

b. returns single string entry
SQL: select Name from DirPerson where Name IN (select Name from DirNetworkInfo)
If IN (select Name from DirNetworkInfo) returns only one string for example "ABCD"

select Name from DirPerson where Name IN (ABCD)

This will not work in the below scenario:
SQL: select Name from DirPerson where Name IN (select Name from DirNetworkInfo)
If (select Name from DirNetworkInfo) returns multiple string entries
e.g.: select Name from DirPerson where Name IN (ABCD, XYZ, QWERT)
Bug details contain sensitive information and therefore require a Cisco.com account to be viewed.

Bug Details Include

  • Full Description (including symptoms, conditions and workarounds)
  • Status
  • Severity
  • Known Fixed Releases
  • Related Community Discussions
  • Number of Related Support Cases
Bug information is viewable for customers and partners who have a service contract. Registered users can view up to 200 bugs per month without a service contract.