Filters not working.

Hi all,

It seems that our filters for titles doesn't work anymore. Every time you select a title from the menu and apply the filter, it brings back no data. Has anyone had this happen to them or know how to fix this?

3replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Never mind, fixed it.

    Reply Like
      • Konrad
      • Konrad
      • 11 mths ago
      • Reported - view

      Cris Pineda I have the same issue. How did you fix this?

      Reply Like
    • Konrad Hi Konrad,

      For me, it was a matter of changing the SQL code in the filter. For some reason, they were selecting the title and then grouping by the amount of plays. For example:

      'select count(*), title from db group by 2 order by 1 desc'

      I just changed it to:

      'select distinct title from db'

      and it worked. Hopefully that helps

      Reply Like
Like Follow
  • 11 mths agoLast active
  • 3Replies
  • 161Views
  • 2 Following