code: @Override
    public TriggerInstance getTriggerInstanceById(final String triggerInstanceId) {
      TriggerInstance triggerInstance = null;
      try {
        final Collection<TriggerInstance> res = this.dbOperator
            .query(SELECT_EXECUTIONS_BY_INSTANCE_ID,
                new TriggerInstanceHandler(SORT_MODE.SORT_ON_START_TIME_ASC),
                triggerInstanceId);
        triggerInstance = !res.isEmpty() ? res.iterator().next() : null;
      } catch (final SQLException ex) {
        handleSQLException(ex);
      }
      populateFlowTriggerProperties(triggerInstance);
      return triggerInstance;
    }
docs: Retrieve a trigger instance given an instance id. Flow trigger properties will also be
  populated into the returned trigger instance.