ARI Soft - Referencing Joomla current use/group in SQL query

Featured Demos

e-mail: info@ari-soft.com

Shopping Cart

You currently have 0 items in your cart.

Recent Events

23/11/2024 Black Friday 2024

BIG SALE, 30% discount for all our extensions. Use BF24 coupon code. Hurry up the discount is valid till 3 December.

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

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

Welcome, Guest
Please Login or Register. Lost Password?

Referencing Joomla current use/group in SQL query

(1 viewing) (1) Guest

Page: 1

TOPIC: Referencing Joomla current use/group in SQL query

Forum Tools

#40292

Referencing Joomla current use/group in SQL query 11 Years, 7 Months ago	Karma: 0
Hi, We have a requirement where we need to retrieve data from a table based on who is logged in and their group. Is it possible and if yes, how can we reference the Joomla userid/group in the where clause of the query that we specify when we configure the Ari Data Table. Thanks, KI

fz9sgh

The administrator has disabled public write access.

#40297

Re:Referencing Joomla current use/group in SQL query 11 Years, 7 Months ago Karma: 760

Hello,

You can use {$UserId} and {$UserGroupId} predefined variables in "WHERE" clause of "SELECT" SQL query. For example:

Code:



SELECT

 id,

 name

FROM

 #__users

WHERE

 id = {$UserId}

Regards,
ARI Soft

admin

The administrator has disabled public write access.

Page: 1

Useful Links