#
#	WSC IKT
#	CCDB - Command and Control Database
#
#	FILE:				dquerymfile_HOMEVENTS.txt
#	DESCRIPTION:		DQUERY definition for CCDB-query HOMEVENTS
#
#	AUTHOR:				Wolfgang Scherer
#	VERSION:			1.0
#	ISSUE:				14.05.2022
#
@querytitle			HOME-Automation-Events
@querydescription	Zeigt HOME-Automation-Events an  und erlaubt bestimmte Bearbeitungen
@group				ADMIN
@tableclass			excelFilterTable
@querytype			function
@function			seqtrans.seqtrans
@title				HOMEVENTS

@decoration.decorate_colcell.5				$CONTROL:saverow:eingabeoptions

~query.tsteps

#
# 0: get total number of records
#
pre_qexpression		this.pagesize = 20;
sql					select count(*) from CCEVENTS
result_varname		cres
post_qexpression	this.numrecs = this.cres.getCellValue(0,0);
					this.startrec = this.numrecs - this.pagesize + 1;

#
# 1: get current part
#
sql					SELECT EVENTID,CONTEXT,EVENT,TIMESTAMP,DATA,'<<save>>' as "SAVE" from CCEVENTS
					UNION
					SELECT '<new>','<new>','<new>','<new>','<new>','<save>'
					LIMIT ::startrec::,::pagesize::
named_params		startrec,pagesize
result_varname		pres
post_qexpression
	this.result = new aux.Result(this.pres);