How to do SQL report for *current user*

How to do SQL report for *current user*

by Alejandro Cemylto -
Number of replies: 2

Hi There,

I hope someone will help me here. i made an SQL queury but i need to make it somehow show only the rsults for the user who clicks on it( current user)

as an example this SQL queury shows the username and last login columns. when i click on it, it shows ALLLL users usernames and their lastlogins.

How do i make it show only

* MY username and MY last login when i click on the report.

* Your username and Your Lastlogin when you click ?

Thanks,

Ale

Average of ratings: -
In reply to Alejandro Cemylto

Re: How to do SQL report for *current user*

by Martin Contreras -

Hi Alejandro,

Sorry I was a little bit busy. 

In your query add these token %%USERID%% 

For example in a post discussion add userid=%%USERID%%

Average of ratings: Useful (1)
In reply to Martin Contreras

Re: How to do SQL report for *current user*

by José Miguel Andonegi -

Hi Martin:

I've not been able to find a list of admited tokens. Witch ones are available appart from %%USERID%%?

Thanks!

Average of ratings: -