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 |
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.
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
Share
Report
75,848
All responses (
Answers (
