SmartList Wildcards

The Google-fu is weak with this one (this one being me). I read a post ages ago on the subject of SmartList wildcards which looked like it would be really useful, but then, after I’d forgotton the details, couldn’t find it again no matter what searches I tried.

Then, a couple of days ago, Tim Cruickshank, on the Rose Business Solutions blog, posted a few tips and tricks he’d picked up at Convergence, one of which was SmartList Wildcards.

I’ve since found the original post which turns out to have been from Frank Hamelly on his GP2themax blog.

The wildcards which are available in SmartList are;

% Use as a wildcard for zero or more characters
_ Use as a wildcard for exactly one character
[charlist] Use as a wildcard for any single or multiple characters in a list
[^charlist] Use as a wildcard for any single or multiple characters not in a list

The following screenshot shows the Search window from SmartList filtering Vendors with a name beginning A, B, C or D where the city they’re in does not begin with a C;

SmartList - Search with wildcards

Ian Grieve

About Ian Grieve

Ian is a Microsoft Dynamics GP certified consultant specialising in the delivery of Microsoft Dynamics GP projects and currently working for Perfect Image Ltd., a Microsoft Partner and VAR in the North East of England. Ian has worked with Microsoft Dynamics GP since 2003 and, over the nine years since, has dealt with all aspects of the product life-cycle from presales, to implementation, to technical and functional training, to post go-live support and subsequent upgrades and process reviews. In his spare time, Ian runs the azurecurve | Ramblings of a Dynamics GP Consultant blog dedicated to Microsoft Dynamics GP and related products.
This entry was posted in Dynamics, GP, Microsoft and tagged , , , , , , . Bookmark the permalink.

One comment on “SmartList Wildcards

  1. Pingback: SmartList Wildcards | Interesting Findings & Knowledge Sharing

Leave a Reply

Your email address will not be published. Required fields are marked *


* Copy This Password *

* Type Or Paste Password Here *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>