Forums

Is there a way to get this query in ChronoConnectivity to work?

SELECT * FROM #_redevent_register
LEFT JOIN #_rwf_submitters ON #_redevent_register.submit_key=#_rwf_submitters.submit_key
LEFT JOIN #_rwf_forms_X ON #_rwf_submitters.answer_id=#_rwf_forms_X.id
WHERE #_redevent_register.xref='Y' AND #_redevent_register.uid='{logged_in}'
ORDER BY #_rwf_submitters.submission_date;

I would like to show only the result for user who is logged in and I wnat them to be able to edit values in #_rwf_forms_X.

I use this SQL query in HeidiSQL.

Hi JeLu,

The standard ChronoConnectivity doesn't support complex queries like this.

But . . . the LEFT JOINs in this query aren't used except for the ORDER BY clause so you could run the query without them by using a different order. This would look like

SELECT * FROM `#_redevent_register` AS r
WHERE r.`xref` = 'Y' AND r.`uid` = '{logged_in}' ;

There are aso hacked versions of ChronoConnectivity in the forums here that can accept complex queries; one of these might be the answer.

Bob