SQL queries in Plot a lot

[Racmitch]

I am working on connecting the data visualization component "Plot-a-lot" through Fabrik so that charts and graphs can be made by the input of users through Fabrik forms. I have gotten it to work so far as pulling the data from specific tables to make the charts, the one piece I'm missing at this early stage is the command i need to make to the data base to pull just a specific user ID so they only see what they entered in the form to create the chart. I know in Fabrik we use {$my->id} but the SQL course I'm taking hasn't address a unique user ID and I'd like to get it figured out to keep moving forward. If you like, I'm keeping a lot of notes and i would be honored to set up a wiki page to show how I did this with all the commands for others to use.

 

[cheesegrits]

Iirc, plotalot uses %%J_USER_ID%% as the placeholder for logged on user id. So ...

WHERE user_id = '&&J_USER_ID%%'

You may or may not need the single quotes.

-- hugh

 

[Racmitch]

thanks Hugh, I'll update things as I go along.