#
#		ITSV GmbH
#	CCDB - Command and Control Database
#
#	FILE:		dquermfile_kfodisprepdef.txt
#	DESCRIPTION:	DQUERY definition for CCDB DQUERY "kfodisprepdef"
#
@querytitle							Einen Report-Typ in der KFOQSDB anzeigen
@querydescription
@group								KFOQSDBREP
@attributenames			cfgname:kfodbconfigname
@paramnames				id:string:idoptions
@idoptions				{"labeltext":"Report-ID","typedesc":"eindeutige ID des Reports in der KFOQSDB"}
@querytype				dbselect
@dbconfigname			{{cfgname}}
@sql					select "ID","type","name","role","version","sql",'DELETE'as "Löschen",'UPDATE' as "Speichern",'   ' as "Ergebnis" from "reporttype" where "ID"=::id::
@decoration.decorate_colcell.0			$IDCELL
@decoration.decorate_colcell.1			$TEXTINPUT
@decoration.decorate_colcell.2			$TEXTINPUT
@decoration.decorate_colcell.3			$TEXTINPUT
@decoration.decorate_colcell.4			$TEXTINPUT
@decoration.decorate_colcell.5			$TEXTAREA
@decoration.decorate_colcell.6			$BUTTON:Löschen:delbuttonoptions
@decoration.decorate_colcell.7			$BUTTON:Änderungen speichern:updbuttonoptions
@decoration.decorate_colcell.8			$IDCELL
@delbuttonoptions.action				execrest
@delbuttonoptions.dataname				kfodelrepdef
@delbuttonoptions.resulttocol			8
@delbuttonoptions.parameters			cfgname,id,type,name,role,version
@delbuttonoptions.cfgname_parametername	cfgname
@delbuttonoptions.cfgname_value			{{cfgname}}
@delbuttonoptions.id_parametername		id
@delbuttonoptions.id_fromcol			0
@updbuttonoptions.action				execrest
@updbuttonoptions.dataname				kfoupdrepdef
@updbuttonoptions.parameters			cfgname,id,sql,type,name,role,version
@updbuttonoptions.resulttocol			8
@updbuttonoptions.cfgname_parametername	cfgname
@updbuttonoptions.cfgname_value			{{cfgname}}
@updbuttonoptions.id_parametername		id
@updbuttonoptions.id_fromcol			0
@updbuttonoptions.sql_parametername		repsql
@updbuttonoptions.sql_fromcol			5
@updbuttonoptions.type_parametername	type
@updbuttonoptions.type_fromcol			1
@updbuttonoptions.name_parametername	name
@updbuttonoptions.name_fromcol			2
@updbuttonoptions.role_parametername	role
@updbuttonoptions.role_fromcol			3
@updbuttonoptions.version_parametername	version
@updbuttonoptions.version_fromcol		4