https://antibiotiqueaugmentin.com/surdosage-augmentin-bebe/
× Welcome to the ToolsJX forum!


Showing a specific range in different grids...

  • oneguy
  • oneguy's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
14 years 2 months ago #297

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

Please Log in or Create an account to join the conversation.

More
14 years 2 months ago #298

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

Last edit: 14 years 2 months ago by user62.

Please Log in or Create an account to join the conversation.

  • oneguy
  • oneguy's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
14 years 2 months ago #309

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.

Please Log in or Create an account to join the conversation.

Moderators: tomaz
Time to create page: 0.208 seconds

Contact Us

Contact us on Discord

Contact us on Facebook