I would like to use the following query, however, I would like to be able to pick up all open tickets based on a data parameter.

Current Query:

SELECT "sdo"."NAME" AS "Site", "wo"."WORKORDERID" AS "Request ID", "mdd"."MODENAME" AS "Request Mode", "aau"."FIRST_NAME" AS "Requester", "cri"."FIRST_NAME" AS "Created By", "ti"."FIRST_NAME" AS "Technician", "wotodesc"."FULLDESCRIPTION" AS "Description", "sdo"."NAME" AS "Site", "std"."STATUSNAME" AS "Request Status", "wo"."CREATEDTIME" AS "Created Time"  FROM "WorkOrder" "wo" LEFT JOIN "ModeDefinition" "mdd" ON "wo"."MODEID"="mdd"."MODEID" LEFT JOIN "SDUser" "sdu" ON "wo"."REQUESTERID"="sdu"."USERID" LEFT JOIN "AaaUser" "aau" ON "sdu"."USERID"="aau"."USER_ID" LEFT JOIN "SDUser" "crd" ON "wo"."CREATEDBYID"="crd"."USERID" LEFT JOIN "AaaUser" "cri" ON "crd"."USERID"="cri"."USER_ID" LEFT JOIN "WorkOrderToDescription" "wotodesc" ON "wo"."WORKORDERID"="wotodesc"."WORKORDERID" LEFT JOIN "SiteDefinition" "siteDef" ON "wo"."SITEID"="siteDef"."SITEID" LEFT JOIN "SDOrganization" "sdo" ON "siteDef"."SITEID"="sdo"."ORG_ID" LEFT JOIN "WorkOrderStates" "wos" ON "wo"."WORKORDERID"="wos"."WORKORDERID" LEFT JOIN "SDUser" "td" ON "wos"."OWNERID"="td"."USERID" LEFT JOIN "AaaUser" "ti" ON "td"."USERID"="ti"."USER_ID" LEFT JOIN "StatusDefinition" "std" ON "wos"."STATUSID"="std"."STATUSID" WHERE  ((("wo"."CREATEDTIME" >= 1501560000000) AND (("wo"."CREATEDTIME" != 0) AND ("wo"."CREATEDTIME" IS NOT NULL))) AND (("wo"."CREATEDTIME" <= 1501646399000) AND ((("wo"."CREATEDTIME" != 0) AND ("wo"."CREATEDTIME" IS NOT NULL)) AND ("wo"."CREATEDTIME" != -1))))  AND wo.ISPARENT='1'  ORDER BY 1

Any help is greatly appreciated.