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 bottom
Post Reply
Post New Topic
Page: 1
TOPIC: Showing a specific range in different grids...
#297
Showing a specific range in different grids... 1 Year, 11 Months 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
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
oneguy
Fresh Boarder
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
Reply Quote
 
#298
Re:Showing a specific range in different grids... 1 Year, 11 Months 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
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
viljem
Admin
Posts: 181
graphgraph
User Offline Click here to see the profile of this user
Last Edit: 2010/02/17 14:09 By viljem.
Reply Quote
 
#309
Re:Showing a specific range in different grids... 1 Year, 11 Months 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.
Enter code here   
Please note: although no board code and smiley buttons are shown, they are still usable.
oneguy
Fresh Boarder
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
Reply Quote
 
Go to top
Post Reply
Post New Topic
Page: 1
Moderators: tomaz
Tools JX, Powered by Joomla!; Joomla templates by SG web hosting