ARI Soft - sql query - join supported?

Home

News

Forum

About Us

Demos

Products

F.A.Q.

Featured Demos

ARI Smart Content demo

ARI Quiz demo

WordPress Quiz plugin

WordPress Lightbox plugin

e-mail: info@ari-soft.com

Shopping Cart

You currently have 0 items in your cart.

Show 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.

more...
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.

more...

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

Welcome, Guest
Please Login or Register. Lost Password?

ARI Soft Forum

Joomla components

ARI Data Tables

sql query - join supported?

(1 viewing) (1) Guest

Page: 1

TOPIC: sql query - join supported?

Forum Tools

#18976

sql query - join supported? 12 Years, 8 Months ago	Karma: 1
i want to display the alphauserpoints history (jos_alpha_userpoints_details) for current login user only. the history table does not contain userid directly. 1. history table jos_alpha_userpoints_details id, referreid, points, 2. map alphauserpoints userid to joomla userid jos_alpha_userpoints id, userid pls advise if the sql query contains join between these 2 tables, will this be supported?

chanpeter88

The administrator has disabled public write access.

#18978

Re:sql query - join supported? 12 Years, 8 Months ago Karma: 748

Hello,

You can use the next SQL query in "ARI Data Tables" extension:

Code:



SELECT

 AUD.id,

 AUD.referreid,

 AUD.points,

 AU.userid

FROM

 jos_alpha_userpoints_details AUD INNER JOIN jos_alpha_userpoints AU

   ON AUD.id = AU.id

Regards,
ARI Soft

admin

The administrator has disabled public write access.

#19087

Re:sql query - join supported? 12 Years, 8 Months ago	Karma: 1
DESC does not work. it is still ASC ==== SELECT AUD.id, AUD.datareference, AUD.points, AUD.insert_date, AUD.expire_date FROM jos_alpha_userpoints_details AUD INNER JOIN jos_alpha_userpoints AU ON AUD.referreid= AU.referreid WHERE AU.userid = {$UserId} ORDER BY AUD.insert_date DESC =========

chanpeter88

The administrator has disabled public write access.

#19093

Re:sql query - join supported? 12 Years, 8 Months ago	Karma: 748
It should work, it can be a problem with module configuration. We can investigate the issue, if you provide link to page where we can see it and screenshot of module settings page or temporary access to your J! backend by email. Regards, ARI Soft

admin

The administrator has disabled public write access.

Page: 1

Useful Links