Difference between revisions of "OpenFlyers SQL stored functions and procedures"

Jump to: navigation, search
(Created page with '__TOC__ =Presentation= This page is dedicated to list OpenFlyers SQL stored functions and procedures which are accessibles to OpenFlyers administrators via the SQL exports or imp...')
 
Line 2: Line 2:
 
=Presentation=
 
=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.
 
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)

Revision as of 19:32, 15 December 2010

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)