Stored Procedure Host properties

DefaultInstallPath

The location to look for the contents of the Stored procedure zip file.

AVEVA™ Production Management looks into these locations to find the dll contents of the Stored Procedure zip file:

• Citect.Ampla.Public.MSSQL.Data.V200806dll

• Citect.Ampla.Public.MSSQL.Data.V200806XmlSerializers.dll

Example: c:\temp\

StartDateLocalTime

The default start date time to use when nothing is specified.

This is a start date that uses a date time format that is specified in local time.

01/01/2019 11:00:00 AM

EndDateLocalTime

The default end date time to use when no end date time is specified.

This is an end date time that uses a date time format that is specified in local time.

02/02/2019 11:00:00 AM

Fields

The default fields to use when no fields are specified.

Determines column names and in what order.

Field 1, Field 2

Filters

The default filters to use when no filters are specified.

THis is the default filters to use with default fields.

field 1={filter1}, field 2={filter2},

InclusiveDateRange

The Inclusive Date Range parameter calculates how the Start Date and End Date are converted to a sample period.

0=Not inclusive, 1=StartInclusive , 2=EndInclusive, 3=AllInclusive

Username

The AVEVA™ Production Management user name to use as basic security.

AVEVA™ Production Management username

Password

The password for the username.

AVEVA™ Production Management password

ServerName

The default base URL to use for the Web services.

Note: You can enter the security credentials as default values, so that the values for username, password, and server name do not have to be entered each time.

It is important that the base URL ends in a forward slash (/). The default endpoint is added to the default base to make a complete URL.

For example: http://localhost:8889/Ampla/Data/2007/06/Soap11

http://localhost:8889/

SamplePeriod

The default period of time to use in the query. This can be any filterable period definition or date time.

CurrentDay or CurrentWeek

(multiple values separated by space)

ModelFields

The model fields to use when nothing is specified. Specifies which model item property to return and in what order.

Field 1, Field 2

PivotResults

When not specified, the default value is False.

Enter 1 for True to have the Stored Proc pivot results.

0=False, 1=True

ResolveIdentifiers

When not specified, the default value is False.

Enter 1 for True to have the Stored Procedure resolve identifiers.

0=False, 1=True

ViewName

The name of a view to use as default value when nothing is specified.

Standard View

Language

The default language to use when nothing is specified.

en-AU, en-GB, fr-FR