Home News Contact Us Forum About Us Demos Products F.A.Q.
Shopping Cart
You currently have 0 items in your cart.


Recent Events
  • 31/12/2023 New Year SALE

    We are glad to announce New Year SALE. 25% discount for all our extensions. Use NY24 coupon code. Hurry up the discount is valid till 7 January.

  • 21/11/2023 BLACK FRIDAY 23 is coming

    BIG SALE, 35% discount for all our extensions. Use BF23 coupon code. Hurry up the discount is valid till 27 November.


2Checkout.com, Inc. is an authorized retailer of goods and services provided by ARI Soft. 2CheckOut




Follow us on twitter



Welcome, Guest
Please Login or Register.    Lost Password?

Managing multiple SQL queries for reports
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Managing multiple SQL queries for reports
#44116
Managing multiple SQL queries for reports 10 Years, 10 Months ago Karma: 0
I want to use ARI Data Tables to produce a number of "canned" reports in our Joomla website front end. I have set up a couple of different queries using 2 different ARI DT modules each with different SQL statement.

Is this the best method to use or am I missing a trick? Is there any way to change the SQL that a module uses dynamically?
The administrator has disabled public write access.
 
#44117
Re:Managing multiple SQL queries for reports 10 Years, 10 Months ago Karma: 748
Hello,

If you want to use the same module settings and use different SQL queries, it can be done with help of "Modules Anywhere" or "Module Plant" plugin (or similar extension which supports module parameters overriding). These plugin can load Joomla! module into a content and supports ability to override some module parameters (in your case it is SQL query).

Regards,
ARI Soft
The administrator has disabled public write access.
 
#44145
Re:Managing multiple SQL queries for reports 10 Years, 10 Months ago Karma: 0
Thanks for quick reply. I now understand the choices but think I will stick with multiple modules for now.
The administrator has disabled public write access.
 
#45244
Re:Managing multiple SQL queries for reports 10 Years, 8 Months ago Karma: 0
Hi Glid1965 - quick question, how did you install multiple modules of ARI DT? I am trying to do the same thing you are but I haven't been able to find anything on how to install the module more than once. Thanks!

UPDATE: Nevermind, I just figured it out by duplicating the module in Joomla. Super easy. Thanks again.
Last Edit: 2013/10/14 02:19 By neilldavidson.Reason: Figured it out...
The administrator has disabled public write access.
 
Go to topPage: 1