No Records are Return when Performing a JOIN and a WHERE in BMQL
(Doc ID 2552871.1)
Last updated on DECEMBER 15, 2019
Applies to:Oracle BigMachines CPQ Cloud Service - Version 18 C to 19 C [Release 18 to 19]
Information in this document applies to any platform.
When performing a BMQL call to join two tables, and filtering based on an array set, no records are returned when the array is over 1000 values long.
An example BMQL query is as follows:
The INNER JOIN was recently added into the BMQL statement to join multiple tables.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document