create_qr_add_where

This command associates a query rewrite function to add a WHERE condition to the 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/qr_add_where

GuardAPI syntax

create_qr_add_where parameter=value

Parameters

Parameter Value type Description
actionName String Required. The unique name of the query rewrite action.
addQualifierFlag Boolean Valid values:
  • 0(false)
  • 1(true)

Default = 1 (true)
definitionName String Required. The query rewrite definition that is associated with this action.
whereText String Text to add to a WHERE clause.

Examples

To add a WHERE clause of "id=2" to the query rewrite definition "qrw_def_Oracle_1" and action name "qrw_act__addwhere_id2":

grdapi create_qr_add_where definitionName="qrw_def_Oracle_1" actionName="qrw_act__addwhere_id2" whereText="id=2"