RSSCategory: Smartlist Builder

Smartlist Builder Example – Sub Query Restriction Prototype

| 11/01/2011 | 2 Comments
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 = […]

Continue Reading

Restrictions on multiple values in Smartlist Builder

| 03/13/2010 | 2 Comments
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 […]

Continue Reading

Smartlist Builder Objects using SQL Tables and Views

| 12/23/2008 | 1 Comment
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 […]

Continue Reading