###################################
# {{:urlname}}: Inner Master page version
# args: none
# ex: /akc/display?url={{:urlname}}
#     /akc/display?url={{:urlname}}&aspire_output_format=object-xml
###################################

{{:urlname}}=aspire:\\\\reports\\\\{{:modulename}}\\\\{{:htmlfilename}}
{{:urlname}}.dataRequestName={{:urlname}}DataRequest
{{:urlname}}.masterPageRequestName=GetMasterPage
{{:urlname}}.masterPageURL=captestURL2


#To help aspire_output_format=xml
#{{:urlname}}DataRequest.loopnames=abc,xyz

#To eliminate html code tied to empty loops
#{{:urlname}}DataRequest.abc.eliminateLoop=yes
#{{:urlname}}DataRequest.xyz.eliminateLoop=yes

#You need this
request.{{:urlname}}DataRequest.className=com.ai.htmlgen.DBHashTableFormHandler1

#Single Main Request name
request.{{:urlname}}DataRequest.maindatarequest.classname=com.ai.db.com.ai.db.DBRequestExecutor2
request.{{:urlname}}DataRequest.maindatarequest.db=reportsDB
request.{{:urlname}}DataRequest.maindatarequest.stmt=\\\n
select * from sometable\\\n
where 1=1\\\n
and c1=value1

#loop request for {{:loopname}}
request.{{:urlname}}DataRequest.{{:loopname}}.class_request.className=com.ai.htmlgen.GenericTableHandler6
request.{{:urlname}}DataRequest.{{:loopname}}.query_request.className=com.ai.db.DBRequestExecutor2
request.{{:urlname}}DataRequest.{{:loopname}}.query_request.db=reportsDB
request.{{:urlname}}DataRequest.{{:loopname}}.query_request.stmt=sp_getTagsForFolder {folderId}, {profile_user.quote}

#Multiple main request
request.{{:urlname}}DataRequest.className=com.ai.htmlgen.DBHashTableFormHandler1
request.{{:urlname}}DataRequest.maindatarequest.classname=com.ai.db.DBPreTranslateArgsMultiRequestExecutor1
request.{{:urlname}}DataRequest.maindatarequest.db=reportsDB
request.{{:urlname}}DataRequest.maindatarequest.request.1={{:urlname}}DataRequest.Request1Name
request.{{:urlname}}DataRequest.maindatarequest.request={{:urlname}}DataRequest.FinalRequestName

You can also make use this database knowledge folder

If you have permissions you can see and update this template

If you just want to see the template