RequestServicesManager..::..GetQueryResults Method

Gets the collection of query results by query identifier.

Namespace: ServicePRO.Sdk.Windows.Managers
Assembly: ServicePRO.Sdk.Windows (in ServicePRO.Sdk.Windows.dll)

Syntax

public void GetQueryResults(
	string userSessionKey,
	bool isBackgroundRefresh,
	int queryId,
	string sqlStatement,
	double timezoneAdjustmentForWeb,
	bool bFilter,
	bool bProcess,
	int startrow,
	int endrow,
	string orderByClause,
	bool isExporting,
	Action<int, ObservableCollection<stcQueryField>, ObservableCollection<Dictionary<string, Object>>, Exception> callbackAction
)

Public Sub GetQueryResults ( _
	userSessionKey As String, _
	isBackgroundRefresh As Boolean, _
	queryId As Integer, _
	sqlStatement As String, _
	timezoneAdjustmentForWeb As Double, _
	bFilter As Boolean, _
	bProcess As Boolean, _
	startrow As Integer, _
	endrow As Integer, _
	orderByClause As String, _
	isExporting As Boolean, _
	callbackAction As Action(Of Integer, ObservableCollection(Of stcQueryField), ObservableCollection(Of Dictionary(Of String, Object)), Exception) _
)

Parameters

userSessionKey: Type: String
User’s Session Key.
Key property of the User Session Object of type stcSession.
The User Session has to be established by making a call to InitializeSystemAndSession() method in CoreServicesManager class as a first step with using ServicePRO SDK.

isBackgroundRefresh: Type: Boolean
set to true if it's background refresh.

queryId: Type: Int32
The query identifier.

sqlStatement: Type: String
The SQL statement query string.

timezoneAdjustmentForWeb: Type: Double
The timezone adjustment data for web.(obsoleted)

bFilter: Type: Boolean
set to true if apply user defined filter].

bProcess: Type: Boolean
if set to true [b process].

startrow: Type: Int32
The starting row number.

endrow: Type: Int32
The ending row number.

orderByClause: Type: String
The order by clause in query string.

isExporting: Type: Boolean
set to true if exporting requests.(lower performance)

callbackAction: Type: Action<(Of <(<'Int32, ObservableCollection<(Of <(<'stcQueryField>)>)>, ObservableCollection<(Of <(<'Dictionary<(Of <(<'String, Object>)>)>>)>)>, Exception>)>)>
The callback action.

RequestServicesManager..::..GetQueryResults Method

Syntax

Parameters

See Also