Query CommonUDF Library

Functions10 public, 0 private

publicquerycsvToQuery
Path or content of the CSV file.
requiredstringcsv
requiredstringdelimiter
requiredbooleanhasColumnHeader
Retrieves all chained rows within the provided query using the specified selector. This method requires ordered rows to perform correctly.
publicarraygetQueryValueChain
Query to extract the chain from.
requiredquerysource
Key to consider for the chain.
requiredstringselectorKey
Value of the key to match against for the chaining.
requiredstringfilterValue
Corresponding key(s) of the matching row within the chain.
requiredstring<>desiredKey
If you need to call this function more than once on the same source query, increment this value.
numericinstance1
Retrieves all rows within the provided query using the specified selector. This method doesn't require ordered rows, but performs slower than [getQueryValueChain].
publicarraygetQueryValues
Query to extract the values from.
requiredquerysource
Key to consider for the values.
requiredstringselectorKey
Value of the key to match against.
requiredstringfilterValue
Corresponding key(s) of the matching row within the chain.
requiredstring<>desiredKey
publicqueryqueryAppend
requiredqueryqA
requiredqueryqB
Prints the source code of the provided query resultset.
publicstringqueryPrintSourceCode
requiredqueryq
Variable to print.
stringvarquery
Deletes the specified row or range of rows in the provided query.
publicvoidqueryDeleteRow
requiredqueryquery
requirednumericrow
numericrange1
Converts the specified row of the provided query to a struct with its columns as keys.
publicstructqueryRowToStruct
requiredqueryquery
numericrow0
Shuffles the records of the provided query.
publicqueryqueryShuffle
requiredqueryquery
structOPTIONS{}
optionbooleanpreserveColumnTypesfalse
Converts the provided query to an array of structs.
publicarrayqueryToArray
requiredquerysource
Coverts the provided query to CSV according to RFC 4180.
publicstructqueryToCSV
Query to export as CSV.
requiredquerysource
structOPTIONS{}
optionbooleanheadertrue
Delimiter to use in the CSV.
optionstringdelimiter,
Character(s) used for newlines.
optionstringnewlinechr(13) chr(10)
Character used for escaping values in the CSV.
optionstringescape"
Always use quotes to wrap values.
optionbooleanforceQuotesfalse
Append a newline to the end of the output.
optionbooleanappendNewlinefalse
Prepare HTTP header for download.
optionbooleandownloadtrue
Filename of the download.
optionstringfilenameexport