You can get this done by querying an Oracle Package Function, where the Function returns a pipelined table functionality. The Oracle Pipelined table functions are table functions that return or “pipe” rows back to the calling query, and the query can be simply look like below.

SELECT * FROM <schema>.<API>.<function>(<signature>).

E.g.: SELECT * FROM IFSAPP.Custom_API.Get_Emp_Grades(‘&EMP’)

Within the function, write your own query to generate the result set and return the table rows as a pipelined table. The SQL output then show the returned rows only.

have a read: Pipelined Table Functions (oracle.com)

Another idea:

• If it’s possible, this can be done by using Custom RMB menus, but I’m not sure if it’s convenient. Two menu items on any relevant IFS screen, which perhaps called “Generate EMP GRADE data” and “Run EMP_GRADE QR”, and they do exact as they are named.
• “Generate EMP GRADE data” will run your logic against the selected record and generate the required data into a temp table, or will generate a view dynamically which will return the data you expect.
• “Run EMP_GRADE QR” is simply to execute the quick report which queries the aforementioned temp table \ view.

Hope these help.

Hi,

can you share the IFS mask where you see the Grade info?
Am I rigth that you need a list a summed up values?
How many people with Age x and Grade z?

CU

Michael

Depending on the original data, maybe a pivot wouldgenerate the format you are looking for.

A Practical Guide to Oracle PIVOT By Real-world Examples (oracletutorial.com)