Regular Asset Monitoring Point Trigger Parameter
Table
Columns
| Property |
Db Table |
Db Column |
Db DataType |
Nullable |
Primary Key |
Joins |
Id |
ampc.asset_monitoring_point_trigger_parameter |
asset_monitoring_point_trigger_parameter_id |
bigint |
False |
True |
|
SequenceNumber |
ampc.asset_monitoring_point_trigger_parameter |
sequence_number |
integer |
True |
|
|
IsInherited |
ampc.asset_monitoring_point_trigger_parameter |
is_inherited |
boolean |
True |
|
|
CreatedByUserId |
ampc.asset_monitoring_point_trigger_parameter |
created_by_user_id |
bigint |
False |
|
|
CreatedByUserCode |
uam.user |
code |
character varying(50) |
False |
|
ampc.asset_monitoring_point_trigger_parameter.created_by_user_id = uam.user.user_id |
CreatedByUserFullName |
uam.user |
full_name |
character varying(200) |
False |
|
ampc.asset_monitoring_point_trigger_parameter.created_by_user_id = uam.user.user_id |
CreatedOn |
ampc.asset_monitoring_point_trigger_parameter |
created_on |
timestamp without time zone |
False |
|
|
ModifiedByUserId |
ampc.asset_monitoring_point_trigger_parameter |
modified_by_user_id |
bigint |
False |
|
|
ModifiedByUserCode |
uam.user |
code |
character varying(50) |
False |
|
ampc.asset_monitoring_point_trigger_parameter.modified_by_user_id = uam.user.user_id |
ModifiedByUserFullName |
uam.user |
full_name |
character varying(200) |
False |
|
ampc.asset_monitoring_point_trigger_parameter.modified_by_user_id = uam.user.user_id |
ModifiedOn |
ampc.asset_monitoring_point_trigger_parameter |
modified_on |
timestamp without time zone |
False |
|
|
Version |
ampc.asset_monitoring_point_trigger_parameter |
version |
integer |
False |
|
|
PermissionTreeId |
ampc.asset_monitoring_point_trigger_parameter |
permission_tree_id |
bigint |
False |
|
|
PermissionTreeCode |
uam.permission_tree |
code |
text |
False |
|
ampc.asset_monitoring_point_trigger_parameter.permission_tree_id = uam.permission_tree.permission_tree_id |
PermissionTreeDescription |
uam.permission_tree |
description |
text |
True |
|
ampc.asset_monitoring_point_trigger_parameter.permission_tree_id = uam.permission_tree.permission_tree_id |
InheritedFromId |
ampc.asset_monitoring_point_trigger_parameter |
inherited_from_id |
bigint |
True |
|
|
InheritedFromMonitoringPointTriggerExpressionParameterId |
ahm.monitoring_point_trigger_expression_parameter |
monitoring_point_trigger_expression_parameter_id |
bigint |
False |
True |
ampc.asset_monitoring_point_trigger_parameter.inherited_from_id = ampc.asset_monitoring_point_trigger_parameter.asset_monitoring_point_trigger_parameter_id Then
ampc.asset_monitoring_point_trigger_parameter.monitoring_point_trigger_expression_parameter_id = ahm.monitoring_point_trigger_expression_parameter.monitoring_point_trigger_expression_parameter_id |
InheritedFromMonitoringPointTriggerExpressionParameterParameterName |
ahm.monitoring_point_trigger_expression_parameter |
parameter_name |
character varying(50) |
False |
|
ampc.asset_monitoring_point_trigger_parameter.inherited_from_id = ampc.asset_monitoring_point_trigger_parameter.asset_monitoring_point_trigger_parameter_id Then
ampc.asset_monitoring_point_trigger_parameter.monitoring_point_trigger_expression_parameter_id = ahm.monitoring_point_trigger_expression_parameter.monitoring_point_trigger_expression_parameter_id |
InheritedFromMonitoringPointTriggerExpressionParameterMonitoringPointTriggerExpressionId |
ahm.monitoring_point_trigger_expression |
monitoring_point_trigger_expression_id |
bigint |
False |
True |
ampc.asset_monitoring_point_trigger_parameter.inherited_from_id = ampc.asset_monitoring_point_trigger_parameter.asset_monitoring_point_trigger_parameter_id Then
ampc.asset_monitoring_point_trigger_parameter.monitoring_point_trigger_expression_parameter_id = ahm.monitoring_point_trigger_expression_parameter.monitoring_point_trigger_expression_parameter_id Then
ahm.monitoring_point_trigger_expression_parameter.monitoring_point_trigger_expression_id = ahm.monitoring_point_trigger_expression.monitoring_point_trigger_expression_id |
InheritedFromMonitoringPointTriggerExpressionParameterMonitoringPointTriggerExpressionDescription |
ahm.monitoring_point_trigger_expression |
description |
character varying(100) |
False |
|
ampc.asset_monitoring_point_trigger_parameter.inherited_from_id = ampc.asset_monitoring_point_trigger_parameter.asset_monitoring_point_trigger_parameter_id Then
ampc.asset_monitoring_point_trigger_parameter.monitoring_point_trigger_expression_parameter_id = ahm.monitoring_point_trigger_expression_parameter.monitoring_point_trigger_expression_parameter_id Then
ahm.monitoring_point_trigger_expression_parameter.monitoring_point_trigger_expression_id = ahm.monitoring_point_trigger_expression.monitoring_point_trigger_expression_id |
InheritedFromMonitoringPointTriggerExpressionParameterMonitoringPointTriggerExpressionExpression |
ahm.monitoring_point_trigger_expression |
expression |
text |
True |
|
ampc.asset_monitoring_point_trigger_parameter.inherited_from_id = ampc.asset_monitoring_point_trigger_parameter.asset_monitoring_point_trigger_parameter_id Then
ampc.asset_monitoring_point_trigger_parameter.monitoring_point_trigger_expression_parameter_id = ahm.monitoring_point_trigger_expression_parameter.monitoring_point_trigger_expression_parameter_id Then
ahm.monitoring_point_trigger_expression_parameter.monitoring_point_trigger_expression_id = ahm.monitoring_point_trigger_expression.monitoring_point_trigger_expression_id |
InheritedFromMonitoringPointTriggerExpressionParameterMonitoringPointTriggerExpressionMonitoringPointTriggerId |
ahm.monitoring_point_trigger |
monitoring_point_trigger_id |
bigint |
False |
True |
ampc.asset_monitoring_point_trigger_parameter.inherited_from_id = ampc.asset_monitoring_point_trigger_parameter.asset_monitoring_point_trigger_parameter_id Then
ampc.asset_monitoring_point_trigger_parameter.monitoring_point_trigger_expression_parameter_id = ahm.monitoring_point_trigger_expression_parameter.monitoring_point_trigger_expression_parameter_id Then
ahm.monitoring_point_trigger_expression_parameter.monitoring_point_trigger_expression_id = ahm.monitoring_point_trigger_expression.monitoring_point_trigger_expression_id Then
ahm.monitoring_point_trigger_expression.monitoring_point_trigger_id = ahm.monitoring_point_trigger.monitoring_point_trigger_id |
InheritedFromMonitoringPointTriggerExpressionParameterMonitoringPointTriggerExpressionMonitoringPointTriggerCode |
ahm.monitoring_point_trigger |
code |
character varying(50) |
False |
|
ampc.asset_monitoring_point_trigger_parameter.inherited_from_id = ampc.asset_monitoring_point_trigger_parameter.asset_monitoring_point_trigger_parameter_id Then
ampc.asset_monitoring_point_trigger_parameter.monitoring_point_trigger_expression_parameter_id = ahm.monitoring_point_trigger_expression_parameter.monitoring_point_trigger_expression_parameter_id Then
ahm.monitoring_point_trigger_expression_parameter.monitoring_point_trigger_expression_id = ahm.monitoring_point_trigger_expression.monitoring_point_trigger_expression_id Then
ahm.monitoring_point_trigger_expression.monitoring_point_trigger_id = ahm.monitoring_point_trigger.monitoring_point_trigger_id |
InheritedFromMonitoringPointTriggerExpressionParameterMonitoringPointTriggerExpressionMonitoringPointTriggerDescription |
ahm.monitoring_point_trigger |
description |
character varying(100) |
False |
|
ampc.asset_monitoring_point_trigger_parameter.inherited_from_id = ampc.asset_monitoring_point_trigger_parameter.asset_monitoring_point_trigger_parameter_id Then
ampc.asset_monitoring_point_trigger_parameter.monitoring_point_trigger_expression_parameter_id = ahm.monitoring_point_trigger_expression_parameter.monitoring_point_trigger_expression_parameter_id Then
ahm.monitoring_point_trigger_expression_parameter.monitoring_point_trigger_expression_id = ahm.monitoring_point_trigger_expression.monitoring_point_trigger_expression_id Then
ahm.monitoring_point_trigger_expression.monitoring_point_trigger_id = ahm.monitoring_point_trigger.monitoring_point_trigger_id |
MonitoringPointId |
ampc.asset_monitoring_point_trigger_parameter |
monitoring_point_id |
bigint |
True |
|
|
MonitoringPointCode |
ahm.monitoring_point |
code |
character varying(50) |
False |
|
ampc.asset_monitoring_point_trigger_parameter.monitoring_point_id = ahm.monitoring_point.monitoring_point_id |
MonitoringPointDescription |
ahm.monitoring_point |
description |
character varying(100) |
False |
|
ampc.asset_monitoring_point_trigger_parameter.monitoring_point_id = ahm.monitoring_point.monitoring_point_id |
MonitoringPointTriggerExpressionParameterId |
ampc.asset_monitoring_point_trigger_parameter |
monitoring_point_trigger_expression_parameter_id |
bigint |
False |
|
|
MonitoringPointTriggerExpressionParameterParameterType |
ahm.monitoring_point_trigger_expression_parameter |
parameter_type |
ahm.monitoring_point_trigger_expression_parameter_type |
False |
|
ampc.asset_monitoring_point_trigger_parameter.monitoring_point_trigger_expression_parameter_id = ahm.monitoring_point_trigger_expression_parameter.monitoring_point_trigger_expression_parameter_id |
MonitoringPointTriggerExpressionParameterParameterName |
ahm.monitoring_point_trigger_expression_parameter |
parameter_name |
character varying(50) |
False |
|
ampc.asset_monitoring_point_trigger_parameter.monitoring_point_trigger_expression_parameter_id = ahm.monitoring_point_trigger_expression_parameter.monitoring_point_trigger_expression_parameter_id |
MonitoringPointTriggerExpressionParameterMonitoringPointTriggerExpressionId |
ahm.monitoring_point_trigger_expression |
monitoring_point_trigger_expression_id |
bigint |
False |
True |
ampc.asset_monitoring_point_trigger_parameter.monitoring_point_trigger_expression_parameter_id = ahm.monitoring_point_trigger_expression_parameter.monitoring_point_trigger_expression_parameter_id Then
ahm.monitoring_point_trigger_expression_parameter.monitoring_point_trigger_expression_id = ahm.monitoring_point_trigger_expression.monitoring_point_trigger_expression_id |
MonitoringPointTriggerExpressionParameterMonitoringPointTriggerExpressionDescription |
ahm.monitoring_point_trigger_expression |
description |
character varying(100) |
False |
|
ampc.asset_monitoring_point_trigger_parameter.monitoring_point_trigger_expression_parameter_id = ahm.monitoring_point_trigger_expression_parameter.monitoring_point_trigger_expression_parameter_id Then
ahm.monitoring_point_trigger_expression_parameter.monitoring_point_trigger_expression_id = ahm.monitoring_point_trigger_expression.monitoring_point_trigger_expression_id |
MonitoringPointTriggerExpressionParameterMonitoringPointTriggerExpressionExpression |
ahm.monitoring_point_trigger_expression |
expression |
text |
True |
|
ampc.asset_monitoring_point_trigger_parameter.monitoring_point_trigger_expression_parameter_id = ahm.monitoring_point_trigger_expression_parameter.monitoring_point_trigger_expression_parameter_id Then
ahm.monitoring_point_trigger_expression_parameter.monitoring_point_trigger_expression_id = ahm.monitoring_point_trigger_expression.monitoring_point_trigger_expression_id |
MonitoringPointTriggerExpressionParameterMonitoringPointTriggerExpressionMonitoringPointTriggerId |
ahm.monitoring_point_trigger |
monitoring_point_trigger_id |
bigint |
False |
True |
ampc.asset_monitoring_point_trigger_parameter.monitoring_point_trigger_expression_parameter_id = ahm.monitoring_point_trigger_expression_parameter.monitoring_point_trigger_expression_parameter_id Then
ahm.monitoring_point_trigger_expression_parameter.monitoring_point_trigger_expression_id = ahm.monitoring_point_trigger_expression.monitoring_point_trigger_expression_id Then
ahm.monitoring_point_trigger_expression.monitoring_point_trigger_id = ahm.monitoring_point_trigger.monitoring_point_trigger_id |
MonitoringPointTriggerExpressionParameterMonitoringPointTriggerExpressionMonitoringPointTriggerCode |
ahm.monitoring_point_trigger |
code |
character varying(50) |
False |
|
ampc.asset_monitoring_point_trigger_parameter.monitoring_point_trigger_expression_parameter_id = ahm.monitoring_point_trigger_expression_parameter.monitoring_point_trigger_expression_parameter_id Then
ahm.monitoring_point_trigger_expression_parameter.monitoring_point_trigger_expression_id = ahm.monitoring_point_trigger_expression.monitoring_point_trigger_expression_id Then
ahm.monitoring_point_trigger_expression.monitoring_point_trigger_id = ahm.monitoring_point_trigger.monitoring_point_trigger_id |
MonitoringPointTriggerExpressionParameterMonitoringPointTriggerExpressionMonitoringPointTriggerDescription |
ahm.monitoring_point_trigger |
description |
character varying(100) |
False |
|
ampc.asset_monitoring_point_trigger_parameter.monitoring_point_trigger_expression_parameter_id = ahm.monitoring_point_trigger_expression_parameter.monitoring_point_trigger_expression_parameter_id Then
ahm.monitoring_point_trigger_expression_parameter.monitoring_point_trigger_expression_id = ahm.monitoring_point_trigger_expression.monitoring_point_trigger_expression_id Then
ahm.monitoring_point_trigger_expression.monitoring_point_trigger_id = ahm.monitoring_point_trigger.monitoring_point_trigger_id |
MonitoringPointTriggerExpressionParameterMonitoringPointTypeId |
ahm.monitoring_point_type |
monitoring_point_type_id |
bigint |
False |
True |
ampc.asset_monitoring_point_trigger_parameter.monitoring_point_trigger_expression_parameter_id = ahm.monitoring_point_trigger_expression_parameter.monitoring_point_trigger_expression_parameter_id Then
ahm.monitoring_point_trigger_expression_parameter.monitoring_point_type_id = ahm.monitoring_point_type.monitoring_point_type_id |
MonitoringPointTriggerExpressionParameterMonitoringPointTypeCode |
ahm.monitoring_point_type |
code |
character varying(50) |
False |
|
ampc.asset_monitoring_point_trigger_parameter.monitoring_point_trigger_expression_parameter_id = ahm.monitoring_point_trigger_expression_parameter.monitoring_point_trigger_expression_parameter_id Then
ahm.monitoring_point_trigger_expression_parameter.monitoring_point_type_id = ahm.monitoring_point_type.monitoring_point_type_id |
MonitoringPointTriggerExpressionParameterMonitoringPointTypeDescription |
ahm.monitoring_point_type |
description |
character varying(100) |
False |
|
ampc.asset_monitoring_point_trigger_parameter.monitoring_point_trigger_expression_parameter_id = ahm.monitoring_point_trigger_expression_parameter.monitoring_point_trigger_expression_parameter_id Then
ahm.monitoring_point_trigger_expression_parameter.monitoring_point_type_id = ahm.monitoring_point_type.monitoring_point_type_id |
Notes |
ampc.asset_monitoring_point_trigger_parameter |
notes |
text |
True |
|
|
ParameterValue |
ampc.asset_monitoring_point_trigger_parameter |
parameter_value |
system.dynamic_value |
True |
|
|
RegularAssetId |
ampc.asset_monitoring_point_trigger_parameter |
asset_id |
bigint |
True |
|
|
RegularAssetCode |
ampc.asset |
code |
character varying(50) |
False |
|
ampc.asset_monitoring_point_trigger_parameter.asset_id = ampc.asset.asset_id |
RegularAssetDescription |
ampc.asset |
description |
character varying(100) |
False |
|
ampc.asset_monitoring_point_trigger_parameter.asset_id = ampc.asset.asset_id |
Enumerations
Mapping 1
| Property |
Property Type |
Db Column |
Db Column Type |
Db Column Values |
| MonitoringPointTriggerExpressionParameterParameterType |
MonitoringPointTriggerExpressionParameterType |
parameter_type |
ahm.monitoring_point_trigger_expression_parameter_type |
MonitoringPoint
Static
Entity
|
Composites
Mapping 1
| Property |
Property Type |
Db Column |
Db Column Type |
| ParameterValue |
DbDynamicValue |
parameter_value |
system.dynamic_value |
| Composite Property |
Db Composite Column |
Property Type |
Type |
type |
String
Email
Integer
Long
Float
Currency
DateTime
Date
Time
Duration
Boolean
|
Value |
value |
String |
Queries
The list of example Regular Asset Monitoring Point Trigger Parameter queries can be interpreted using the following legend:
| Legend |
Description |
| Primary Table Alias |
The alias for the ampc.asset_monitoring_point_trigger_parameter 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 |
_amptp |
False |
False |
SELECT
_amptp.asset_monitoring_point_trigger_parameter_id AS "Id",
_amptp.sequence_number AS "SequenceNumber",
_amptp.is_inherited AS "IsInherited",
_amptp.created_by_user_id AS "CreatedByUserId",
_amptp.created_on AS "CreatedOn",
_amptp.modified_by_user_id AS "ModifiedByUserId",
_amptp.modified_on AS "ModifiedOn",
_amptp.version AS "Version",
_amptp.permission_tree_id AS "PermissionTreeId",
_amptp.inherited_from_id AS "InheritedFromId",
_amptp.monitoring_point_id AS "MonitoringPointId",
_amptp.monitoring_point_trigger_expression_parameter_id AS "MonitoringPointTriggerExpressionParameterId",
_amptp.notes AS "Notes",
_amptp.parameter_value AS "ParameterValue",
_amptp.asset_id AS "RegularAssetId"
FROM
ampc.asset_monitoring_point_trigger_parameter _amptp
Query 2
| Primary Table Alias |
Include References |
Include Permissions |
_amptp |
True |
False |
SELECT
_amptp.asset_monitoring_point_trigger_parameter_id AS "Id",
_amptp.sequence_number AS "SequenceNumber",
_amptp.is_inherited AS "IsInherited",
_u.user_id AS "CreatedByUserId",
_u.code AS "CreatedByUserCode",
_u.full_name AS "CreatedByUserFullName",
_amptp.created_on AS "CreatedOn",
_u1.user_id AS "ModifiedByUserId",
_u1.code AS "ModifiedByUserCode",
_u1.full_name AS "ModifiedByUserFullName",
_amptp.modified_on AS "ModifiedOn",
_amptp.version AS "Version",
_pt.permission_tree_id AS "PermissionTreeId",
_pt.code AS "PermissionTreeCode",
_pt.description AS "PermissionTreeDescription",
_amptp1.asset_monitoring_point_trigger_parameter_id AS "InheritedFromId",
_amptp1.monitoring_point_trigger_expression_parameter_id AS "InheritedFromMonitoringPointTriggerExpressionParameter",
_mptep.monitoring_point_trigger_expression_parameter_id AS "InheritedFromMonitoringPointTriggerExpressionParameterId",
_mptep.parameter_name AS "IFromMonitoringPointTriggerExpressionParameterParameterName",
_mptep.monitoring_point_trigger_expression_id AS "IFMPTExpressionParameterMonitoringPointTriggerExpression",
_mpte.monitoring_point_trigger_expression_id AS "IFMPTExpressionParameterMonitoringPointTriggerExpressionId",
_mpte.description AS "IFMPTEParameterMonitoringPointTriggerExpressionDescription",
_mpte.expression AS "IFMPTEParameterMonitoringPointTriggerExpressionExpression",
_mpte.monitoring_point_trigger_id AS "IFMPTEPMPointTriggerExpressionMonitoringPointTrigger",
_mpt.monitoring_point_trigger_id AS "IFMPTEPMPointTriggerExpressionMonitoringPointTriggerId",
_mpt.code AS "IFMPTEPMPointTriggerExpressionMonitoringPointTriggerCode",
_mpt.description AS "IFMPTEPMPTriggerExpressionMonitoringPointTriggerDescription",
_mp.monitoring_point_id AS "MonitoringPointId",
_mp.code AS "MonitoringPointCode",
_mp.description AS "MonitoringPointDescription",
_mptep1.monitoring_point_trigger_expression_parameter_id AS "MonitoringPointTriggerExpressionParameterId",
_mptep1.parameter_type AS "MonitoringPointTriggerExpressionParameterParameterType",
_mptep1.parameter_name AS "MonitoringPointTriggerExpressionParameterParameterName",
_mptep1.monitoring_point_trigger_expression_id AS "MPTriggerExpressionParameterMonitoringPointTriggerExpression",
_mpte1.monitoring_point_trigger_expression_id AS "MPTExpressionParameterMonitoringPointTriggerExpressionId",
_mpte1.description AS "MPTEParameterMonitoringPointTriggerExpressionDescription",
_mpte1.expression AS "MPTEParameterMonitoringPointTriggerExpressionExpression",
_mpte1.monitoring_point_trigger_id AS "MPTEPMonitoringPointTriggerExpressionMonitoringPointTrigger",
_mpt1.monitoring_point_trigger_id AS "MPTEPMPointTriggerExpressionMonitoringPointTriggerId",
_mpt1.code AS "MPTEPMPointTriggerExpressionMonitoringPointTriggerCode",
_mpt1.description AS "MPTEPMPTriggerExpressionMonitoringPointTriggerDescription",
_mptep1.monitoring_point_type_id AS "MonitoringPointTriggerExpressionParameterMonitoringPointType",
_mpt2.monitoring_point_type_id AS "MPointTriggerExpressionParameterMonitoringPointTypeId",
_mpt2.code AS "MPointTriggerExpressionParameterMonitoringPointTypeCode",
_mpt2.description AS "MPTriggerExpressionParameterMonitoringPointTypeDescription",
_amptp.notes AS "Notes",
_amptp.parameter_value AS "ParameterValue",
_a.asset_id AS "RegularAssetId",
_a.code AS "RegularAssetCode",
_a.description AS "RegularAssetDescription"
FROM
ampc.asset_monitoring_point_trigger_parameter _amptp
JOIN uam.user _u ON _amptp.created_by_user_id = _u.user_id
JOIN uam.user _u1 ON _amptp.modified_by_user_id = _u1.user_id
JOIN uam.permission_tree _pt ON _amptp.permission_tree_id = _pt.permission_tree_id
LEFT JOIN ampc.asset_monitoring_point_trigger_parameter _amptp1 ON _amptp.inherited_from_id = _amptp1.asset_monitoring_point_trigger_parameter_id
LEFT JOIN ahm.monitoring_point_trigger_expression_parameter _mptep ON _amptp1.monitoring_point_trigger_expression_parameter_id = _mptep.monitoring_point_trigger_expression_parameter_id
LEFT JOIN ahm.monitoring_point_trigger_expression _mpte ON _mptep.monitoring_point_trigger_expression_id = _mpte.monitoring_point_trigger_expression_id
LEFT JOIN ahm.monitoring_point_trigger _mpt ON _mpte.monitoring_point_trigger_id = _mpt.monitoring_point_trigger_id
LEFT JOIN ahm.monitoring_point _mp ON _amptp.monitoring_point_id = _mp.monitoring_point_id
JOIN ahm.monitoring_point_trigger_expression_parameter _mptep1 ON _amptp.monitoring_point_trigger_expression_parameter_id = _mptep1.monitoring_point_trigger_expression_parameter_id
JOIN ahm.monitoring_point_trigger_expression _mpte1 ON _mptep1.monitoring_point_trigger_expression_id = _mpte1.monitoring_point_trigger_expression_id
JOIN ahm.monitoring_point_trigger _mpt1 ON _mpte1.monitoring_point_trigger_id = _mpt1.monitoring_point_trigger_id
LEFT JOIN ahm.monitoring_point_type _mpt2 ON _mptep1.monitoring_point_type_id = _mpt2.monitoring_point_type_id
JOIN ampc.asset _a ON _amptp.asset_id = _a.asset_id
Query 3
| Primary Table Alias |
Include References |
Include Permissions |
_amptp |
False |
True |
| Parameter Name |
Data Type |
Value |
@permission_user_id |
Bigint |
500000000000 |
@permission_id |
Bigint |
60800 |
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
_amptp.asset_monitoring_point_trigger_parameter_id AS "Id",
_amptp.sequence_number AS "SequenceNumber",
_amptp.is_inherited AS "IsInherited",
_amptp.created_by_user_id AS "CreatedByUserId",
_amptp.created_on AS "CreatedOn",
_amptp.modified_by_user_id AS "ModifiedByUserId",
_amptp.modified_on AS "ModifiedOn",
_amptp.version AS "Version",
_amptp.permission_tree_id AS "PermissionTreeId",
_amptp.inherited_from_id AS "InheritedFromId",
_amptp.monitoring_point_id AS "MonitoringPointId",
_amptp.monitoring_point_trigger_expression_parameter_id AS "MonitoringPointTriggerExpressionParameterId",
_amptp.notes AS "Notes",
_amptp.parameter_value AS "ParameterValue",
_amptp.asset_id AS "RegularAssetId",
_amptp.permission_tree_id AS "_amptp_permission_tree_id"
FROM
ampc.asset_monitoring_point_trigger_parameter _amptp
JOIN permission_tree_ids permission_join ON _amptp.permission_tree_id = permission_join.permission_tree_id
Query 4
| Primary Table Alias |
Include References |
Include Permissions |
_amptp |
True |
True |
| Parameter Name |
Data Type |
Value |
@permission_user_id |
Bigint |
500000000000 |
@permission_id |
Bigint |
60800 |
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
_amptp.asset_monitoring_point_trigger_parameter_id AS "Id",
_amptp.sequence_number AS "SequenceNumber",
_amptp.is_inherited AS "IsInherited",
_u.user_id AS "CreatedByUserId",
_u.code AS "CreatedByUserCode",
_u.full_name AS "CreatedByUserFullName",
_amptp.created_on AS "CreatedOn",
_u1.user_id AS "ModifiedByUserId",
_u1.code AS "ModifiedByUserCode",
_u1.full_name AS "ModifiedByUserFullName",
_amptp.modified_on AS "ModifiedOn",
_amptp.version AS "Version",
_pt.permission_tree_id AS "PermissionTreeId",
_pt.code AS "PermissionTreeCode",
_pt.description AS "PermissionTreeDescription",
_amptp1.asset_monitoring_point_trigger_parameter_id AS "InheritedFromId",
_amptp1.monitoring_point_trigger_expression_parameter_id AS "InheritedFromMonitoringPointTriggerExpressionParameter",
_mptep.monitoring_point_trigger_expression_parameter_id AS "InheritedFromMonitoringPointTriggerExpressionParameterId",
_mptep.parameter_name AS "IFromMonitoringPointTriggerExpressionParameterParameterName",
_mptep.monitoring_point_trigger_expression_id AS "IFMPTExpressionParameterMonitoringPointTriggerExpression",
_mpte.monitoring_point_trigger_expression_id AS "IFMPTExpressionParameterMonitoringPointTriggerExpressionId",
_mpte.description AS "IFMPTEParameterMonitoringPointTriggerExpressionDescription",
_mpte.expression AS "IFMPTEParameterMonitoringPointTriggerExpressionExpression",
_mpte.monitoring_point_trigger_id AS "IFMPTEPMPointTriggerExpressionMonitoringPointTrigger",
_mpt.monitoring_point_trigger_id AS "IFMPTEPMPointTriggerExpressionMonitoringPointTriggerId",
_mpt.code AS "IFMPTEPMPointTriggerExpressionMonitoringPointTriggerCode",
_mpt.description AS "IFMPTEPMPTriggerExpressionMonitoringPointTriggerDescription",
_mp.monitoring_point_id AS "MonitoringPointId",
_mp.code AS "MonitoringPointCode",
_mp.description AS "MonitoringPointDescription",
_mptep1.monitoring_point_trigger_expression_parameter_id AS "MonitoringPointTriggerExpressionParameterId",
_mptep1.parameter_type AS "MonitoringPointTriggerExpressionParameterParameterType",
_mptep1.parameter_name AS "MonitoringPointTriggerExpressionParameterParameterName",
_mptep1.monitoring_point_trigger_expression_id AS "MPTriggerExpressionParameterMonitoringPointTriggerExpression",
_mpte1.monitoring_point_trigger_expression_id AS "MPTExpressionParameterMonitoringPointTriggerExpressionId",
_mpte1.description AS "MPTEParameterMonitoringPointTriggerExpressionDescription",
_mpte1.expression AS "MPTEParameterMonitoringPointTriggerExpressionExpression",
_mpte1.monitoring_point_trigger_id AS "MPTEPMonitoringPointTriggerExpressionMonitoringPointTrigger",
_mpt1.monitoring_point_trigger_id AS "MPTEPMPointTriggerExpressionMonitoringPointTriggerId",
_mpt1.code AS "MPTEPMPointTriggerExpressionMonitoringPointTriggerCode",
_mpt1.description AS "MPTEPMPTriggerExpressionMonitoringPointTriggerDescription",
_mptep1.monitoring_point_type_id AS "MonitoringPointTriggerExpressionParameterMonitoringPointType",
_mpt2.monitoring_point_type_id AS "MPointTriggerExpressionParameterMonitoringPointTypeId",
_mpt2.code AS "MPointTriggerExpressionParameterMonitoringPointTypeCode",
_mpt2.description AS "MPTriggerExpressionParameterMonitoringPointTypeDescription",
_amptp.notes AS "Notes",
_amptp.parameter_value AS "ParameterValue",
_a.asset_id AS "RegularAssetId",
_a.code AS "RegularAssetCode",
_a.description AS "RegularAssetDescription",
_amptp.permission_tree_id AS "_amptp_permission_tree_id",
_u.permission_tree_id AS "_u_permission_tree_id",
_u1.permission_tree_id AS "_u1_permission_tree_id",
_amptp1.permission_tree_id AS "_amptp1_permission_tree_id",
_mptep.permission_tree_id AS "_mptep_permission_tree_id",
_mpte.permission_tree_id AS "_mpte_permission_tree_id",
_mpt.permission_tree_id AS "_mpt_permission_tree_id",
_mp.permission_tree_id AS "_mp_permission_tree_id",
_mptep1.permission_tree_id AS "_mptep1_permission_tree_id",
_mpte1.permission_tree_id AS "_mpte1_permission_tree_id",
_mpt1.permission_tree_id AS "_mpt1_permission_tree_id",
_mpt2.permission_tree_id AS "_mpt2_permission_tree_id",
_a.permission_tree_id AS "_a_permission_tree_id"
FROM
ampc.asset_monitoring_point_trigger_parameter _amptp
JOIN permission_tree_ids permission_join ON _amptp.permission_tree_id = permission_join.permission_tree_id
JOIN uam.user _u ON _amptp.created_by_user_id = _u.user_id
JOIN uam.user _u1 ON _amptp.modified_by_user_id = _u1.user_id
JOIN uam.permission_tree _pt ON _amptp.permission_tree_id = _pt.permission_tree_id
LEFT JOIN ampc.asset_monitoring_point_trigger_parameter _amptp1 ON _amptp.inherited_from_id = _amptp1.asset_monitoring_point_trigger_parameter_id
LEFT JOIN ahm.monitoring_point_trigger_expression_parameter _mptep ON _amptp1.monitoring_point_trigger_expression_parameter_id = _mptep.monitoring_point_trigger_expression_parameter_id
LEFT JOIN ahm.monitoring_point_trigger_expression _mpte ON _mptep.monitoring_point_trigger_expression_id = _mpte.monitoring_point_trigger_expression_id
LEFT JOIN ahm.monitoring_point_trigger _mpt ON _mpte.monitoring_point_trigger_id = _mpt.monitoring_point_trigger_id
LEFT JOIN ahm.monitoring_point _mp ON _amptp.monitoring_point_id = _mp.monitoring_point_id
JOIN ahm.monitoring_point_trigger_expression_parameter _mptep1 ON _amptp.monitoring_point_trigger_expression_parameter_id = _mptep1.monitoring_point_trigger_expression_parameter_id
JOIN ahm.monitoring_point_trigger_expression _mpte1 ON _mptep1.monitoring_point_trigger_expression_id = _mpte1.monitoring_point_trigger_expression_id
JOIN ahm.monitoring_point_trigger _mpt1 ON _mpte1.monitoring_point_trigger_id = _mpt1.monitoring_point_trigger_id
LEFT JOIN ahm.monitoring_point_type _mpt2 ON _mptep1.monitoring_point_type_id = _mpt2.monitoring_point_type_id
JOIN ampc.asset _a ON _amptp.asset_id = _a.asset_id