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

Jump to: navigation, search
(→‎sumAccountEntry)
Line 10: Line 10:
 
*Output parameters:
 
*Output parameters:
 
**stripWord (the string cleaned)
 
**stripWord (the string cleaned)
−
 
  
 
=sumAccountEntry=
 
=sumAccountEntry=

Revision as of 20:36, 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.

stripChars

  • This function exists with OF 3.0+
  • Stored function to get a cleaned string (remove spaces and underscores)
  • Input parameters:
    • word (the string to be cleaned)
  • Output parameters:
    • stripWord (the string cleaned)

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)