create_qr_add_where_by_id

This command associates a query rewrite function to add a WHERE condition to the specified query rewrite action, where the action is specified by its ID.

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_add_where_by_id

GuardAPI syntax

create_qr_add_where_by_id parameter=value

Parameters

Parameter Value type Description
addQualifierFlag Boolean Valid values:
  • 0(false)
  • 1(true)

Default = 1 (true)
qrActionId Long Required. The unique ID of query rewrite action.
whereText String Text to add to a WHERE clause.

Examples

To add a WHERE clause of id=2 to the action whose ID is 10002:

grdapi create_qr_add_where_by_id qrActionId=10002 whereText="id=2"