Reporting → Report Search Criteria → Using Advanced SQL Conditions in SBM Reports
SQL (Structured Query Language), is an ANSI-standard language for selecting records from a database.
A typical SQL selection statement looks something like this:
SELECT database_columns FROM database_table WHERE conditional_expression
Advanced SQL conditions provide you with two ways to implement or control your own SQL:
Pass-through SQL – In some situations you can create a statement that includes a "where" clause. SBM pass-through SQL provides the flexibility to do this with the @ modifier.
SBM-processed SQL – This automatically constructs most of the SQL statement behind the scenes. In most cases, you need to enter only the conditional_expression portion of the statement. You do not have to enter the WHERE keyword; SBM supplies this for you.
SBM Advanced SQL conditions does not support the use of the ORDER BY subquery. ORDER BY with OVER() function may be a valid use case for your database; however, SBM does not currently support that condition.
Copyright © 2013–2019 Micro Focus or one of its affiliates. All rights reserved.