@SuppressWarnings("unchecked")
  public EventExternalEventMappingVoCollection getEventExternalEventMapping(
      EventRefVo voRef, PreActiveActiveInactiveStatus status) {
    DomainFactory factory = getDomainFactory();
    ArrayList markers = new ArrayList();
    ArrayList values = new ArrayList();

    String query =
        "select eeem from EventExternalEventMapping as eeem where eeem.event.id = :idEvent";
    markers.add("idEvent");
    values.add(voRef.getID_Event());

    if (status != null) {
      query += " and eeem.event.status = :status";
      markers.add("status");
      values.add(getDomLookup(status));
    }

    List eeem = factory.find(query, markers, values, 1000);
    return EventExternalEventMappingVoAssembler
        .createEventExternalEventMappingVoCollectionFromEventExternalEventMapping(eeem);
  }