000039253 - Support for CLOB and BLOB variables in Workpoint SQL Nodes added in version 7.0.1 with the new Workflow Editor in RSA Identity Governance & Lifecycle

Document created by RSA Customer Support Employee on Aug 21, 2020
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000039253
Applies ToRSA Product Set: RSA Identity Governance & Lifecycle
RSA Version/Condition: 7.0.1, 7.0.2, 7.1.x, 7.2.x
 
IssueCLOB and BLOB variable support for use in Workpoint SQL Nodes is now available starting in version 7.0.1 of RSA Identity Governance & Lifecycle with the new Workflow Editor.
 
ResolutionThe following datatypes and functions are supported for use in Workpoint SQL Select and SQL Execute Nodes.
  • CLOB datatype
  • BLOB datatype
  • getClob()
  • getClobVal()
  • getBlob()
  • getBlob(Val)


EXAMPLES:



Example 1: Here is an example of selecting a CLOB datatype in a workflow SQL Select node:




select id, name, type, form_data from acmdb.change_request where id=1


  • Public view acmdb.change_request has column form_data which is a CLOB datatype.
  • Go to Requests > Workflows > Request tab > {Workflow name} > Add a SQL Select node > Enter SQL Query > Save.
  • Create a Request that uses this Workflow. Note that it completes without error.

Example 2: Here is an example of using function getClobval() on an XMLTYPE datatype in a workflow SQL Select node:




select id, name, type, cr.violations.getClobval() as VIOL from acmdb.change_request cr where id=1


  • Public view acmdb.change_request has column violations which is an XMLTYPE datatype.
  • Go to Requests > Workflows > Request tab > {Workflow name} > Add a SQL Select node > Enter SQL Query > Save.
  • Create a Request that uses this Workflow. Note that it completes without error.

 
NotesSee related RSA Knowledge Base Article 000031834 -- java.sql.SQLException: Unsupported feature when executing a Workflow with a SQL Node in RSA Identity Governance & Lifecycle for more information.
 

Attachments

    Outcomes