foto1
Make it simple to transparently display data on a website. Tools JX is a set of database reporting tools for Joomla! All of them are made to be very intuitive and as simple to use as possible.
foto1
Paid Downloads is a solution for you! It is a lightweight and simple-to-use extension, that makes your e-commerce simple and manageable. It uses PayPal's service to execute transactions.


Tools JX

Joomla plugins


Welcome, Guest
Username: Password: Remember me
This is the optional Forum header for the Suggestion Box.

TOPIC: Have a grid based on an SQL statement

Have a grid based on an SQL statement 5 years 2 weeks ago #346

Hello,

I would like to find out if it is feasible to have the possibility to create a grid based on an sql statement? That would really be handy, as I need to display information which is in more than one table.

Adelheid
Last Edit: 5 years 2 weeks ago by viljem.
The administrator has disabled public write access.

Re:Have a grid based on an SQL statement 5 years 2 weeks ago #347

  • viljem
  • viljem's Avatar
  • OFFLINE
  • Administrator
  • Posts: 178
  • Karma: 0
Hi,

In admin section not entirely, just part in WHERE section. It is supposed to be as much as possible user friendly also to those who don't know anything about SQL.

But if you create SQL view in e.g. phpMyAdmin for Mysql, or Oracle or MS-SQL tools, you can display SQL view with TableJX. This means that you can present any data, almost whatever you can do with SQL. With this ability are possibilities almost endless.

Best regards,
Viljem
Last Edit: 5 years 2 weeks ago by viljem.
The administrator has disabled public write access.
Time to create page: 0.146 seconds