business logic query GetNextDaemonQueue

Description

Get the next record(s) in the daemon queue for a certain named daemon. Sequence is by the DaemonQueueSequence field

iiDaemonId	integer	ID of the daemon
icDaemonQueueStatus	character	DaemonQueueStatus

each fcDaemonQueue where

fcDaemonQueue.DaemonQueueLockedProcess = 0 and
fcDaemonQueue.DaemonQueueStatus = icDaemonQueueStatus and
fcDaemonQueue.DaemonId = iiDaemonId

fcDaemonQueue.DaemonQueuePriority (ascending)

field name	data type	db field	description
tiDaemonId	integer	fcDaemonQueue.DaemonId	Daemon ID
tiDaemonQueueId	integer	fcDaemonQueue.DaemonQueueId	identifier
tiDaemonQueueLockedProcess	integer	fcDaemonQueue.DaemonQueueLockedProcess	process ID of the daemon process that is handling this request
tiDaemonQueuePriority	integer	fcDaemonQueue.DaemonQueuePriority	defines the sequence of processing requests in a single loop (also see fcdaemon.DaemonNrOfRequestsInLoop)
ttDaemonQueueReqStartDate	date	fcDaemonQueue.DaemonQueueReqStartDate	the request will not be processed before this date and time
tiDaemonQueueReqStartTime	integer	fcDaemonQueue.DaemonQueueReqStartTime	the request will not be processed before this date and time
tcDaemonQueueStatus	character	fcDaemonQueue.DaemonQueueStatus	possible values: WAITING IN-PROCESS PROCESSED-OK PROCESSED-ERROR

BLF

QadFinancials