Restrictions on multiple values in Smartlist Builder
Folks
Recently there was a request which came up in the news groups on the restrictions in smartlist. The requirement was to add a filter to the smartlist builder object on a range of values, and the important fact was that it was not a continuous range.
When I was believing there was no option available in smartlist builder to achieve the same and the best way to achieve the same was by creating a custom SQL view with the filter and using the view to create a smartlist builder object, Devon Southall posted a response which was very helpful in this scenario, and I wanted to share it with you all, since I am sure it would benefit all.
Under the restriction options, we have a couple of options like “Is Equal to One of List” and “Is Not Equal to One of List”, as shown below.
When one of these options are picked, the system allows us to add the various values which needs to be filtered in into a list box as shown below.
So we have an option to restrict the records matching these values (or) to restrict the records that do not match these values in the list. This was a very helpful note from Devon and it definitely was a wonderful tip on the Smartlist Builder restriction capabilities, and so I decided to post this article. Thanks Devon.
I am sure it would be useful for you folks as well. Until next post…
March 13, 2010
· 
veeyeskay · 
2 Comments
Tags: Restrictions, Smartlist, Smartlist Builder · Posted in: Dynamics, Great Plains, Smartlist Builder Total Views: 606
-
http://gpbuilders.wordpress.com Devon Southall
-
veeyeskay