variables.eventDetailsCEName = getEventDetailsCEName();
variables.eventDetailsViewName = getCEViewName(variables.eventDetailsCEName);
var dataQry = QueryNew("temp");
var searchTermList = "";
var t = 1;
var d = 1;
var c = 1;
var orgIndex = 1;
var catIndex = 1;
var allOrgsSelectedValue = getAllOrganizationsDefaultValue();
SELECT DISTINCT calEventID
FROM dataQry
WHERE 1 = 1
AND CAST( eventDate AS DATE )
BETWEEN CAST( AS DATE )
AND CAST( AS DATE )
AND CAST( eventDate AS DATE ) >= CAST( AS DATE )
AND eventApproved =
AND eventApproved <>
AND (
LOWER(title) LIKE
OR
OR
LOWER(description) LIKE
OR
OR
LOWER(location) LIKE
OR
)
AND (
organization LIKE
OR
OR organization =
)
--->
AND (
category LIKE
OR
)
--->
AND lower(location) =
ORDER BY calEventID