The built in Visual filter is really powerful with many more options that you would have in traditional SmartList. But there will be times that even with these filter options you can not get the exact data filters you need.

If you have a complex query that you can’t enter with the built-in visual filter editor in SmartView, you can enter a SQL script to construct complex queries. Simply select Text as the Filter Editor Mode in the Options menu.

Now when you open the Filter Editor, the SQL entry interface is displayed. This interface has intellisense enabled to suggest field names and operators. For all those familiar with SQL you can construct whatever filter criteria you require. If you are not familiar with SQL syntax than go and knock on the door of the IT department and ask for a guru OR contact the eOne consulting team who will be able to assist (at a small charge).