URL_QUERY
Description
URL_QUERY
is a row function that returns the query portion of a URL string.Syntax
URL_QUERY
(URL_string
)Return Value
Returns the query portion of a URL as a
TEXT
value, NULL
if the URL or does not contain a query, or NULL
if the input string is not a valid URL.For example, in the string
http://www.workday.com/contact.html
, the query portion is NULL
. In the string
http://workday.com/news.php?topic=press&timeframe=today#Workday%20News
, the query portion is topic=press&timeframe=today
.In the string
mailto:username@mycompany.com?subject=Topic
, the query portion is subject=Topic
.Input Parameters
- URL_string
- Required. A field or expression that returns aTEXTvalue in URI (uniform resource identifier) format of:.protocol:authority[/path][?query][#fragment]
- The optional query portion of the URL is separated by a question mark (?) and typically contains an unordered list ofkey=valuepairs separated by an ampersand (&) or semicolon (;).
Examples
Return the query portion of URL string values in the
request
field:URL_QUERY([request])
Return the query portion of a literal URL string:
URL_QUERY("http://workday.com/news.php?topic=press&timeframe=today")
returns topic=press&timeframe=today
.