Table of Contents

Work Order Movement

Table

Database Table Entity On Key 5 Conversions On Key 5 Tables Other Entities stored in same Table
Transaction wm.work_order_movement Work Order Movement

Columns

Property Db Table Db Column Db DataType Nullable Primary Key Joins
CreatedByUserId wm.work_order_movement created_by_user_id bigint False
CreatedByUserCode uam.user code character varying(50) False wm.work_order_movement.created_by_user_id = uam.user.user_id
CreatedByUserFullName uam.user full_name character varying(200) False wm.work_order_movement.created_by_user_id = uam.user.user_id
CreatedOn wm.work_order_movement created_on timestamp without time zone False
PermissionTreeId wm.work_order_movement permission_tree_id bigint False
PermissionTreeCode uam.permission_tree code text False wm.work_order_movement.permission_tree_id = uam.permission_tree.permission_tree_id
PermissionTreeDescription uam.permission_tree description text True wm.work_order_movement.permission_tree_id = uam.permission_tree.permission_tree_id
Id wm.work_order_movement work_order_movement_id bigint False True
Version wm.work_order_movement version integer False
Action wm.work_order_movement action wm.work_order_movement_action False
Direction wm.work_order_movement direction wm.work_order_movement_direction False
WorkOrderId wm.work_order_movement work_order_id bigint False
WorkOrderCode wm.work_order code character varying(50) False wm.work_order_movement.work_order_id = wm.work_order.work_order_id
WorkOrderDescription wm.work_order description character varying(100) False wm.work_order_movement.work_order_id = wm.work_order.work_order_id

Enumerations

Mapping 1

Property Property Type Db Column Db Column Type Db Column Values
Action WorkOrderMovementAction action wm.work_order_movement_action Merge
Split

Mapping 2

Property Property Type Db Column Db Column Type Db Column Values
Direction WorkOrderMovementDirection direction wm.work_order_movement_direction Target
Source

Queries

The list of example Work Order Movement queries can be interpreted using the following legend:

Legend Description
Primary Table Alias The alias for the wm.work_order_movement table in the query
Include References Include (true) or exclude (false) all lookup table joins in the query
Include Permissions Include (true) or exclude (false) the permission table join in the query to enforce or skip row-level security based on the permissions for the user

Query 1

Primary Table Alias Include References Include Permissions
_wom False False 
SELECT
    _wom.created_by_user_id AS "CreatedByUserId",
    _wom.created_on AS "CreatedOn",
    _wom.permission_tree_id AS "PermissionTreeId",
    _wom.work_order_movement_id AS "Id",
    _wom.version AS "Version",
    _wom.action AS "Action",
    _wom.direction AS "Direction",
    _wom.work_order_id AS "WorkOrderId"
FROM
    wm.work_order_movement _wom

Query 2

Primary Table Alias Include References Include Permissions
_wom True False 
SELECT
    _u.user_id AS "CreatedByUserId",
    _u.code AS "CreatedByUserCode",
    _u.full_name AS "CreatedByUserFullName",
    _wom.created_on AS "CreatedOn",
    _pt.permission_tree_id AS "PermissionTreeId",
    _pt.code AS "PermissionTreeCode",
    _pt.description AS "PermissionTreeDescription",
    _wom.work_order_movement_id AS "Id",
    _wom.version AS "Version",
    _wom.action AS "Action",
    _wom.direction AS "Direction",
    _wo.work_order_id AS "WorkOrderId",
    _wo.code AS "WorkOrderCode",
    _wo.description AS "WorkOrderDescription"
FROM
    wm.work_order_movement _wom
    JOIN uam.user _u ON _wom.created_by_user_id = _u.user_id
    JOIN uam.permission_tree _pt ON _wom.permission_tree_id = _pt.permission_tree_id
    JOIN wm.work_order _wo ON _wom.work_order_id = _wo.work_order_id

Query 3

Primary Table Alias Include References Include Permissions
_wom False True
Parameter Name Data Type Value
@permission_user_id Bigint 500000000000
@permission_id Bigint 100120700 
WITH permission_tree_ids AS
(
    SELECT DISTINCT unnest(psd.permission_tree_ids) AS permission_tree_id FROM uam.user_permission up JOIN uam.permission_set_data psd ON up.permission_set_id = psd.permission_set_id WHERE up.user_id = @permission_user_id AND up.permission_id = @permission_id
)
SELECT
    _wom.created_by_user_id AS "CreatedByUserId",
    _wom.created_on AS "CreatedOn",
    _wom.permission_tree_id AS "PermissionTreeId",
    _wom.work_order_movement_id AS "Id",
    _wom.version AS "Version",
    _wom.action AS "Action",
    _wom.direction AS "Direction",
    _wom.work_order_id AS "WorkOrderId",
    _wom.permission_tree_id AS "_wom_permission_tree_id"
FROM
    wm.work_order_movement _wom
    JOIN permission_tree_ids permission_join ON _wom.permission_tree_id = permission_join.permission_tree_id

Query 4

Primary Table Alias Include References Include Permissions
_wom True True
Parameter Name Data Type Value
@permission_user_id Bigint 500000000000
@permission_id Bigint 100120700 
WITH permission_tree_ids AS
(
    SELECT DISTINCT unnest(psd.permission_tree_ids) AS permission_tree_id FROM uam.user_permission up JOIN uam.permission_set_data psd ON up.permission_set_id = psd.permission_set_id WHERE up.user_id = @permission_user_id AND up.permission_id = @permission_id
)
SELECT
    _u.user_id AS "CreatedByUserId",
    _u.code AS "CreatedByUserCode",
    _u.full_name AS "CreatedByUserFullName",
    _wom.created_on AS "CreatedOn",
    _pt.permission_tree_id AS "PermissionTreeId",
    _pt.code AS "PermissionTreeCode",
    _pt.description AS "PermissionTreeDescription",
    _wom.work_order_movement_id AS "Id",
    _wom.version AS "Version",
    _wom.action AS "Action",
    _wom.direction AS "Direction",
    _wo.work_order_id AS "WorkOrderId",
    _wo.code AS "WorkOrderCode",
    _wo.description AS "WorkOrderDescription",
    _wom.permission_tree_id AS "_wom_permission_tree_id",
    _u.permission_tree_id AS "_u_permission_tree_id",
    _wo.permission_tree_id AS "_wo_permission_tree_id"
FROM
    wm.work_order_movement _wom
    JOIN permission_tree_ids permission_join ON _wom.permission_tree_id = permission_join.permission_tree_id
    JOIN uam.user _u ON _wom.created_by_user_id = _u.user_id
    JOIN uam.permission_tree _pt ON _wom.permission_tree_id = _pt.permission_tree_id
    JOIN wm.work_order _wo ON _wom.work_order_id = _wo.work_order_id