IBM RegTech Ideas Portal



Our team welcomes any feedback and suggestions you have for improving our offerings. This forum allows us to connect your product improvement ideas with IBM product and engineering teams.


For product documentation, see Knowledge Center.
Create and View Support Cases and Use the Discussion Forum here


Reminder: This is not the place to submit defects or support needs, please use normal support channel for these cases


The shorter URL for this site is:

IBMers, please visit the WFSS Internal Ideas portal


note: The IBM ICM IDEAS Portal is no longer available at this location. If you have reached this page, please look for a new link in the Varicent Administrator. Direct links are found under the "?" in the upper right corner.
A period of transition is likely to impact this service, while ICM becomes Varicent. Please contact Varicent support if you have additional challenges or concerns.

Add More Supported SQL Commands to the GRC Query API

I need more supported commands to be added to the OpenPages GRC Query API. Commands such as TOP/First, LAST, or COUNT.

  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Jun 4 2019
  • Will Not Implement
Component Integration & Risk API
Priority Medium - Important
  • Attach files
  • Admin
    JOHN Lundgren commented
    24 Sep, 2019 01:04am

    Thank you again for submitting this Idea!

    After further review, the Custom REST End Points functionality that debuted in OpenPaes will satisfy this request.

    As far as providing a more specific capability "out of the box"... IBM has considered the request. While we are aligned with the request, it is unlikely to be addressed in the next 18 months. If this request receives continued customer interest, it may be resubmitted for consideration after 18 months from the submit date.

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    21 Jun, 2019 01:16am

    Also to add to my original point, general math functions would be extremely helpful for the same reason listed below. Without them we have to keep pushing it down to custom code. I know it was mentioned that getting away from triggers and helpers would be 'the future' but that is only possible if we have a more robust selection of functions with the query API.

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    19 Jun, 2019 01:59am

    Right now the ideas were brought up because of OP's BPM integration, being able to handle returns easier if you could take only the top few records or last few records to handle as work units.

    A COUNT is great primarily because it easily reduces network traffic containing sensitive information. Imagine (as we do now) returning a huge table from a query just to handle and review it in a trigger or integrated app, when you just need a COUNT. We keep having to push the work onto another application rather than just not pass all the data in the first place.

  • Admin
    JOHN Lundgren commented
    4 Jun, 2019 04:19pm

    Hi Warren,

    Could you provide some Use Cases that describe the overall scenarios that you are trying to satisfy?


    John Lundgren - Senior Offering Mgr - OpenPages

  • Admin
    JOHN Lundgren commented
    4 Jun, 2019 04:17pm

    Thank you for submitting this Idea!

    The IBM team is evaluating this enhancement request. A decision or request for more information will be provided within 90 days.