get current user ID in wordpress for use as parameter in BIRT
I am new to coding and am struggeling to find a solution for the following issue: I am using BIRT and I would like to show results in the BIRT webviewer based on the current logged in user in wordpress. So basically setup a parameter (current_user_id) and use this as a hidden parameter to replace the user_id in the query on posts. I am looking in the direction of writing a sql query that ‘grabs’ the current user id. I know there is a function in WordPress to retrieve the current user_ID but I cannot use php code in BIRT.
Can anybody put me in the right direction? Is there a way to get the current user id in a mysql query or do I need to think in another direction.
Any help would be aprreciated.