Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- Hex(hec_act_plannedactions.HEC_ACT_PlannedActionID) AS action_id,
- hec_act_plannedactions.IsPerformed AS performed,
- hec_act_performedactions.IfPerfomed_DateOfAction AS performed_on_date,
- hec_act_performedaction_diagnosisupdate_localizations.IM_PotentialDiagnosisLocalization_Code
- FROM
- hec_cas_case_relevantplannedactions
- INNER JOIN hec_act_plannedactions ON hec_cas_case_relevantplannedactions.PlannedAction_RefID =
- hec_act_plannedactions.HEC_ACT_PlannedActionID AND hec_act_plannedactions.Tenant_RefID =
- x'3CC9B86BF340704696977DDB940A51E1' AND hec_act_plannedactions.IsDeleted = 0
- INNER JOIN hec_act_plannedaction_2_actiontype ON hec_act_plannedactions.HEC_ACT_PlannedActionID =
- hec_act_plannedaction_2_actiontype.HEC_ACT_PlannedAction_RefID AND hec_act_plannedaction_2_actiontype.Tenant_RefID =
- x'3CC9B86BF340704696977DDB940A51E1' AND hec_act_plannedaction_2_actiontype.IsDeleted = 0
- INNER JOIN hec_act_actiontype ON hec_act_plannedaction_2_actiontype.HEC_ACT_ActionType_RefID =
- hec_act_actiontype.HEC_ACT_ActionTypeID AND hec_act_actiontype.Tenant_RefID = x'3CC9B86BF340704696977DDB940A51E1'
- AND hec_act_actiontype.IsDeleted = 0
- LEFT JOIN hec_act_performedactions ON hec_act_plannedactions.IfPerformed_PerformedAction_RefID =
- hec_act_performedactions.HEC_ACT_PerformedActionID AND hec_act_performedactions.Tenant_RefID =
- x'3CC9B86BF340704696977DDB940A51E1' AND hec_act_performedactions.IsDeleted = 0
- LEFT JOIN hec_act_performedaction_diagnosisupdates ON hec_act_performedactions.HEC_ACT_PerformedActionID =
- hec_act_performedaction_diagnosisupdates.HEC_ACT_PerformedAction_RefID AND
- hec_act_performedaction_diagnosisupdates.Tenant_RefID = x'3CC9B86BF340704696977DDB940A51E1' AND
- hec_act_performedaction_diagnosisupdates.IsDeleted = 0
- LEFT JOIN hec_act_performedaction_diagnosisupdate_localizations
- ON hec_act_performedaction_diagnosisupdates.HEC_ACT_PerformedAction_DiagnosisUpdateID =
- hec_act_performedaction_diagnosisupdate_localizations.HEX_EXC_Action_DiagnosisUpdate_RefID AND
- hec_act_performedaction_diagnosisupdate_localizations.Tenant_RefID = x'3CC9B86BF340704696977DDB940A51E1' AND
- hec_act_performedaction_diagnosisupdate_localizations.IsDeleted = 0
- INNER JOIN hec_cas_cases ON hec_cas_case_relevantplannedactions.Case_RefID = hec_cas_cases.HEC_CAS_CaseID
- WHERE
- hec_cas_case_relevantplannedactions.Tenant_RefID = x'3CC9B86BF340704696977DDB940A51E1' AND
- CAST(hec_cas_cases.CaseNumber AS UNSIGNED) = 12791 AND
- hec_act_actiontype.GlobalPropertyMatchingID LIKE '%after%'
- ORDER BY
- hec_cas_case_relevantplannedactions.Creation_Timestamp
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement