Category: Smartlist Builder
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 = [...]
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 [...]
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 [...]
Loading ...