project QadFinancials > class BCubeQuery > business logic (internal API) query GetCubesInBuildingStatus (optimised)

query filter (table tFilter)

tcBusinessFieldName	tcDataType	tcOperator
tFRWCube.FRWCubeCode	c	=,>=,>,<>,<=,<,begins,can-do,matches
tFRWCube.FRWCubeStatus	c	=,>=,>,<>,<=,<,begins,can-do,matches

query condition

each FRWCube where

FRWCube.FRWCubeStatus = 'BUILDING'

query resultset tqGetCubesInBuildingStatus

field name	data type	db field	description
tcFRWCubeCode	character	FRWCube.FRWCubeCode	Name
tcFRWCubeStatus	character	FRWCube.FRWCubeStatus	Status
FRWCubeCustom	character	calculated	custom fields
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(FRWCube)

Internal usage

QadFinancials

method BCubeDaemonProcessor.Initialize