SI_SUBMITTER Property

This is a String value representing the user name of the person who submitted the job to the APS. Read-Only.

Type

String

Syntax

SELECT

    SI_SCHEDULEINFO.SI_SUBMITTER

FROM

    CI_INFOOBJECTS

WHERE

    SI_ID=ObjectID

The syntax has these parts:

Part	Type	Description
ObjectID	Long	A number that identifies the object you want to retrieve.

Used to access the property from a query result:

QueryResult.Item(Index).SchedulingInfo.Properties.Item("SI_SUBMITTER")

Remarks

If the report has not been scheduled, this entry will be blank.

Example

This example finds the first report in the APS named MyReport.rpt and retrieves certain scheduling information about it, including the submitter's user name and their ID.

<%

On Error Resume Next

'Retrieve InfoStore.

Set IStore = Session("IStore")

'The following line queries for a report named ScheduledReport.rpt.

'Change the value of SI_NAME to the name of a report that has been scheduled.

Set Result=IStore.Query("Select SI_SCHEDULEINFO From CI_INFOOBJECTS Where SI_NAME='ScheduledReport.rpt'")

Dim ReportObject

'Retrieve the first report.

Set ReportObject=Result.Item(1)

Dim SchInfo

'Create an interface to the SchedulingInfo object for the report.

Set SchInfo = ReportObject.SchedulingInfo

'Use the scheduling object to return submitter information.

Response.Write "The user who scheduled this report is: " & SchInfo.Properties("SI_SUBMITTER")& "<br>"

Response.Write " The user's ID is: " & SchInfo.Properties("SI_SUBMITTERID")

%>