I'd like to configure a UDF date field on the user setup record view to display the date a user last logged in. What is the most appropriate field of the table to use to do this, and will the behavior of the table allow for this?
I personally have not done this but it sounds like it would work with a post insert trigger on R5SESSIONS. The column you would want to pull the details from would be SES_USER to match the user and SES_CREATED which is when that user logged in. Hope this helps.
I wonder if you can clarify something for me. It appears the grid the user setup screen is built on is the BSUSER grid. The WHERE clause for that grid references r5users and r5locale but does not reference r5sessions. Will that preclude me from configuring a udf field on the user setup screen to return information from the r5sessions table (last login discussed above)?
I personally have not done this but it sounds like it would work with a post insert trigger on R5SESSIONS. The column you would want to pull the details from would be SES_USER to match the user and SES_CREATED which is when that user logged in. Hope this helps.
I wonder if you can clarify something for me. It appears the grid the user setup screen is built on is the BSUSER grid. The WHERE clause for that grid references r5users and r5locale but does not reference r5sessions. Will that preclude me from configuring a udf field on the user setup screen to return information from the r5sessions table (last login discussed above)?