Welcome, Guest
Please Login or Register.    Lost Password?

Have a grid based on an SQL statement
(1 viewing) (1) Guest
This is the optional Forum header for the Suggestion Box.
Go to bottomPage: 1
TOPIC: Have a grid based on an SQL statement
#346
Have a grid based on an SQL statement 4 Months, 3 Weeks ago Karma: 0
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
apaternoster
Fresh Boarder
Posts: 4
graphgraph
User Offline Click here to see the profile of this user
Gender: Female Birthday: 02/25
Last Edit: 2010/03/07 06:28 By viljem.
The administrator has disabled public write access.
 
#347
Re:Have a grid based on an SQL statement 4 Months, 3 Weeks ago Karma: 1
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
viljem
Admin
Posts: 145
graph
User Offline Click here to see the profile of this user
Last Edit: 2010/03/07 06:03 By viljem.
The administrator has disabled public write access.
 
Go to topPage: 1
Tools JX, Powered by Joomla!; Joomla templates by SG web hosting