Member Junction
    Preparing search index...

    Variable ALLOWED_SQL_FUNCTIONSConst

    ALLOWED_SQL_FUNCTIONS: {
        aggregates: readonly [
            "COUNT",
            "COUNT_BIG",
            "SUM",
            "AVG",
            "MIN",
            "MAX",
            "STDEV",
            "STDEVP",
            "VAR",
            "VARP",
            "STRING_AGG",
            "CHECKSUM_AGG",
        ];
        conditional: readonly ["CASE", "WHEN", "THEN", "ELSE", "END"];
        conversion: readonly [
            "CAST",
            "CONVERT",
            "TRY_CAST",
            "TRY_CONVERT",
            "FORMAT",
        ];
        date: readonly [
            "DATEPART",
            "DATEDIFF",
            "DATEADD",
            "YEAR",
            "MONTH",
            "DAY",
            "HOUR",
            "MINUTE",
            "SECOND",
            "GETDATE",
            "GETUTCDATE",
            "SYSDATETIME",
            "EOMONTH",
        ];
        logical: readonly [
            "AND",
            "OR",
            "NOT",
            "IS",
            "NULL",
            "LIKE",
            "BETWEEN",
            "IN",
        ];
        math: readonly [
            "ABS",
            "CEILING",
            "FLOOR",
            "ROUND",
            "POWER",
            "SQRT",
            "LOG",
            "LOG10",
            "EXP",
            "SIGN",
            "RAND",
        ];
        nullHandling: readonly ["ISNULL", "COALESCE", "NULLIF", "IIF"];
        ordering: readonly [
            "ASC",
            "ASCENDING",
            "DESC",
            "DESCENDING",
            "OVER",
            "PARTITION",
            "BY",
            "ORDER",
            "ROWS",
            "RANGE",
            "UNBOUNDED",
            "PRECEDING",
            "FOLLOWING",
            "CURRENT",
            "ROW",
        ];
        string: readonly [
            "LEN",
            "LENGTH",
            "UPPER",
            "LOWER",
            "LTRIM",
            "RTRIM",
            "TRIM",
            "LEFT",
            "RIGHT",
            "SUBSTRING",
            "CHARINDEX",
            "REPLACE",
            "CONCAT",
            "STUFF",
        ];
    } = ...

    Safe SQL functions allowed in expressions, organized by category

    Type Declaration

    • Readonlyaggregates: readonly [
          "COUNT",
          "COUNT_BIG",
          "SUM",
          "AVG",
          "MIN",
          "MAX",
          "STDEV",
          "STDEVP",
          "VAR",
          "VARP",
          "STRING_AGG",
          "CHECKSUM_AGG",
      ]
    • Readonlyconditional: readonly ["CASE", "WHEN", "THEN", "ELSE", "END"]
    • Readonlyconversion: readonly ["CAST", "CONVERT", "TRY_CAST", "TRY_CONVERT", "FORMAT"]
    • Readonlydate: readonly [
          "DATEPART",
          "DATEDIFF",
          "DATEADD",
          "YEAR",
          "MONTH",
          "DAY",
          "HOUR",
          "MINUTE",
          "SECOND",
          "GETDATE",
          "GETUTCDATE",
          "SYSDATETIME",
          "EOMONTH",
      ]
    • Readonlylogical: readonly ["AND", "OR", "NOT", "IS", "NULL", "LIKE", "BETWEEN", "IN"]
    • Readonlymath: readonly [
          "ABS",
          "CEILING",
          "FLOOR",
          "ROUND",
          "POWER",
          "SQRT",
          "LOG",
          "LOG10",
          "EXP",
          "SIGN",
          "RAND",
      ]
    • ReadonlynullHandling: readonly ["ISNULL", "COALESCE", "NULLIF", "IIF"]
    • Readonlyordering: readonly [
          "ASC",
          "ASCENDING",
          "DESC",
          "DESCENDING",
          "OVER",
          "PARTITION",
          "BY",
          "ORDER",
          "ROWS",
          "RANGE",
          "UNBOUNDED",
          "PRECEDING",
          "FOLLOWING",
          "CURRENT",
          "ROW",
      ]
    • Readonlystring: readonly [
          "LEN",
          "LENGTH",
          "UPPER",
          "LOWER",
          "LTRIM",
          "RTRIM",
          "TRIM",
          "LEFT",
          "RIGHT",
          "SUBSTRING",
          "CHARINDEX",
          "REPLACE",
          "CONCAT",
          "STUFF",
      ]

    Settings

    Member Visibility