I have been trying to establish the functions / operators available within OC rules, and either I can’t find it or the documentation is thin and fragmented.
Basic arithmetic and logical operators for numbers and dates are included in the user documentation, but I can only find reference to others within replies to queries in the users or developer forums. Found so far:
a) some date arithmetic (dates +/- integers for adding, subtracting days),
b) _current_date function,
c) some aggregate functions (sum(), avg(), min(), max(), median(), stdev())
d) a pow(er) function, and
e) a decode function,
The usage and possible limitations of these functions is sometimes hinted at, but it would be good to have a definitive listing.
So, does anyone have a definitive list of what’s possible, or know where one can be found? If so, can they share it please?
Your help would be much appreciated
Steve Canham[email protected]