Article Details
Id:10979
Product:finPOWER Connect
Type:FIX
Version:1.06.07
Opened:04/03/2013
Closed:12/03/2013
Released:27/03/2013
Job: J011228
High Importance
Breaking Change

Reporting; Transaction List report and query updated

The following changes have been made to the Transaction List report and query:

  • Account User columns moved after other database columns for standardisation with other queries
  • Query always joined with the Account table due to:
    • Incorrect handling of checkbox lists (should never filter if no options OR all options are checked). The following filters have been fixed:
      • Account Classes
    • [Default] tags in Branches and Ledgers forced a join on the Account table, even if they were configured as blank under User Preferences
  • Without the default joining on the Account table, the following ranges etc did not work correctly:
    • Dealer ranges (and all related, e.g., Dealer Regions)
    • Broker ranges (and all related, e.g., Broker Regions)
    • Bulk Funder ranges
    • Insurer ranges
  • Query always forced the inclusion of the CreatedUtcDate column which was incorrect; this has been moved to the Transaction List report and only included if neccessary, i.e., the Date Created column is being displayed