API query SelectXmlDaemonQueue (optimised)

query filter (table tFilter)

tcBusinessFieldName	tcDataType	tcOperator
tfcDaemonQueue.DaemonQueueLog	c	=,>=,>,<>,<=,<,begins,can-do,matches
tfcDaemonQueue.DaemonQueuePriority	i	=,>=,>,<>,<=,<
tfcDaemonQueue.DaemonQueueRef	c	=,>=,>,<>,<=,<,begins,can-do,matches
tfcDaemonQueue.DaemonQueueRefDescription	c	=,>=,>,<>,<=,<,begins,can-do,matches
tfcDaemonQueue.DaemonQueueReqStartDate	t	=,>=,>,<>,<=,<
tfcDaemonQueue.DaemonQueueReqStartTime	i	=,>=,>,<>,<=,<
tfcDaemonQueue.DaemonQueueStatus	c	=,>=,>,<>,<=,<,begins,can-do,matches
tXmlDaemonQueue.XmlDaemonQueueAct	c	=,>=,>,<>,<=,<,begins,can-do,matches
tXmlDaemonQueue.XmlDaemonQueueFileName	c	=,>=,>,<>,<=,<,begins,can-do,matches
tXmlDaemonQueue.XmlDaemonQueueFileOwner	c	=,>=,>,<>,<=,<,begins,can-do,matches
tXmlDaemonQueue.XmlDaemonQueueXmlClassName	c	=,>=,>,<>,<=,<,begins,can-do,matches
tXmlDaemonQueue.XmlDaemonQueueXmlCrtDate	t	=,>=,>,<>,<=,<
tXmlDaemonQueue.XmlDaemonQueueXmlCrtTime	i	=,>=,>,<>,<=,<
tXmlDaemonQueue.XmlDaemonQueueXmlFreeText	c	=,>=,>,<>,<=,<,begins,can-do,matches
tXmlDaemonQueue.XmlDaemonQueueXmlOrigin	c	=,>=,>,<>,<=,<,begins,can-do,matches

query condition

each fcDaemonQueue where

each XmlDaemonQueue (inner-join) where

XmlDaemonQueue.DaemonQueueId = fcDaemonQueue.DaemonQueueId AND

query resultset tqSelectXmlDaemonQueue

