list_qr_replace_element

This command outputs replacements for a specified query rewrite action and query rewrite definition pair.

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

REST API syntax

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

GuardAPI syntax

list_qr_replace_element parameter=value

Parameters

Parameter Value type Description
actionName String Required. A query rewrite action.
definitionName String Required. A query rewrite definition.
detail Boolean Valid values:
  • 0: False. Returns the name only.
  • 1: True. Returns all the associated attributes of the conditions.

Default = 1 (true)
replaceType String Valid values:
  • SELECT
  • VERB
  • OBJECT
  • SENTENCE
  • SELECTLIST

Examples

grdapi list_qr_replace_element actionName="qr action2" definitionName="case 2"
Output:
<servername>> grdapi list_qr_replace_element actionName="qr action2" definitionName="case 2"      #######################################################################
         QR replace elements for action 'qr action2' - (qrActionId = 1 )

#######################################################################

qr replace element ID: 1
qr replace type: object
qr replace from: emp
qr replace to: NEW_EMP
qr is from regex: false
qr is from all rule elements: false

***********************************************************************
qr replace element ID: 2
qr replace type: selectList
qr replace from: Whole select list
qr replace to: EMPNO,SAL
qr is from regex: false
qr is from all rule elements: false