Skip to Main Content
IBM Data and AI Ideas Portal for Customers


This portal is to open public enhancement requests against products and services offered by the IBM Data & AI organization. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (https://ideas.ibm.com).


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:


Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,


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


Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal (https://www.ibm.com/ideas) - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal (https://ideas.ibm.com) - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM.

ideasibm@us.ibm.com - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

IBM Employees should enter Ideas at https://ideas.ibm.com


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
    Reply
    |
    Sep 24, 2019

    Thank you again for submitting this Idea!

    After further review, the Custom REST End Points functionality that debuted in OpenPaes 8.0.0.2 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
    Reply
    |
    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
    Reply
    |
    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
    Reply
    |
    Jun 4, 2019

    Hi Warren,

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

    Thanks,

    John Lundgren - Senior Offering Mgr - OpenPages

  • Admin
    JOHN Lundgren
    Reply
    |
    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.