blogsURL=aspire:\\reports\\blogs\\blogs.html blogsURL.formHandlerName=BUFH Request.BUFH.form_handler.class_request.classname\ com.ai.htmlgen.DBHashTableFormHandler1 #main data request.BUFH.maindatarequest.classname=com.ai.db.DBRequestExecutor2 request.BUFH.maindatarequest.db=reportsDB request.BUFH.maindatarequest.stmt=(your-sql-statement) #the loop of public items request.BUFH.publicitemsloop.class_request.className=\ com.ai.htmlgen.GenericTableHandler6 request.BUFH.publicitemsloop.query_request.className=\ com.ai.db.DBRequestExecutor2 request.BUFH.publicitemsloop.query_request.db=reportsDB request.BUFH.publicitemsloop.query_request.stmt=(your-select-statement)
#basics blogsURL=/reports/blogs/blogs.jsp blogsURL.transformType=JSP request.blogsURL.transform.classname=com.ai.jsp.JSPTransform blogsURL.formHandlerName=BUFH #Data definition Request.BUFH.form_handler.class_request.classname=\ com.ai.htmlgen.DBHashTableFormHandler1 #main data request.BUFH.maindatarequest.classname=com.ai.db.DBRequestExecutor2 request.BUFH.maindatarequest.db=reportsDB request.BUFH.maindatarequest.stmt=(your-sql-statement) #the loop of public items request.BUFH.publicitemsloop.class_request.className=\ com.ai.htmlgen.GenericTableHandler6 request.BUFH.publicitemsloop.query_request.className=\ com.ai.db.DBRequestExecutor2 request.BUFH.publicitemsloop.query_request.db=reportsDB request.BUFH.publicitemsloop.query_request.stmt=\ (your-select-statement)
blogsURL=aspire:\\reports\\blogs\\blogs.html blogsURL.formHandlerName=EmptyData request.EmptyData.form_handler.class_request.classname\ com.ai.htmlgen.DBHashTableFormHandler1
#basics blogsURL=/reports/blogs/blogs.jsp blogsURL.transformType=JSP request.blogsURL.transform.classname=com.ai.jsp.JSPTransform blogsURL.formHandlerName=EmptyData #Data definition Request.EmptyData.form_handler.class_request.classname=\ com.ai.htmlgen.DBHashTableFormHandler1
# Move to folder: folderId, reports request.MoveReports.classname=com.ai.db.DBRequestExecutor2 request.MoveReports.query_type=update request.MoveReports.db=reportsDB request.MoveReports.stmt=\ update filed_items \ set folder_id = {folderId} \ where item_id in ({reportIds}) request.MoveReports.redirectURL=\ /akc/servlet/DisplayServlet?url=ShowFiledReportsJSPURL&somearg={abc-arg} request.MoveReports.failureRedirectURL=\ /akc/servlet/DisplayServlet?url=SomeErrorURL&somearg={abc-arg}
# MoveReports(folderId, reports) # Perform a multi-exec request.MoveReports.classname=\ com.ai.db.DBPreTranslateArgsMultiRequestExecutor #Define a database request.MoveReports.query_type=update request.MoveReports.db=reportsDB #Define the pipeline request.MoveReports.request.1=MoveReports1 request.MoveReports.request.2=MoveReports2 #Redirect on successful execution to request.MoveReports.redirectURL=\ /akc/servlet/DisplayServlet?url=ShowFiledReportsJSPURL #Redirect on failure request.MoveReports.failureRedirectURL=\ /akc/servlet/DisplayServlet?url=SomeErrorURL&somearg={abc-arg} #request 1 request.MoveReports1.classname=com.ai.db.DBRequestExecutor2 request.MoveReports1.stmt=some-select-statement #request 2 request.MoveReports2.classname=com.ai.db.DBRequestExecutor2 request.MoveReports2.stmt=\ some-insert-or-delete-or-update-statement request.MoveReports2.query_type=update