Dot-walkable Currency Instance fields

  • Release version: Yokohama
  • Updated January 30, 2025
  • 1 minute to read

    • You can dot-walk certain fields in the Currency Instance [fx_currency2_instance] record, and field values stored in the database are consistent with each other. However, in script, since fields can be changed individually, and you change only some of the fields, they can be inconsistent.

    Currency code

    The Currency field isn't a reference field, so you can set it to any value. However, if you enter an invalid currency code, an exception message is generated. An empty value is considered a session currency code.

    Query conditions

    You can add query conditions on dot-walked fields in the instance table. However, when the query condition value is in a special format with currency code and amount, it's treated as a compound condition on the dot walked fields. The value has to be in format XYZ,abc where:
    • XYZ is a currency code, and
    • abc is an amount.

    For example, USD, 12.34.

    A condition such as cost>USD,12.34 is treated as cost.currency>USD AND cost.amount12.34.

    When the second operand is another Currency2 field, the condition translates in a similar manner:

    cost1>cost2 is treated as cost1.currency=cost2.currency AND cost1.amount>cost2.amount.