ArchiveFilter.QueryBlockEx



QueryBlockEx(vValues As Variant,vCalculations As Variant,vPvIDs As Variant,vProjects As Variant) As Boolean

Parameters

vValues As Variant
"Variant" variable for the "QueryBlockEx" method, in order to store a cascaded array which is filled with the filtered variables and the recorded values.

The array is returned by the method, hence the user has only to pass an "Variant" variable.
vCalculations As Variant
"Variant" variable for the "QueryBlockEx" method, in order to store an array of calculation modes, which were utilized by the recorded values.

The array is returned by the method, hence the user has only to pass an "Variant" variable.

Hint: For further information on calculation modes, please have a look at the Calculation property within the "ArchiveVariable" object.
vPvIDs As Variant
"Variant" variable for the "QueryBlockEx" method, in order to store an array of IDs of the corresponding filtered archive variables.

The array is returned by the method, hence the user has only to pass an "Variant" variable.
vProjects As Variant
"Variant" variable for the "QueryBlockEx" method, in order to store an array of project names, where the filter was applied.

The array is returned by the method, hence the user has only to pass an "Variant" variable.
ED
not used
RT
avaliable

Remarks

Like the "QueryBlock" method, the "QueryBlockEx" command initiates the filtering of the data.

The difference between these two methods is, that the "QuerBlockEx" command will also return the project name and the utilized calculation modes (if it is a following archive) in addition to the "QueryBlock" results.

Hint: For further information, please have a look at the QueryBlock part.

Sample

The following example initiates a filtering with the "QueryBlockEx" command and outputs details on the project name and the utilized calculation modes.

ATTENTION: The passed "ArchiveFilter" object has to be initialized beforehand, i.e. filter starttime and endtime, etc.

Public Sub zenOn_ArchiveFilter_QueryBlockEx(ByRef zArvFilter As ArchiveFilter)
	'Declarations
	Dim zPvIDs As Variant
	Dim zValues As Variant
	Dim zProjects As Variant
	Dim zCalculations As Variant
	Dim i As Integer

	'Initiate the filtering
	Debug.Print zArvFilter.QueryBlockEx(zProjects, zPvIDs, zCalculations, zValues)

	'Output every project name
	For i = 0 To UBound(zProjects, 1)
		Debug.Print CStr(zProjects(i))
	Next i

	'Output every calculation mode
	For i = 0 To UBound(zCalculations, 1)
			Debug.Print CStr(zCalculations(i))
	Next i

End Sub

See Also

ArchiveFilter