• ⌂ Query Functions
• Function Categories
  • Aggregate
  • Date & Time
  • Logical
  • Math
  • Object Information
  • Text

More Query Functions

More query functions need to be added to support the full set supported by SQL.

To implement a new function:

1. Add new function to $operators in io_comand_repo/expression.php
2. Add new function to $functions in io_comand_repo/expression_parser.php
3. Add function to io_comand_repo/storage/sql/sql_builder.php
4. Add function to io_comand_repo/collection.php
5. Add new function prototype to io_comand_repo/expression/evaluator.php

Shared Functions

A goal is to eventually offer a common set of functions across cCell, cPath, cQL, cQuery and cScript wherever possible, but to still ensure compatibility with other spreadsheet programs, SQL and JavaScript/PHP.  The following in-progress table is to help organize that effort and will be updated as we work through the implementation and unification of the various functions.

(currently in external spreadsheet)

• < Text
• PHP API >