Skip to content
+1-888-319-3663

EONE BLOG

Tech Tuesday: Filtering Columns in SmartView


With the latest release of SmartView (18.0.6) we now have the option to filter columns more precisely.  In the past, the filter was done using only a contains operation. This release allows you to filter columns as you already have been doing on your SmartView data so you will likely be familiar with how they function.  In the below screen shot you can see the new operators available to filter your columns.





















Contains is still the default filtering operation, but you can choose any options from the list to help narrow your results down for your need.  All the operations require you to enter in some part of the column name you are looking for.  Is like, and Is not like are the two operators that offer more functionality.  If you’ve written any SQL scripts before you’re already familiar with how they are used most likely.  The “%” and “_” are wildcards that we can use for the Is like and Is not like operators.  These wildcards can also be used in together if needed.  Here are some examples using the wildcards with Is like:

a% – Finds any column that starts with “a”.

%a – Finds any column that ends with “a”.

%bank% – Finds any column that has “bank” in any position.

_a% – Finds any column that has an “a” for the second character.

c%y – Finds any column that starts with “c” and ends with “y”

 

The same examples can be used with Is not like.  The results will just be eliminated from the available columns rather than displayed.

 

Have additional questions? Shoot me a message at jared.dux@eonesolutions.com. 

Leave a Comment





RECENT POSTS


eOne Sessions at Directions North America 2023
Connect with eOne Solutions at Directions North America 2023!
Tech Tuesday: Creating a Summarize List by States Between Two Systems
eOne Sessions at Days of Knowledge UK - Live from Birmingham!
Employee Spotlight: Ally Tronson, Business Development Representative

POPULAR POSTS


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
2017 SmartConnect Integration Bootcamps
New Releases of Extender and SmartList Builder

CATEGORIES

TAGS

Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships Partner All Hands Call Popdock promotions release SalesForce SalesForce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.