[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Export the login History

Status
Not open for further replies.
S

Srinivas Panyala

Guest
Hi Refael, Please follow the below steps to generate the report. 1) Login as Administrator 2) Navigate to Rollbase -> Users -> Object Definition -> Reports 3) Click on New Report 4) Select JavaScript report type -> Click on Next 5) Provide some report name 6) Select Content Type as HTML 7) Paste the following code in Header rbv_api.println(" "); rbv_api.println(" "); rbv_api.println(" USR_ID "); rbv_api.println(" LOGIN_TYPE "); rbv_api.println(" START_TIME "); rbv_api.println(" END_TIME "); rbv_api.println(" IP_ADDRESS "); rbv_api.println(" "); 8) Paste the following code in Loop body var loginHistory = rbv_api.selectQuery("SELECT USR_ID,LOGIN_TYPE,START_TIME,END_TIME,IP_ADDRESS FROM $LOGIN where USR_ID =?", 100,{!id}); for(var i=0;i "); for(var j=0;j "+loginHistory[j]+" "); } rbv_api.println(" "); } 9) Paste the following code in Footer rbv_api.println(" "); See the below screenshot for reference. 10) Save the report 11) Preview/Run the report. Sample report Thanks Srinivas

Continue reading...
 
Status
Not open for further replies.
Top