QueryDSL union

[Kavitha Reddy]

Could some one please help me in writing the below query in querydsl. I am new to Querydsl.

 SELECT *
    FROM
      (SELECT V.ID AS VID,
        V.MODEL,
        V.VIN,
        V.EXTERIOR_COLOR,
        V.LICENSE_PLATE,
        V.CURRENT_LOCATION,
        V.NOTES,
        C.ID AS CID,
        PFIS_COMMON_OPS.FORMATNAME(C.FIRST_NAME,C.LAST_NAME,C.MIDDLE_NAME,2) AS JOURNALIST_NAME ,
        C.LICENSE_AFFI_NAME  AS AFNAME,
        L.DATE_OUT  AS DAYOUT,
        L.DATE_IN   AS DAYIN,
        NULL  AS HOLD,
        ''   AS REASONS,
        NULL AS ADATE,
        L.LOAN_TYPE_ID  AS TYPEID
      FROM PFIS_VEHICLE_DETAILS V,
        PFIS_CONTACT C,
        PFIS_VEHICLE_CONTACT_LOAN L
      WHERE C.ID          =L.CONTACT_ID
      AND V.ID            =L.VEHICLE_ID
      AND L.LOAN_TYPE_ID IN (1,5)
      AND ( L.DATE_IN BETWEEN TO_DATE('04/01/2014','DD/MM/YYYY') AND TO_DATE('05/10/2014','DD/MM/YYYY')
      OR L.DATE_OUT BETWEEN TO_DATE('04/01/2014','DD/MM/YYYY') AND TO_DATE('05/10/2014','DD/MM/YYYY'))
    -- AND LOWER(V.CURRENT_LOCATION) = 'new york'
      UNION
      SELECT V.ID AS VID,
        V.MODEL,
        V.VIN,
        V.EXTERIOR_COLOR,
        V.LICENSE_PLATE,
        V.CURRENT_LOCATION,
        V.NOTES,
        0                  AS CID,
        ''                 AS JOURNALIST_NAME ,
        ''                 AS AFNAME,
        NULL               AS DAYOUT,
        NULL               AS DAYIN ,
        S.ON_HOLD_TILL     AS HOLD,
        S.REASONS_FOR_HOLD AS REASONS,
        S.ANTICIPATED_DATE AS ADATE,
        -1                 AS TYPEID
      FROM PFIS_VEHICLE_DETAILS V,
        PFIS_VEHICLE_DETAIL_STATUS S
      WHERE V.ID     =S.VEHICLE_ID
      AND S.STATUS_ID=4
      AND ( S.ANTICIPATED_DATE BETWEEN TO_DATE('04/01/2014','DD/MM/YYYY') AND TO_DATE('05/10/2014','DD/MM/YYYY')
      OR S.ON_HOLD_TILL BETWEEN TO_DATE('04/01/2014','DD/MM/YYYY') AND TO_DATE('05/10/2014','DD/MM/YYYY'))
      --AND LOWER(V.CURRENT_LOCATION) = 'new york'
    )

Thanks in advance