where does &where get the json keys.
snippet working great aside from I want to only grabe where I set my active field to active
here is what it looks like in the database
{"MIGX_id":"1","title":"Featured Business","image":"images/image.png","link":"-","start":"2013-06-03 00:00:00","end":"2013-06-30 00:00:00","active":"active"}
[[!getImageList?&tvname=`mainSponsors`&docid=`2`&randomize=`1`&limit=`1`&tpl=`mainSponsor`&where=`"active:=":"active"`]]
This does not work I assumed it grabbed the key from the key in the db? Ultimately I want to do it by start date and end date as well but If i can't get this to work that surely isn't going to work. Do i somehow need to assign active?