Welcome, Guest
Please Login or Register.    Lost Password?

Showing a specific range in different grids...
(1 viewing) (1) Guest
Welcome to the ToolsJX forum!


Go to bottomPage: 1
TOPIC: Showing a specific range in different grids...
#297
Showing a specific range in different grids... 5 Months, 1 Week ago Karma: 0
Hello

I just your plug in and I have a question...
We have a table in the DB that's called destinations.
Inside it we have 6 columns

time days destination level price registration

How can we display only a specific range out of each column in
different articles using different grids (?)

Our purpose is that there will be a big grid with all the
data for all destinations and on the web site there will be different tables showing only the data that will be specific
for each destination.


Thanks

I'm not so much of an expert in coding...

This is urgent for us...

Guy
oneguy
Fresh Boarder
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#298
Re:Showing a specific range in different grids... 5 Months, 1 Week ago Karma: 1
Hi,

example for 3 grids and their ranges:

1. prepare grid
2. in WHERE section (see documentation)
create range:
level>=0 and level<=3

3. Save grid
4. Insert grid on one of three articles (insert button)

Repeat these steps for other 2 articles with their grid ranges.

You can create even more sophisticated ranges or filters, using operators on one or more columns.

example:
(id>=0 and id<=3) and (registration='Public' OR registration='Special')

Best regards,
Viljem
viljem
Admin
Posts: 145
graph
User Offline Click here to see the profile of this user
Last Edit: 2010/02/17 14:09 By viljem.
The administrator has disabled public write access.
 
#309
Re:Showing a specific range in different grids... 5 Months, 1 Week ago Karma: 0
Thank you Viljem!
This exactly what we want.

This component works really great.

Another question: Do you know a good database editor component (free) for joomla?
I want my client will update the database easily via the joomla interface...

Thanks,
Guy.
oneguy
Fresh Boarder
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 1
Tools JX, Powered by Joomla!; Joomla templates by SG web hosting