Notifications
Announcements
No record found.
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?
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
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
Thanks, this does work great. I will add this to my GP SQL bag of tricks!
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 Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 664 Most Valuable Professional
André Arnaud de Cal... 522 Super User 2025 Season 2
Sohaib Cheema 303 User Group Leader
