[dbo]​.[writeCommItem] stored procedure

@objectId

Y

T_tagIDType, int

The ID number associated with the object.

@time

N

T_GMTtime, int

The time in seconds from Jan 1, 1970 in Greenwich Mean Time (GMT).

@offset

N

T_GMToffset, smallint

The timezone represented in minutes from GMT. For example, Mountain Standard timezone is -420. Mountain Daylight timezone is -360. It is calculated based on the time of the data and the timezone of the meter.

@localTime

N

T_nameType, nvarchar(32)

Either the @localTime or @time parameters must be provided. If both parameters are provided, the system will use the value of @time. This value should be consistent with the @timeFormat that is used.

@timeFormat

N

T_nameType, nvarchar(32)

A string to let the system know how to interpret the @localTime string. The @timeFormat is the format you have used for the @localTime string. The default is '%m/%d/%Y %T'.

Additionally, the following timeFormats are also considered valid:

• '2/22/2021 5AM', '%m/%d/%Y %I'

• '2/22/21 17:32', '%m/%d/%y %R'

• '22/2/01 17:00:00', '%d/%m/%y %T'

• '21/02/22 7:32', '%y/%m/%d %R'

• '21/02/22 7:32', '%Y/%m/%d %R'

@subGroupName

Y

T_nameType, nvarchar(32)

The name of the sub group containing the property that will be updated.

@itemName

Y

T_nameType, nvarchar(32)

The name of the property that will be updated.

@numericValue

N

T_doublePrecisionType, float

The value to which the property should be set. Use @numericValue for numeric properties.

@booleanValue

N

T_booleanType, char(1)

The value to which the property should be set. Use @booleanValue for boolean properties. Valid values for boolean properties are 'Y' or 'N'.

@textValue

N

T_messageType, nvarchar(255)

The value to which the property should be set. Use @textValue for string properties.

@userName

N

T_nameType, nvarchar(32)

The name of the user or system that made the submission.