V7 {FRAMEWORK USER} and Joomla

This site is best viewed in a modern browser with JavaScript enabled.

patgaytx

In the v7 docs, it says I can: $q->external_user = "USERID"; to get the user and then call {FRAMEWORK USER} in the SQL.
I'm using Joomla and Reportico 4.6 and would like to move to v7. Can you tell me how I can accomplish this without having the Joomla module?

patgaytx

Any ideas?

peterdeed

Hi there... apologies for very late response...

Here is the answer .. after installing the v7 package you should be able to do exactly mentioned above but the way to do it is
- go to reportico top level folder copy start.php to say user.php
- edit user.php and uncomment/change line

$reportico->external_user = "<CURRENT USER>";

$reportico->external_user = "joomla user";

or if you are passing in a user like "https://..../reportico/user.php?user=5 you can use

$reportico->external_user = $_REQUEST["user"];

in your report use sql like as follows -
```
SELECT x
FROM  y
WHERE 1 = 1  
and user = {FRAMEWORK_USER}
```

So now you can use reportico against your joomla database for a given user...

Hope that helps let me know and ill try to be more responsive!!!