Difference between revisions of "OpenFlyers SQL stored functions and procedures"
(→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
Contents
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)