Data Assist Featured Item
I am trying to create a featured plugin using dataassist and framework builder. I have created my data assist pages and I am able to implement framework builder ok. Basically I have an insert form on my admin page that allows users to assign a item as featured.
The issue I am having really is with my recordset. I just wanted to know how I could filter my recordset in MYSQL and/or DA Search to only show 1 record. I would like to filter the recordset by date (timestamp) DESC. This will mean that only the most recent inserted record would be featured.
Your help is greatly appreciated