My Oracle Support Banner

BigMachines Query Language Overview (Doc ID 1660558.1)

Last updated on DECEMBER 18, 2019

Applies to:

Oracle BigMachines CPQ Cloud Service - Version 12.0 and later
Information in this document applies to any platform.

Purpose

This article is from the Oracle CPQ Cloud Product Help. For the most recent information, please log in to your CPQ Cloud site and click here.

An overview of BigMachines Query Language (BMQL) Overview in Oracle CPQ Cloud.

Details

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
Purpose
Details
 Overview
 Administration
 Basics
 Advanced
 bmql(sqlQuery)
 Select All Columns
 Statement Keywords
 The DISTINCT Keyword
  
 
 WHERE Clauses and Parameters
 Overview
 WHERE Condition
 Conditional evaluation in a WHERE clause
 Conditional Evaluation
 Join Clauses
 Join Two Tables
 Join Multiple Tables
 Dotted Notation
 Order By Support For Join Clause
 Order By With Dotted Notation
 Sort Multiple Columns
 Alias Support for Select and FROM Clauses
 Transaction Data
 Operators
 Wildcards
 Finding Available Tables
 Parameters
 contextOverride
 fieldMap
 Use Case Examples
 Sample Use Case 1: Using BMQL function
 Sample Use Case 2: Using the get function and the WHERE Clause
 Sample Use Case 3: Using a WHERE condition
 Sample Use Case 4: Errors
 Sample Use Case 5: Recommended Item Rule
 Sample Use Case 6: Using BMQL Transaction
 Notes

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.