ARI Soft - Update VIEW or delete etc

Featured Demos

e-mail: info@ari-soft.com

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.

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?

Update VIEW or delete etc

(1 viewing) (1) Guest

Page: 1

TOPIC: Update VIEW or delete etc

Forum Tools

#42229

Update VIEW or delete etc 11 Years ago	Karma: 0
Is it possible to drop and create a VIEW using a query from Ari Data tables? Basically, I need a mysql view to be dynamic based on the user current logged in. How can I achieve this?

timtenn

The administrator has disabled public write access.

#42230

Re:Update VIEW or delete etc 11 Years ago	Karma: 748
Hello, It is possible to use {$UserId} predefined variables in "WHERE" clause of "SELECT" SQL query. It will be replaced with ID of currently logged user. Sample query: SELECT id, title FROM #__content WHERE created_by = {$UserId} Regards, ARI Soft

admin

The administrator has disabled public write access.

Page: 1

Useful Links