DriveWorks Pro 18: Write Array To Simple Table [send feedback...]

Write Array To Simple Table

This Specification Task will write Array value results to a Simple Table.

Properties

Property NameDescription
TitleChanges the Title (not the name) of the task.
Array ValueA Table Array value, such as the result of a QueryDataValues function.
Simple Table NameThe name of the DriveWorks Project Simple Table that the Array value will be written to.

Example

When this Task is added the properties are static. To be able to build rules on a static property see How To: Change A Static Property To A Dynamic Property.

Property NameExample RuleExample ResultMeaning
Array ValueSppGetAllTeams()SppGetAllTeams()The function SppGetAllTeams returns an Array with information about Teams in a Group. See SppGetAllTeams for more information.
Simple Table Name"GroupTeamInfo"GroupTeamInfoThis is the name of the Simple Table to write the Array value to.

Example Array

SppGetAllTeams Result Array
{"Team","DisplayName","AllowCapture","CanEditGroupSecurity","CanEditAllSpecifications","Users";"Administrators","Administrators","True","True","True","Admin";"Sales","Sales Team","False","False","False","Sarah|Sam";"Engineers","Engineers","True","False","False","Eddie";"Operations","Ops","False","False","False","Oscar"}

Example Result

TeamDisplayNameAllowCaptureCanEditGroupSecurityCanEditAllSpecificationsUsers
AdministratorsAdministratorsTRUETRUETRUEAdmin
SalesSales TeamFALSEFALSEFALSESarah|Sam
EngineersEngineersTRUEFALSEFALSEEddie
OperationsOpsFALSEFALSEFALSEOscar

Status Outputs

This task supports Status Outputs. These can be used to perform different actions depending on what the status outcome of the task is. For more information see Status Outputs in the Task Node Outputs section of Specification Macros Task Node.

The status output navigation is as follows:

Success

  • Array has been successfully written to the table

Success with Warnings

  • N/A - Should never be fulfilled.

Failed (one of the following occurred).

  • Not a valid table
  • Table name is invalid
  • Generic Failure (Check the specification report)

Table of Contents