Share
ReportIs there any way to export a SmartList definition if you don't have SmartList Builder?
*This post is locked for comments
You’re offline. This is a read only version of the page.
315
Is there any way to export a SmartList definition if you don't have SmartList Builder?
*This post is locked for comments
Yes Smartlist Designer will do the Job, if you are on GP 2013 SP2. When you create a smartlist in Smartlist designer, you can click on 'Execute' button which generates SQL query which can be used in external environments. The SQL query is very much readable to an end-user.
Hope this helps.
The smart list designer doesn't create a new view. The SQL script is dynamically built up each time you press on the new Smart List, key data fields are stored in ADH tables (ADH00100, ADH00101, ADH00102, ADH00103, ADH00104).
Your feedback is highly appreciated,
Gotcha. I'm not sure if SmartList Designer uses the same or additional tables as SmartList, but you could check the ASIxxxxx tables, which are SmartList. You might be able to copy and insert the table contents from one instance to another.
You mean SmartList Favorites? Or are we talking SmartList Designer in GP 2013?
If you need a definition for an out of the box SmartList, you'll find them in the Integration Guide for Dynamics GP in Part 7. You can download the guide for your GP version here - www.microsoft.com/.../DownloadResults.aspx.
Hope this helps,
All responses (
Answers (
