create_qr_replace_element_byId

This command creates a replacement specification for a specified query rewrite action.

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/create_qr_replace_element_byId

GuardAPI syntax

create_qr_replace_element_byId parameter=value

Parameters

Parameter Value type Description
columnAlias String Specify an alias for a column name.
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
qrActionId Long Required. The unique ID of query rewrite action.
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_byId from the command line with --help=true.

Examples

grdapi create_qr_replace_element_byId qrActionID="1116" replaceType=OBJECT replaceFrom="employee" replaceTo="employee_2"