Hi,

I was wondering if it is possible to display data based on the user that is requesting it?

We would like to display customer order details but only the details of that particular customer. So for example, JoeBloggs logs into the website and clicks on the my orders link, this triggers a sql query that checks the current username and extracts out all records that pertain to that user only.

This is necessary to stop customers viewing other customers order details.

Lastly, is it possible to make one of the table cells (or its contents) linkable? Again an example would be the list of orders and that would contain a link called "Order Details" which would bring up a more detailed view of the order.

Thank you

Hello,

Sorry, but ARI SQL table plugin can display data which getting by SQL query. It haven't possibility execute query depends on 'userId' without additional programming. We are going to extend plugin functionality in future.

Regards,
ARI Soft

OK, thank you for the quick reply!