Skip to Main Content
IBM Power Ideas Portal


This portal is to open public enhancement requests against IBM Power Systems products, including IBM i. 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
  1. Post an idea.

  2. Get feedback from the IBM team and other customers to refine your idea.

  3. Follow the idea through the IBM Ideas process.


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.

Status Delivered
Workspace IBM i
Categories IBM i Access Family
Created by Guest
Created on Mar 4, 2022

Change SQL Examples to search for just tokens not sentences

My current ACS release is 1.1.8.7.

When I search for an example and I use words (tokens) that are in the displayed text but not in the order of the displayed text the search won't match.

Make the SQL Examples use search word tokens to match to all entries that match those word tokens regardless of where the word appears in the displayed text.


Use Case:

Open ACS Run SQL Scripts, press the examples button or use menu Edit -> Examples -> Insert from Examples or Ctrl+I.

Type "create function".

No match appears but if you type "create or replace function" you will match.


Idea priority Medium
  • Guest
    Reply
    |
    Apr 12, 2022
    1.1.9.0 is now available.

    IBM Power Systems Development
  • Guest
    Reply
    |
    Mar 22, 2022

    We will add some hover text to the Search field so that the user knows it also supports regular expressions.

  • Guest
    Reply
    |
    Mar 8, 2022

    If you specify an option to search using regular expressions then it does satisfy otherwise, it does not satisfy. I, the 8 that voted for this and most likely users of the RSS example search don't know you can search using regular expression. I wonder if by adding a check box to trigger regular expression search it would have made this RFE needless.

    Personally, I don't really want to have to use regular expression syntax for a simple search such as "create function" because my expectation is that my search is not complicated, and thinking about searching using regular expressions is not intuitive.

    The good thing about this RFE is that I have forced myself to experiment with searches in the examples window. I now see how the search is being done whereas before I really never paid enough attention to that part.

  • Guest
    Reply
    |
    Mar 8, 2022

    Thank you for submitting a Request For Enhancement. The current Search filters as you type and supports regular expressions. So instead of typing ???create function", you could type ???create.*function" to satisfy the example you provided. Does this satisfy the request? If not, please provide additional details.

  • Guest
    Reply
    |
    Mar 7, 2022

    Actually, it would be great if you could search the examples by tokens and by sentences. The search for tokens could be triggered by entering the tokens. The search for sentences, on the other hand, could be started by entering a list of words in single or double quotes.