Skip to main content
  Friday, December 13 2019
  5 Replies
  1.6K Visits
  Subscribe
Hello,

is it possible to set the SQL query condition to = current logged in joomla user?

In other words.

Is it possible to create one table, which will show data that belongs to the current logged in user?

And my second question...

Is it possible to create a table which will display different values extracted from the database?

For example:

Visitors: 340
Users: 2323

I would need to different SQL queries for those two values.
A
4 years ago
Hi,

Thanks for contacting us here about this extension.

is it possible to set the SQL query condition to = current logged in joomla user?

In other words.

Is it possible to create one table, which will show data that belongs to the current logged in user?


Our droptables will get data from your database only. So it's possilbe if this parameter is stored in your database.

Is it possible to create a table which will display different values extracted from the database?

For example:

Visitors: 340
Users: 2323

I would need to different SQL queries for those two values.

You can create a new table by joining 2 or more tables, then select which columns will be shown. For more details:
https://www.joomunited.com/documentation/droptables-documentation#toc-vii-tables-from-database

Hope it helps!
Cheers,
M
4 years ago
Thank you for your second answer. Great solution!

With my first question. I am not sure, if I understood you correct.

With a table I want to write a query like:

$user = Factory::getUser();
$query = "SELECT * FROM table_data WHERE user_id = $user"

This way the table will only show data, that belongs to the current logged in joomla user.

Is this possible???
A
4 years ago
Hi,

Thanks for getting back to me with more information.

With my first question. I am not sure, if I understood you correct.

With a table I want to write a query like:

$user = Factory::getUser();
$query = "SELECT * FROM table_data WHERE user_id = $user"

This way the table will only show data, that belongs to the current logged in joomla user.

Is this possible???


It seems not possible with our Droptables.

Cheers,
M
4 years ago
Really? How we are suppost to handle private user data then?

Too bad.
A
4 years ago
Hi,

Thanks for your message.

Really? How we are suppost to handle private user data then?


Yes, that's not possible with our Droptables. I'm not sure about the technical issue, please drop us a ticket (menu Support > Ticket support).
Our developer in charge will take a look at that.

Cheers,
  • Page :
  • 1
There are no replies made for this post yet.