Property reference
glide.db.passthrough.func.allowlist_default
The glide.db.passthrough.func.allowlist_default property specifies a default list of SQL functions that are permitted for passthrough execution. Administrators should review this property to ensure that only necessary functions are allowed, enhancing security and performance.
- Default
ABS,ACOS,ADDDATE,ADDTIME,AGE,ANY,ARRAY_AGG,ARRAY_CAT,ARRAY_DIM,ARRAY_FILL,ARRAY_LENGTH,ARRAY_LOWER,ARRAY_NDIMS,ARRAY_PREPEND,ARRAY_TO_JSON,ARRAY_TO_STRING,ARRAY_UPPER,ASCII,ASIN,ASYMKEY_ID,ATAN,ATAN2,AVG,BIN,BINBINARY,BIT_AND,BIT_COUNT,BIT_LENGTH,BIT_OR,BIT_XOR,BOOL_AND,BOOL_OR,BTRIM,CAST,CBOOL,CBRT,CBYTE,CCUR,CDATE,CDBL,CEIL,CEILING,CHANGES,CHAR,CHARACTER_LENGTH,CHARINDEX,CHARSET,CHAR_LENGTH,CHECKSUM_AGG,CHOOSE,CHR,CINT,CLNG,CLOCK_TIMESTAMP,COALESCE,COL_LENGTH,COL_NAME,COMPRESS,CONCAT,CONCAT_WS,CONV,CONVERT,CONVERT_FROM,CONVERT_TO,CONVERT_TZ,COS,COT,COUNT,CRC32,CSNG,CUME_DIST,CURDATE,CURRENT_QUERY,CURRVAL,CURSOR_STATUS,CURTIME,CVAR,DATALENGTH,DATE,DATEADD,DATEDIFF,DATEFROMPARTS,DATENAME,DATEPART,DATESERIAL,DATETIME2FROMPARTS,DATETIMEFROMPARTS,DATETIMEOFFSETFROMPARTS,DATEVALUE,DATE_ADD,DATE_FORMAT,DATE_PART,DATE_SUB,DATE_TRUNC,DAVG,DAY,DAYNAME,DAYOFMONTH,DAYOFWEEK,DAYOFYEAR,DCOUNT,DECODE,DEGREES,DENSE_RANK,DFIRST,DIFFERENCE,DLAST,DLOOKUP,DMAX,DMIN,DOTWALK,DSUM,DURATION_BETWEEN,DURATION_IN_DAYS,DURATION_IN_MONTHS,DURATION_IN_SECONDS,DV,ELT,ENCODE,ENUM_FIRST,ENUM_LAST,ENUM_RANGE,EOMONTH,EVENTDATA,EXISTS,EXP,EXTRACT,EXTRACTVALUE,EXTRACT_VALUE,FIELD,FIND_IN_SET,FIRST_VALUE,FLOOR,FORMAT,FOUND_ROWS,FROM_BASE64,FROM_DAYS,FROM_UNIXTIME,GETATTR,GETDATE,GETUTCDATE,GET_BIT,GET_BYTE,GET_FORMAT,GET_LOCK,GLIDE_CAST,GLIDE_DATE_TRUNC,GREATEST,GROUPING,GROUPING_ID,GROUP_CONCAT,HASHBYTES,HEX,HOUR,IF,IF EXISTS,IF NOT,IF NOT EXISTS,IFF,IFNULL,IIF,INDEXKEY_PROPERTY,INDEXPROPERTY,INDEX_COL,INET_ATON,INET_NTOA,INITCAP,INSTR,INSTRREV,ISDATE,ISEMPTY,ISFINITE,ISNULL,ISNUMERIC,IS_FREE_LOCK,IS_MEMBER,IS_OBJECTSIGNED,IS_ROLEMEMBER,IS_SRVROLEMEMBER,IS_USED_LOCK,JSON_KEYS,JULIANDAY,JUSTIFY_DAYS,JUSTIFY_HOURS,JUSTIFY_INTERVAL,KEY_GUID,KEY_ID,LAG,LASTVAL,LAST_INSERT_ID,LAST_INSERT_ROWID,LAST_VALUE,LCASE,LEAD,LEAST,LENGTH,LN,LOCATE,LOG,LOG10,LOWER,LOWER_INC,LOWER_INF,LPAD,LTRIM,MAKEDATE,MAKE_SET,MASKLEN,MASTER_POS_WAIT,MAX,MD5,MICROSECOND,MID,MIN,MINUTE,MKDIR,MOD,MONTH,MONTHNAME,NAME_CONST,NETMASK,NEXTVAL,NOW,NTH_VALUE,NTILE,NULLIF,NZ,OCT,OCTET_LENGTH,OPENQUERY,OPENROWSET,OPENXML,ORD,OVERLAPS,OVERLAY,PERCENTILE_COUNT,PERCENTILE_DISC,PERCENTILE_RANK,PERCENT_RANK,PERIOD_ADD,PERIOD_DIFF,PI,POSITION,POW,POWER,QUARTER,QUOTE,QUOTENAME,QUOTE_IDENT,QUOTE_LITERAL,QUOTE_NULLABLE,RADIANS,RAND,RANDOM,RANDOMBLOB,RANK,REGEXP_INSTR,REGEXP_MATCHES,REGEXP_REPLACE,REGEXP_SPLIT_TO_ARRAY,REGEXP_SPLIT_TO_TABLE,REGEXP_SUBSTR,RELEASE_LOCK,REPEAT,REPLACE,REVERSE,ROUND,ROW,ROW_COUNT,ROW_NUMBER,ROW_TO_JSON,RPAD,RTRIM,SECOND,SEC_TO_TIME,SETATTR,SETSEED,SETVAL,SET_BIT,SET_BYTE,SET_MASKLEN,SHA,SHA1,SHA2,SIGN,SIN,SMALLDATETIMEFROMPARTS,SOME,SPACE,SPLIT_PART,SQRT,STATEMENT_TIMESTAMP,STATS_DATE,STDDEV,STDDEV_POP,STDDEV_SAMP,STRCMP,STRCOMP,STRCONV,STRING_AGG,STRING_TO_ARRAY,STRPOS,STR_TO_DATE,STUFF,SUBDATE,SUBSTR,SUBSTRING,SUBSTRING_INDEX,SUBTIME,SUM,SWITCHOFFET,SYS.STRAGG,SYSDATE,SYSDATETIME,SYSDATETIMEOFFSET,SYSTEM_USER,SYSUTCDATETME,TAN,TERTIARY_WEIGHTS,TEXTPOS,TEXTPTR,TEXTVALID,TIMEDIFF,TIMEFROMPARTS,TIMEOFDAY,TIMESERIAL,TIMESTAMPADD,TIMEVALUE,TIME_FORMAT,TIME_TO_SEC,TODATETIMEOFFSET,TOTAL,TOTAL_CHANGES,TO_ASCII,TO_BASE64,TO_CHAR,TO_DATE,TO_DAYS,TO_HEX,TO_NUMBER,TO_SECONDS,TO_TIMESTAMP,TRANSACTION_TIMESTAMP,TRANSLATE,TRIGGER_NESTLEVEL,TRIM,TRUNC,TRUNCATE,TRY_CAST,TRY_CONVERT,TRY_PARSE,TYPEOF,TYPEPROPERTY,TYPE_ID,TYPE_NAME,UCASE,UNCOMPRESS,UNCOMPRESS_LENGTH,UNHEX,UNICODE,UNIX_TIMESTAMP,UNNEST,UPDATEXML,UPPER,UPPER_INC,UPPER_INF,USER_LOCK.SLEEP,USING,UUID,UUID_SHORT,VAR,VARIANCE,VARP,VAR_POP,VAR_SAMP,VERSION,WEEK,WEEKDAY,WEEKDAYNAME,WEEKOFYEAR,WIDTH_BUCKET,XMLAGG,XMLCOMMENT,XMLCONCAT,XMLELEMENT,XMLEXISTS,XMLFOREST,XMLFORMAT,XMLPI,XMLROOT,XMLTYPE,XML_IS_WELL_FORMED,XPATH,XPATH_EXISTS,YEAR,YEARWEEK,ZEROBLOB- Type
- string
- Application
- Global