akc/news.properties

###################################
# UpdateNewsURL: reportId
###################################
UpdateNewsURL=aspire:\\reports\\news\\chg-news.html
UpdateNewsURL.formHandlerName=updateNewsURLFormHandler
request.updateNewsURLFormHandler.form_handler.class_request.className=com.ai.htmlgen.DBHashTableFormHandler1

request.updateNewsURLFormHandler.maindataRequest.classname=com.ai.db.DBRequestExecutor2
request.updateNewsURLFormHandler.maindataRequest.db=reportsDB
request.updateNewsURLFormHandler.maindataRequest.stmt=\
\
select * from reports \
where report_id = {reportId}

###################################
# NewsURL
###################################
NewsURL=aspire:\\reports\\news\\news.html
NewsURL.formHandlerName=newsURLFormHandler
request.newsURLFormHandler.form_handler.class_request.className=com.ai.htmlgen.DBHashTableFormHandler1
newsURLFormHandler.loopNames=primaryLoop

#
# Reading data from a file to satisfy a loopname called: "works"
# The loop name "works" is a user defined loop name in your html tags file
# Look at the commentary below to see how the same data could be read from a database
#
request.newsURLFormHandler.primaryLoop.class_request.className=com.ai.htmlgen.GenericTableHandler6
request.newsURLFormHandler.primaryLoop.query_request.className=com.ai.db.DBPreTranslateArgsMultiRequestExecutor
request.newsURLFormHandler.primaryLoop.query_request.db=reportsDB
request.newsURLFormHandler.primaryLoop.query_request.request.1=NUFH.GetOrderByClause
request.newsURLFormHandler.primaryLoop.query_request.request=NUFH.GetFolderContents

request.NUFH.GetOrderByClause.classname=com.ai.parts.ValueDecoderPart
request.NUFH.GetOrderByClause.decodeKeyName=order_by_format
request.NUFH.GetOrderByClause.defaultValue=order by r.report_short_name
request.NUFH.GetOrderByClause.translate.news=order by r.last_updated_on desc
request.NUFH.GetOrderByClause.resultName=orderByClause


request.NUFH.GetFolderContents.classname=com.ai.db.DBRequestExecutor2
request.NUFH.GetFolderContents.db=reportsDB
request.NUFH.GetFolderContents.stmt=\
\
select f.folder_name, fi.folder_id, fi.item_id, r.report_short_name, r.report_long_name, r.report_description, r.report_id, r.url, r.last_updated_on \
from filed_items fi \
     ,reports r \
     ,folders f \
where 1=1 \
and fi.item_id = r.report_id \
and f.folder_id = fi.folder_id \
and f.folder_name = {folderName.quote} \
and f.owner_user_id = {ownerUserId.quote} \
{orderByClause.empty}

newsURLFormHandler.primaryLoop.eliminateLoop=yes
request.newsURLFormHandler.primaryLoop.eliminateLoop=yes