field name	data type	db field	description
tiDaemonQueueId	integer	fcDaemonQueue.DaemonQueueId	identifier
tcDaemonQueueLog	character	fcDaemonQueue.DaemonQueueLog	Error Log of this Daemon Request
tiDaemonQueuePriority	integer	fcDaemonQueue.DaemonQueuePriority	defines the sequence of processing requests in a single loop (also see fcdaemon.DaemonNrOfRequestsInLoop)
tcDaemonQueueRef	character	fcDaemonQueue.DaemonQueueRef	internal reference to identify the request (may contain non-displayable ID's)
tcDaemonQueueRefDescription	character	fcDaemonQueue.DaemonQueueRefDescription	displayable reference for identifying the request
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
tcXmlDaemonQueueAct	character	XmlDaemonQueue.XmlDaemonQueueAct	Action code (not to be confused with the activity code) read from the input XML. possible values: SAVE SAVESTORE STORE VALIDATE
tcXmlDaemonQueueFileName	character	XmlDaemonQueue.XmlDaemonQueueFileName	Original file name of the loaded object, excluding folder information. (This file no longer exists.)
tcXmlDaemonQueueFileOwner	character	XmlDaemonQueue.XmlDaemonQueueFileOwner	File Owner
tcXmlDaemonQueueXmlClassName	character	XmlDaemonQueue.XmlDaemonQueueXmlClassName	business component name
ttXmlDaemonQueueXmlCrtDate	date	XmlDaemonQueue.XmlDaemonQueueXmlCrtDate	creation date
tiXmlDaemonQueueXmlCrtTime	integer	XmlDaemonQueue.XmlDaemonQueueXmlCrtTime	creation time
tcXmlDaemonQueueXmlFreeText	character	XmlDaemonQueue.XmlDaemonQueueXmlFreeText	Comments read from the XML input.
tcXmlDaemonQueueXmlOrigin	character	XmlDaemonQueue.XmlDaemonQueueXmlOrigin	Originator code read from the XML input.
fcDaemonQueueCustom	character	calculated	custom fields
XmlDaemonQueueCustom	character	calculated	custom fields
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(fcDaemonQueue),rowid(XmlDaemonQueue)

Internal usage

unused

Sample code: how to call this query through RPCRequestService (QXtend Inbound)

define temp-table ttContext no-undo
    field propertyQualifier as character
    field propertyName as character
    field propertyValue as character
    index entityContext is primary unique
        propertyQualifier
        propertyName
    index propertyQualifier
        propertyQualifier.

define dataset dsContext for ttContext.

define variable vhContextDS as handle no-undo.
define variable vhExceptionDS as handle no-undo.
define variable vhServer as handle no-undo.
define variable vhInputDS as handle no-undo.
define variable vhInputOutputDS as handle no-undo.
define variable vhOutputDS as handle no-undo.
define variable vhParameter as handle no-undo.

/* Create context */
create ttContext.
assign ttContext.propertyName = "programName"
       ttContext.propertyValue = "BXmlDaemonQueue".
create ttContext.
assign ttContext.propertyName = "methodName"
       ttContext.propertyValue = "SelectXmlDaemonQueue".
create ttContext.
assign ttContext.propertyName = "applicationId"
       ttContext.propertyValue = "fin".
create ttContext.
assign ttContext.propertyName = "entity"
       ttContext.propertyValue = "1000".
create ttContext.
assign ttContext.propertyName = "userName"
       ttContext.propertyValue = "mfg".
create ttContext.
assign ttContext.propertyName = "password"
       ttContext.propertyValue = "".

/* Create input dataset */
create dataset vhInputDS.
vhInputDS:read-xmlschema("file", "xml/bxmldaemonqueue.selectxmldaemonqueue.i.xsd", ?).
vhParameter = vhInputDS:get-buffer-handle("tParameterI").
vhParameter:buffer-create().

assign vhParameter::icRange = "A"
       vhParameter::icRowid = ""
       vhParameter::iiRownum = 0
       vhParameter::iiNumber = 5 /* Number of records to read */
       vhParameter::icSortColumns = ""
       vhParameter::ilCountOnly = false
       vhParameter::ilForwardRead = true
       vhParameter::iiMaximumBrowseRecordsToCount = 0.

vhParameter = vhInputDS:get-buffer-handle("tFilter").
vhParameter:buffer-create().

assign vhParameter::<field-name-1> = <field-value-1>
       vhParameter::<field-name-2> = <field-value-2>
       ...

/* Connect the AppServer */
create server vhServer.
vhServer:connect("-URL <appserver-url>").

if not vhServer:connected()
then do:
    message "Could not connect AppServer" view-as alert-box error title "Error".
    return.
end.

/* Run */
assign vhContextDS = dataset dsContext:handle.

run program/rpcrequestservice.p on vhServer
    (input-output dataset-handle vhContextDS by-reference,
           output dataset-handle vhExceptionDS,
     input        dataset-handle vhInputDS by-reference,
     input-output dataset-handle vhInputOutputDS by-reference,
           output dataset-handle vhOutputDS).

/* Handle output however you want, in this example, we dump it to xml */
if valid-handle(vhExceptionDS)
then vhExceptionDS:write-xml("file", "Exceptions.xml", true).

if valid-handle(vhOutputDS)
then vhOutputDS:write-xml("file", "Output.xml", true).

/* Cleanup */
vhServer:disconnect().
assign vhServer = ?.

if valid-handle(vhInputDS)
then delete object vhInputDS.

if valid-handle(vhOutputDS)
then delete object vhOutputDS.

if valid-handle(vhExceptionDS)
then delete object vhExceptionDS.