Special note

For any latest changes to this data structure see the bottom of the page for any updates based on new builds.

Basics (older builds 20 and below)

###################################
# BlogsURL: ownerUserId, publicitemsloop_controlstring 
###################################
#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)

You can do this in Build 20 and above

###################################
# BlogsURL: ownerUserId, publicitemsloop_controlstring 
###################################
blogsURL=/reports/blogs/blogs.jsp
blogsURL.transformType=JSP

blogsURL.transform.classname=com.ai.jsp.JSPTransform
blogsURL.dataRequestName=BUFH

#Data definition
Request.BUFH.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)

You can reuse data definitions

Create entries for a jsp page

blogsURL=/reports/blogs/blogs.jsp
blogsURL.transformType=JSP
blogsURL.transform.classname=com.ai.jsp.JSPTransform
blogsURL.dataRequestName=EmptyData

Let me postpone defining data for a moment. Now go ahead and create another jsp page

blogsURL1=/reports/blogs/blogs.jsp
blogsURL1.transformType=JSP
blogsURL1.transform.classname=com.ai.jsp.JSPTransform
blogsURL1.dataRequestName=EmptyData

As you can see both the pages are using the same data as they are referring to the same "EmptyData". Let me define this empty data

request.EmptyData.classname=com.ai.htmlgen.DBHashTableFormHandler1

You can have one of these empty data definitions in one of your files and continue to use it for all jsp files that don't have any database inputs. Nevertheless the emptydata datastructure still holds the url data and the session data and the application data.