create_qr_replace_element

This command creates a replacement element, or set of elements, such as an entire SQL sentence or a SELECT list.

This API is available in Guardium V10.1.4 and later.

REST API syntax

This API is available as a REST service with the POST method. Call this API as follows: 
POST https://[Guardium hostname or IP address]:8443/restAPI/qr_replace_element

GuardAPI syntax

create_qr_replace_element parameter=value

Parameters

Parameter Value type Description
actionName String Required. The unique name of the query rewrite action this rewrite function is associated with.
columnAlias String Specify an alias for a column name.
definitionName String Required. A unique name for this query rewrite definition condition.
isFromAllRuleElements Boolean Indicates that this action applies to all FROM elements. Valid values:
  • 0: False
  • 1: True
Default is false.
isFromRegex Boolean Indicates that the ‘from’ element is specified by using a regular expression. Valid values:
  • 0: False
  • 1: True
Default is false.
isReplaceToFunction Boolean Indicates that the "replace to" is the name of a function, such as user-defined function. Valid values:
  • 0: False
  • 1: True
replaceFrom String Required. The incoming string for a matching rule that is to be replaced. Use replaceType to indicate specifically which element of the incoming query to examine.
replaceTo String Required. The replacement string for the matching element.
replaceType String Required. Indicates what is to be replaced. For valid values, call create_qr_replace_element from the command line with --help=true.

Examples

grdapi create_qr_replace_element definitionName="case 15" actionName="qr action15_2" replaceType=VERB replaceFrom="select" replaceTo="select++"