Please provide guidance on How best to implement an Identity Manager search screen to search database table, instead of user attributes within ldap.
I'm sure this has come up before, but can't find anything on it.
Working to develop a solution to search service requests defined by a user by their unique_name, within the fwservices request table. This information is only in the database and not within the user defined attributes or Well Known attribute set of the user object class.
Perhaps this would be an enhancement and / or require manipulating OOTB JAR's within IAM EAR file?
You can always write custom JSP and have a custom search screen.
Thanks, I did some more research on this, but can't find this technical document on this anywhere except here -Is this the procedure you're referring to?
I'm hearing rumors that this is possible via a PXP and screen logicals, but I think it cannot be done, please confirm.
Yes this document shows how to configure custom JSP in the admin task. Now you can write whatever logic you want in the JSP. If you want to connect to external database you can configure it in your JSP and execute SQL queries. It depends what you want to do next after searching against external database.
I want to look up the unique_name within the fwservices_requests table (in the object store) and link to a Request Status Page linked to that unique request.
In IM Object store, fwservices_requests, Unique_name field will be the tracking number for each service request, which will be padded with zero's to make it 8 digits. After inputting the tracking number it should bring up the service request data from object store and present the status of the request on the screen.
Yes you can search unique_name under fwservices_requests table from your custom JSP. I am not sure what "request status" page does. Can you please elaborate on this?
Once you are able to search unique_name from fwservices_requests table then you can provide a hyperlink on custom JSP or put a redirection on custom JSP and pass this unique_name as dynamic parameter to "request status" page. Once IM loads "request status" page with unique_name passed from custom JSP, you should be able to see the status.
Service request status screen is the second screen shot in this post. I've already developed this PX Policy to dig it up and email it based on task session id, but now I want to extend it to use the human readable unique_name in the fwservices_request table. It's an easier tracking number to communicate over the phone etc. This interface will allow both the end user and support to quickly navigate to said service request status by the unique_name number padded with leading zero's to make it 8 digits.
I think you can try custom JSP to search for unique_name from object store and pass it on to request status page. This might give you expected result.
Please confirm whether or not PX Policy solution (can or can't) perform db search and do the same UI redirect as the custom JSP you've proposed.
I looked into it a bit, but here's what I've found there's no way to interact with the screen other than receiving data through lah and using action of display message. If we look up the data with sql statement based on the lah, all we can do is display the message : found record, but no way to redirect user to the view status page, unless we send them an email or possibly put a link on the screen that they click