DA Sort keeps adding parameters to query
Hi - I'm trying to use the Sort behaviour with DataBridge.
After implementing it, the results I was getting seemed really weird, so I echoed the query and my query strings are looking like this:
SELECT activity_id, activity_type, activity_ip, activity_date, activity_username FROM activity_log_admin ORDER BY activity_type ASC, activity_ip DESC, activity_date DESC, activity_username DESC
So as you can see each click on the column or toggle of order adds to the query, giving strange results. How do I prevent this so each click on the column heading sorts ONLY by that order (or desc/asc depending on subsequent clicks of the same link)?
Thanks
Dan