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

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?

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, 5 Months 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, 5 Months ago	Karma: 760
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