Archive for the ‘Smartlist Builder’ Category
Smartlist Builder Example – Sub Query Restriction Prototype
Hi all Recently, there was a discussion in the forum, where there was a request to provide a restriction on a custom smartlist, which does the same as the SQL query below. SELECT * FROM dbo.PM30600 WHERE VCHRNMBR IN ( SELECT VCHRNMBR FROM dbo.PM30600 WHERE DSTINDX IN ( 167, 256 ) ) AND dbo.PM30600.DOCTYPE = [...]
November 1, 2011 · 
veeyeskay · 
2 Comments
Tags: custom smartlist, is equal to one of list, pm distribution history, pm30600, restriction. filter, Smartlist, sql query, subquery restriction · Posted in: Dynamics, Great Plains, Smartlist Builder Total Views: 119
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 [...]
March 13, 2010 · veeyeskay · 2 Comments
Tags: Restrictions, Smartlist, Smartlist Builder · Posted in: Dynamics, Great Plains, Smartlist Builder Total Views: 605
Smartlist Builder Objects using SQL Tables and Views
Whenever we create a smartlist builder object using SQL tables and views, we need to be careful when exporting the same and importing it on to a test environment (or) the production environment. There are a few things which you need to consider when u create a smartlist builder object using SQL server tables and [...]
December 23, 2008 · veeyeskay · One Comment
Posted in: Dynamics, Great Plains, Smartlist Builder Total Views: 1,693