/AWS1/CL_CRMCOMPARISONCONTROLS¶
Specifies how a query can compare the columns in a table, including literal comparisons and column-to-column comparisons.
CONSTRUCTOR¶
IMPORTING¶
Required arguments:¶
it_alwdliteralcomprsncolumns TYPE /AWS1/CL_CRMALYRULECOLUMNLST_W=>TT_ANALYSISRULECOLUMNLIST TT_ANALYSISRULECOLUMNLIST¶
The columns that a query can compare to literal values, for example, in a WHERE clause. Clean Rooms rejects a query that compares any other column to a literal value. Specify an empty list to block literal comparison on every column. You can't specify a column that you also use as an identity column in an aggregation threshold.
it_alwdcolumncomprsncolumns TYPE /AWS1/CL_CRMALYRULECOLUMNLST_W=>TT_ANALYSISRULECOLUMNLIST TT_ANALYSISRULECOLUMNLIST¶
The columns that a query can compare to another column, for example, in a join, a WHERE clause, a GROUP BY clause, or a window function. Clean Rooms rejects a query that uses any other column in a column-to-column comparison. Specify an empty list to block column-to-column comparison on every column.
Queryable Attributes¶
allowedLiteralComparisonColumns¶
The columns that a query can compare to literal values, for example, in a WHERE clause. Clean Rooms rejects a query that compares any other column to a literal value. Specify an empty list to block literal comparison on every column. You can't specify a column that you also use as an identity column in an aggregation threshold.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_ALWDLITERALCOMPRSNCOLS() |
Getter for ALLOWEDLITERALCOMPRSNCOLUMNS, with configurable d |
ASK_ALWDLITERALCOMPRSNCOLS() |
Getter for ALLOWEDLITERALCOMPRSNCOLUMNS w/ exceptions if fie |
HAS_ALWDLITERALCOMPRSNCOLS() |
Determine if ALLOWEDLITERALCOMPRSNCOLUMNS has a value |
allowedColumnComparisonColumns¶
The columns that a query can compare to another column, for example, in a join, a WHERE clause, a GROUP BY clause, or a window function. Clean Rooms rejects a query that uses any other column in a column-to-column comparison. Specify an empty list to block column-to-column comparison on every column.
Accessible with the following methods¶
| Method | Description |
|---|---|
GET_ALWDCOLUMNCOMPRSNCOLUMNS() |
Getter for ALLOWEDCOLUMNCOMPRSNCOLUMNS, with configurable de |
ASK_ALWDCOLUMNCOMPRSNCOLUMNS() |
Getter for ALLOWEDCOLUMNCOMPRSNCOLUMNS w/ exceptions if fiel |
HAS_ALWDCOLUMNCOMPRSNCOLUMNS() |
Determine if ALLOWEDCOLUMNCOMPRSNCOLUMNS has a value |