Modify the default CLR Stored Procedure parameters
- Last UpdatedJun 24, 2024
- 2 minute read
Required parameters
Location and Module are required parameters. The Stored Procedure is required to contain values for these two settings. These values must be user-specified and cannot be set as default.
For more information on setting default values, see Add and configure a CLR Stored Procedure Host connection.
Modify default values
A good way to minimize the number of parameters you have to pass in is to modify the default values in the SQL Stored Procedure.
It is recommended to modify these default values:
-
User is the AVEVA™ Production Management Username.
-
Password is the AVEVA Production Management Password.
-
Server is the default server URL to use.
http://localhost:8889/
Other useful values to assign are ViewName and InclusiveDateRange.
To modify the default values in Studio, see Add and configure a CLR Stored Procedure Host connection.
Use date ranges in CLR Stored Procedure
You can use date ranges in the SQL Stored Procedure. You can specify date ranges in UTC or Local time depending what version and what parameter you use. Date time parameters have either local time or UTC appended to them.
In Standard:
-
StartDateLocalTime uses Local Time.
-
EndDateLocalTime uses Local Time.
-
SamplePeriod uses UTC time.
If you specify both start and end date times as well as a sample period, the sample period takes priority and the start/end date times are not used.
If the date time parameters have null values, the query searches on all available data. This takes a long time to return results and could have performance implications.
Related topics