PUIATEXSCH – Return Menu search results
D PUIATEXSCH PR ExtPgm('PUIATEXSCH')
D iUser 128A Const
D iQuery 128A Const
D oError N
D oErrorMsg 256A
This program accepts a search string iQuery and returns all menu items where the item text contains the search string, and that the user has access to. The search results are written into a file ATEXSCHP in QTEMP which Atrium created and cleared ready for use. For compiling, ATEXSCHP can found in the PROFOUNDUI library.
In order to make the search case insensitive, we suggest that you use the sql UPPER() function and use %upper() on the search query parm.