Table of Contents

Method FillArrayWithColumn

Namespace
Skyline.DataMiner.Scripting
Assembly
SLManagedScripting.dll

FillArrayWithColumn(int, int, object[], object[], DateTime?)

Sets the specified cells of a column with the provided values.

object FillArrayWithColumn(int tableId, int columnPid, object[] keys, object[] values, DateTime? timeInfo)

Parameters

tableId int

The ID of the table parameter.

columnPid int

The ID of the column parameter.

keys object[]

The primary keys of the rows for which the column has to be updated.

values object[]

The values to set.

timeInfo DateTime?

Timestamp

Returns

object

Remarks

  • Prior to DataMiner 10.1.1 (RN 27995), this method was defined as an SLProtocol extension method in the NotifyProtocol class.
  • This method acts as a wrapper for a NotifyProtocol type 220 NT_FILL_ARRAY_WITH_COLUMN call.
  • In case the values array only contains one value, this value will be used for all specified primary keys.
  • From DataMiner 10.2.9 onwards (RN 33849), if the DateTime.Kind property of timeInfo is unspecified, the timestamp will be handled as local time.

Exceptions

ArgumentException

The length of "primaryKeys" is not equal to the length of "values", and the length of the values array does not equal 1.

FillArrayWithColumn(int, int, object[], object[], DateTime?, bool)

Sets the specified cells of a column with the provided values.

object FillArrayWithColumn(int tableId, int columnPid, object[] keys, object[] values, DateTime? timeInfo, bool useClearAndLeave)

Parameters

tableId int

The ID of the table parameter.

columnPid int

The ID of the column parameter.

keys object[]

The primary keys of the rows for which the column has to be updated.

values object[]

The values to set.

timeInfo DateTime?

Timestamp

useClearAndLeave bool

Indicates to consider the values corresponding with protocol.Clear and protocol.Leave as cell actions instead of an actual cell value.

Returns

object

Remarks

  • This overload is supported from DataMiner 10.4.2 onwards (RN 38153).
  • This method acts as a wrapper for a NotifyProtocol type 220 NT_FILL_ARRAY_WITH_COLUMN call.
  • In case the values array only contains one value, this value will be used for all specified primary keys.
  • If the DateTime.Kind property of timeInfo is unspecified, the timestamp will be handled as local time.

Exceptions

ArgumentException

The length of "primaryKeys" is not equal to the length of "values", and the length of the values array does not equal 1.

FillArrayWithColumn(int, int, object[], object[])

Sets the specified cells of a column with the provided values.

object FillArrayWithColumn(int tableId, int columnPid, object[] keys, object[] values)

Parameters

tableId int

The ID of the table parameter.

columnPid int

The ID of the column parameter.

keys object[]

The primary keys of the rows for which the column has to be updated.

values object[]

The values to set.

Returns

object

Remarks

  • Prior to DataMiner 10.1.1 (RN 27995), this method was defined as an SLProtocol extension method in the NotifyProtocol class.
  • This method acts as a wrapper for a NotifyProtocol type 220 NT_FILL_ARRAY_WITH_COLUMN call.
  • In case the values array only contains one value, this value will be used for all specified primary keys.

FillArrayWithColumn(int, int, object[], object[], bool)

Sets the specified cells of a column with the provided values.

object FillArrayWithColumn(int tableId, int columnPid, object[] keys, object[] values, bool useClearAndLeave)

Parameters

tableId int

The ID of the table parameter.

columnPid int

The ID of the column parameter.

keys object[]

The primary keys of the rows for which the column has to be updated.

values object[]

The values to set.

useClearAndLeave bool

Indicates to consider the values corresponding with protocol.Clear and protocol.Leave as cell actions instead of an actual cell value.

Returns

object

Remarks

  • This overload is supported from DataMiner 10.4.2 onwards (RN 38153).
  • This method acts as a wrapper for a NotifyProtocol type 220 NT_FILL_ARRAY_WITH_COLUMN call.
  • In case the values array only contains one value, this value will be used for all specified primary keys.
Propose changes