ReleaseUpdateDB::fields2WhereClause Method [AX 2012]

Gets a string to be used in the where clause in a direct SQL statement.

server public static str fields2WhereClause(
    str _tableAlias1, 
    TableId _tableId1, 
    FieldId _fieldId1, 
    str _tableAlias2, 
    TableId _tableId2, 
    FieldId _fieldId2)

Run On

Server

Parameters

_tableAlias1
Type: str
The name of a table.
_tableId1
Type: TableId Extended Data Type
The ID of a table.
_fieldId1
Type: FieldId Extended Data Type
The ID of a field.
_tableAlias2
Type: str
The name of a table.
_tableId2
Type: TableId Extended Data Type
The ID of a table.
_fieldId2
Type: FieldId Extended Data Type
The ID of a field.

Return Value

Type: str
A condition string that is used in the where clause in a direct SQL statement.

Check for sample usages in existing upgrade scripts when you use this method.

Show: