Class SQLFunctionSymmetricDifference

  • All Implemented Interfaces:
    SQLFunction

    public class SQLFunctionSymmetricDifference
    extends SQLFunctionMultiValueAbstract<Set<Object>>
    This operator can work as aggregate or inline. If only one argument is passed than aggregates, otherwise executes, and returns, the SYMMETRIC DIFFERENCE between the collections received as parameters. Works also with no collection values.
    Author:
    Luca Garulli (l.garulli--(at)--gmail.com)
    • Constructor Detail

      • SQLFunctionSymmetricDifference

        public SQLFunctionSymmetricDifference()
    • Method Detail

      • execute

        public Object execute​(Object iThis,
                              Identifiable iCurrentRecord,
                              Object iCurrentResult,
                              Object[] iParams,
                              CommandContext iContext)
        Description copied from interface: SQLFunction
        Process a record.
        iCurrentRecord - : current record
        iCurrentResult - TODO
        iParams - : function parameters, number is ensured to be within minParams and maxParams.
        iContext - : object calling this function
        Returns:
        function result, can be null. Special cases : can be null if function aggregate results, can be null if function filter results : this mean result is excluded
      • getSyntax

        public String getSyntax()
        Description copied from interface: SQLFunction
        Returns a convenient SQL String representation of the function.

        Example :

          myFunction( param1, param2, [optionalParam3])
         

        This text will be used in exception messages.

        Returns:
        String , never null.