Is it possible to use SQL to write a script to provide a listing of all Smartlists across all products? I am looking for the main folder and then all Smartlists under each folder. What are the proper tables and linkages?
Thanks, this does work great. I will add this to my GP SQL bag of tricks!
Thanks, it appears they have been using Smartlist Designer as there are custom Smartlists. The problem I have is they just created a new company with a different fiscal year. The GL Smartlists that exist do not match this new company and since they were deployed as system cannot be used. I will recreate them just for this new company.
Period 1 in this new company is January where in all the other companies Period 1 is July.
This works great!
use DYNAMICS
select isnull(TRANSVAL, '') SmartList, ASI_Favorite_Name Favorite,
Module = case when asi_favorite_dict_id = 3830 then 'SLB' else 'GP' end,
a.CMPANYID, isnull(CMPNYNAM,'') CompanyName, USRCLASS, USERID
from [ASIEXP81]​ a
left join [ASITAB30] b on a.[ASI_Favorite_Name] =b.UNTRSVAL
left join [SY01500] c on a.cmpanyid = c.cmpanyid
The ASITAB30 table seems to have a list of the default SmartList reports.
For custom SmartList reports, the ADH00100 would probably be the easiest to use.
SmartList Favorites are held in the ASIEXP81 table along with custom SmartList reports.
If using SmartList Builder from eOne, they have their own tables as well.
Thanks
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Andrés Arias as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Sohaib Cheema 785 User Group Leader
André Arnaud de Cal... 626 Super User 2025 Season 2
Martin Dráb 621 Most Valuable Professional
