Skip to Main Content
IBM Power 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

Start by posting ideas and requests to this portal to enhance a Power 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 and add comments to 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 Power teams 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.


Specific link you will want to bookmark for future use

IBM Unified Ideas Portal - https://ideas.ibm.com/ - Use this site to create or search for existing Ideas across all IBM products that are outside of Power, and track all of your personal interactions with all Ideas.

Status Not under consideration
Workspace IBM i
Created by Guest
Created on May 27, 2019

WRKUSRPRF - search for part of name in description

I would like to have the possibility in WRKUSRPRF to search for a given string in the description of the user profile. If the users for example have the name Jens Petersen or Peter Jensen then I would like to be able to find them searching with the string "jens". It could be implemented by enhancing the F17=Start list with. Something like the F17 in the old PDM where you could search for a member text.


Use Case:

If you dont know the entire name and have to find a user this would make life easier and you don't have to browse all users in order to find the user id.


Idea priority Medium
  • Guest
    Apr 17, 2020

    There are already multiple ways to do this today

    You can use the IBM i Services

    This can also be done with the Web Navigator support.

  • Guest
    Feb 7, 2020

    If you just want to view the user profile, I agree, using the view would be more than enough information without having to use the WRKUSRPRF command.

    That being said, most of the time, if we want to work with the user profile, we are looking to change something. That can be done by using sql. The SQL view can by searching and building up the change user profile command and then call qxmdexc.

    for example

    begin
    declare execCommand char( 150 );
    FOR cleanup AS userProfiles CURSOR FOR
    SELECT 'CHGUSRPRF (' concat authorization_name concat ') status(*disabled)' as command FROM USER_INFO WHERE LOWER(TEXT_DESCRIPTION) LIKE '%jens%'
    DO
    SET execCommand = command;
    call qcmdexc( command );
    END FOR;
    end;

    I would recommend running the select separate to this procedure to verify that you are getting the correct user but, sql can do alot for you.

  • Guest
    May 29, 2019

    Yes I know. This is one of the ways to do it. But I still have to copy/paste the userId to another session to do a WRKUSRPRF there. This is not an improvement for me.

  • Guest
    May 28, 2019

    Hello.

    There is a SQL View to query userprofiles (USER_INFO)
    Maybe it could help you to find your profiles

    SELECT * FROM USER_INFO WHERE LOWER(TEXT_DESCRIPTION) LIKE '%jens%'

    greets
    Chris

  • Guest
    May 28, 2019

    Hello.

    There is a SQL View to query userprofiles (USER_INFO)
    Maybe it could help you to find your profiles

    SELECT * FROM USER_INFO WHERE LOWER(TEXT_DESCRIPTION) LIKE '%jens%'

    greets
    Chris

  • Guest
    May 28, 2019

    Hello.

    There is a SQL View to query userprofiles (USER_INFO)
    Maybe it could help you to find your profiles

    SELECT * FROM USER_INFO WHERE LOWER(TEXT_DESCRIPTION) LIKE '%jens%'

  • Guest
    May 28, 2019

    This is basic functionality in the ADMIN webinterface.

  • Guest
    May 27, 2019

    Hi Peder

    I know you want this in the 5250 command structure but it is possible to do this today even in the 5250 using IBM i services.

    Unfortunately this would mean you writing an SQL wrapper program to carry out the search and pipe the results back to the screen but it would not be complex.

    That said, I think you could put together a program to do this quite quickly, so you could have what you want quite quickly

    Best wishes SteveB