Hi Bernie,
if you use the where clause dtstart > now() the program adds it quoting the value as 'now()', this is correct end expected, done for security reason and to prevent SQL errors.
BUT, you have full control on the query used because you can edit the raw SQL query and discard the SQL compiiler parameters.
So you can have a edited custom SQL query added the the final textarea, then click 'Save' button to apply it.
| Code: |
SELECT e.ev_id
FROM jos_jevents_vevent AS e
LEFT JOIN jos_jevents_vevdetail AS ed ON e.ev_id = ed.evdet_id
LEFT JOIN jos_community_fields_values AS fv ON fv.user_id = e.created_by
LEFT JOIN jos_community_fields AS cf ON cf.id = fv.field_id
WHERE
e.state = 1
AND
fv.field_id = 19
AND from_unixtime(ed.dtstart) > CONVERT_TZ( now(), fv.value, "US/Eastern" )
|
take care to use the correct MySql syntax.
Finally, for JEvents there is also a predefined data source to import already configured to include only future events, find the file also in attachment for your convenience (unzip the archive and import the json file into JSitemap)
Greetings,
John
