Hi

I am still new working with Joomla, and love your extension's DataTables. I have the following DB Query which works, but I am trying to make it dynamic to the current user:

SELECT
kech_Facility,
kech_tag

FROM `KE_db1` as k INNER JOIN track_db2 as tr on k.kech_Group=tr.hsj_hs_Name where tr.hsi_j_key=923 and kech_Facility is not null order by kech_Facility asc, kech_Location asc


in the query the part tr.hsi_j_key =923 uses the joomla id (in this case hardcoded to 923)

Any help would be greatly appreciated

Craig

Hello,

Use {$UserId} predefined variable:



Regards,
ARI Soft

Thanks so much. Worked exactly right