Legacy Workflows

Table Overview

Name	$raw Filters	Description
`workflow`		Lists all Legacy Workflows
`workflow_template`		Lists all Legacy Workflow Templates
`workflow_template_version`		Lists all versions of Legacy Workflow Templates
`stage_run`		Lists all stages for Legacy Workflows

`workflow`

Table Row	Definition	Value Type	Example values (if applicable)	Notes
id	Unique Benchling-prescribed ID for each line item in table	Format dependent on table	wfw_DMcZhu4A	Primary key for a table
source_id	The project or registry that the object's permissions comes from	Foreign key for project.id or registry ID	src_hh9ffHqV	If an object isn't in a project, the permissions will be derived from the Registry
alias	Unique identifier for the workflow, based on prefix and sequential number	Prefix-unique number	WF020
name	Name of object in Benchling	Character varying	Transfection Entry, QC Results, Therapeutic Cell Line, etc
created_at	Created date for object	Timestamp without time zone	2020-06-04T00:11:56.132400
description	Description given to object	Text	"Fermentation Workflow"
status	Status for a request(requestor)	IN_PROGRESS, REQUESTED, COMPLETED, SCHEDULED, CANCELLED	IN_PROGRESS, REQUESTED, COMPLETED, SCHEDULED, CANCELLED
last_stage_completed	Name of last stage entry marked as complete	Text	"Transformation"
last_stage_completed_at	Timestamp of when status of last stage entry was marked as complete	Timestamp without timezone	2019-12-06T23:24:44.885478
workflow_template_version_id	API ID of workflow template used to generate this workflow	Foreign key for workflow_template_version.id	wfwtmplv_0MjnYgSk
url	URL for each object in Benchling	Browser URL	https://demo.benchling.com/#biotech-org/f/lib_J3tmt8BP-Entry%20Namet/etr_gRogHFOb-untitled/edit

`workflow_template`

Table Row	Definition	Value Type	Example values (if applicable)	Notes
id	Unique Benchling-prescribed ID for each line item in table	Format dependent on table	wfwtmpl_w6d11hNb	Primary key for a table
name	Name of object in Benchling	Character Varying	Transfection Entry, QC Results, Therapeutic Cell Line, etc

`workflow_template_version`

Table Row	Definition	Value Type	Example values (if applicable)	Notes
id	Unique Benchling-prescribed ID for each line item in table	Format dependent on table	wfwtmplv_0MjnYgSk	Primary key for a table
version	Version number for template	Integer	1, 3, 65, etc	Auto-incremental when new workflow version is completed
workflow_template_id	Unique ID for workflow TEMPLATE	Foreign key for workflow_template.id	wfwtmpl_w6d11hNb

`stage_run`

Table Row	Definition	Value Type	Example values (if applicable)	Notes
id	Unique Benchling-prescribed ID for each line item in table	Format dependent on table	stgr_OvHALbNC
source_id	The project or registry that the object's permissions comes from	Foreign key for project.id or registry ID	src_hh9ffHqV	If an object isn't in a project, the permissions will be derived from the Registry
name	Name of object in Benchling	Character Varying	Transfection Entry, QC Results, Therapeutic Cell Line, etc
created_at	Created date for object	Timestamp without timezone	2019-12-06T23:24:44.885478
stage_name	Stage name in Benchling	Text	"Transfection"
entry_id	Unique identifier for Entry	Foreign key for entry.id	etr_GtcscEZq
workflow_id	Unique identifier for workflow containing object	Foreign key for workflow.id	wfw_DMcZhu4A
status	Status for a request(requestor)	IN_PROGRESS, REQUESTED, COMPLETED, SCHEDULED, CANCELLED	IN_PROGRESS, REQUESTED, COMPLETED, SCHEDULED, CANCELLED
exp_condition_values	Values available for Stage Experimental Conditions	Text	"Condition": "2"

Updated 3 months ago