v.22.12New Feature

Added support for array as second parameter in cutURLParameter function

Official CH changelog text
Added possibility to use an array as a second parameter for cutURLParameter function. It will cut multiple parameters. Close #6827. #43788 (Roman Vasin).
The cutURLParameter function now accepts an array as the second argument, allowing users to remove multiple URL parameters in a single call.

Why it matters

This feature addresses the need to efficiently strip multiple query parameters from URL strings without invoking cutURLParameter repeatedly. It simplifies URL preprocessing and enhances query performance when cleaning URLs by removing several parameters at once.

How to use it

Use cutURLParameter with an array of parameter names as the second argument to remove all listed parameters from the URL. For example:

SELECT cutURLParameter('https://example.com?a=1&b=2&c=3', ['a', 'c'])

This call removes both a and c parameters from the URL.

Related resources

PreviousNext