Hi Mahesh, Can you please share more details on your assumption.
I have some sort of similar requirement where I need to display some set of operator ids in login screen(i.e HTML) before even user login to pega.
Formed the url with Activity name and required parameters and tried below approaches to call an activity(available for prpc:unauthenticated AG) which will return the required operator ids in JSON format.
When we run the html in logged in session both are working fine however when trying in a new browser session unable to call the activity (even though it is available in unauthenticated AG) url call redirected to same login html.
You can definitely query the database via something like an activity. There are many methods from RDB to obj-browse to the various reporting tools, that do that. That will put the data onto the clipboard. From there, you just need to display it. You can call an activity via actions on the UI (click of a button, for instance) and refresh the section where it will show up, so yes, you should be able to configure the system to do what you are asking.