Updated custom controller method for goalsnoposts to GET only published goals
To prevent goals in draft mode from showing up in the Featured Goals sidebar, as per request of @brianball. Had to tweak the SQL query (that fetches data for Featured Goals), by adding the IS NOT NULL statement:
WHERE g.published_at IS NOT NULL
WHERE g.published_at IS NOT NULL