Skip to Main Content
IBM Data and AI RegTech Ideas Portal

Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Post your ideas

Post ideas and requests to enhance a product or service. Take a look at ideas others have posted and upvote them if they matter to you,

  1. Post an idea

  2. Upvote ideas that matter most to you

  3. Get feedback from the IBM team to refine your idea

Help IBM prioritize your ideas and requests

The IBM team may need your help to refine the ideas so they may ask for more information or feedback. The offering manager team will then decide if they can begin working on your idea. If they can start during the next development cycle, they will put the idea on the priority list. Each team at IBM works on a different schedule, where some ideas can be implemented right away, others may be placed on a different schedule.

Receive notification on the decision

Some ideas can be implemented at IBM, while others may not fit within the development plans for the product. In either case, the team will let you know as soon as possible. In some cases, we may be able to find alternatives for ideas which cannot be implemented in a reasonable time.

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

Shorter URL for this site is: or

Status Not under consideration
Workspace OpenPages Ideas
Created by Guest
Created on Jun 4, 2019

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.

  • Admin
    JOHN Lundgren
    Sep 24, 2019

    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.

  • Guest
    Jun 21, 2019

    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.

  • Guest
    Jun 19, 2019

    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
    Jun 4, 2019

    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
    Jun 4, 2019

    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.