Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Brenda Rogers]

I’m struggling to find the right tables to query in order to get a list of all Smartlists and Favorites.  The screenshot show’s what I’m looking for.  Is there a way to query this?

——————————
Brenda Rogers
Programmer Analyst
Falls of Neuse Management, LLC
Raleigh NC
——————————

[John Arnold]

Hi Brenda,

I saved a smartlist as a favorite with a unique name.  I found that name in the tables/columns below in my DYNAMICS database.  I hope this helps.

Table            Column

SLB10000    SmartList_ID
SLB10000    SmartList_Item_Name
SLB10000    SmartList_Name
SLB10100    SmartList_ID
SLB10100    TBLPHYSNM
SLB10200    SmartList_Display_Name
SLB10200    SmartList_Field_Name
SLB10200    SmartList_ID
SLB10200    TBLPHYSNM
SLB10600    SmartList_Field_Name
SLB10600    SmartList_ID
SLB21000    Favorite_Name
SLB80400    TBLPHYSNM
SY01404    Report_Option_Name
SY09400    DSPLNAME

Good Luck!

——————————
John Arnold
Senior Software Engineer
US Digital
Vancouver WA
——————————
——————————————-