OpenFlyers SQL stored functions and procedures

Revision as of 18:32, 15 December 2010 by Claratte (Talk | contribs)

Jump to: navigation, search

Presentation

This page is dedicated to list OpenFlyers SQL stored functions and procedures which are accessibles to OpenFlyers administrators via the SQL exports or imports.

sumAccountEntry

  • This function exists with OF 2.1+
  • Stored function to compute the current balance of an account at a given date
  • Input parameters:
    • accountId (account Id)
    • endDate (to compute only account entries before this date)
  • Output parameters*
    • totalBalance (balance)