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

query filter (table tFilter)

tcBusinessFieldName	tcDataType	tcOperator
icChartCode	c	=
tFRWChart.FRWChartCode	c	=,>=,>,<>,<=,<,begins,can-do,matches

Parameters (internal)

icChartCode

character

query condition

each FRWChart where

FRWChart.FRWChartCode = icChartCode

query resultset tqGetFRWChartByCode

field name	data type	db field	description
tiFRWChart_ID	integer	FRWChart.FRWChart_ID	Record ID
tcFRWChartCode	character	FRWChart.FRWChartCode	Chart
FRWChartCustom	character	calculated	custom fields
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(FRWChart)

Internal usage

QadFinancials

method BReportTree.ApiIsRootNode
method BReportTree.DataLoadByInput